🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzitem.info/door/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@SWD2529
2 жыл бұрын
Can you create a video tutorial on how to create a button or macro to import an appointment from excel to outlook calendar showing how to select a specific calendar and not just the default?
@jamiewill
Жыл бұрын
This is very helpful Kevin. Thanks! Is there a way to also import Senders Name ?
@srikanthkatla308
4 ай бұрын
Amazing video❤. But, can you explain more about expressions you wrote
@_alphin_joe
3 жыл бұрын
It’s very helpful for people who needs to import Mails for their work. They need it. Helpful Video 🎬.
@HeinrichWaldeier
Жыл бұрын
Hi Kevin, lovely video that took me through the process, but I would love for you to clarify and showcase different expressions that can handle different line extractions and just a guide to these in general.
@arunkaggarwal1962
Жыл бұрын
Kevin - All your videos are very insightful and meaningful. Thank you for doing what you do to help the developer community. Would you kindly do a video to explain the formulas you used to extract 3 different values from your email? Depending on the format of the email, the values can be tricky to extract. If you can explain your formulas, then we will be able to use this in our email formats as well. Thanks in advance.🙏🙏🙏
@amrkalammansoori4411
9 ай бұрын
yeah, the expressions are keeping me hanging. I want to understand it in detail and how it is structured.
@peterxxl1244
3 жыл бұрын
Wow! How interesting and impressive is this ability to automate Excel functions with "Power Automate"! I had a whole similar problem some time ago, involving scanning emails arriving in a particular mailbox and writing the results to an Excel worksheet. So far, I've been working with a combination of an Outlook macro that responds to the "add item" event (which fires whenever a new email arrives in a mailbox) and an Excel macro that responds by writing "subject", "body" and "to" contents to a spreadsheet. The problem: the whole thing only works when the Excel workbook is open and thus active. I can't wait to experiment with this solution. Thanks a lot for this! :-)
@ulligruber1344
3 жыл бұрын
Delivery method: pigeon 🤣 Love Kevins humor 😁
@nairobi203
3 жыл бұрын
Flying cookies....
@qrsimon
2 жыл бұрын
@@nairobi203 maybe the pigeon ate them
@francismastro
3 жыл бұрын
You have no idea how much time you're saving me! Thanks and keep up the amazing tutorials.
@loloysan6417
3 жыл бұрын
BENEFICIAL! You are really a life saver Kevin, Power Automate has a lot of connectors or combination can be done but don't have time to explore each of them. Thank you very much for updating us and also sharing different use of Power Automate. Will be waiting for more video like this. Thank you for time and effort, always be safe you and your family
@SavageGothamChess
3 жыл бұрын
This is awesome! You would probably get over a 700,000 cookie orders within the next 24 hours. Another great video as always. Congrats on your hard work, you've reached 750k!
@viveksingh-nt3po
3 жыл бұрын
Very useful! Do make more videos on Windows power automate due to heightened focus on automation these days!! Thanks buddy!
@KevinStratvert
3 жыл бұрын
More to come!
@viveksingh-nt3po
3 жыл бұрын
@@KevinStratvert really appreciate your efforts in sharing the knowledge with us!!
@eleos11
3 жыл бұрын
Hey Kevin, well done! What if customers don't use the same keywords - expressions for their order? Is it possible to solve this kind of issue?
@travelwell6049
3 жыл бұрын
Video started and I thought; I’m never going to to need that. Saw data going into a spreadsheet and thought; Oh wow! I totally need that! 😂
@HenryGonzalezTv
Жыл бұрын
You are by far the best all over the internet. Thank you 🙏
@karoriz3
Ай бұрын
This is so helpful!! Thank you so much!!!
@khaledk9069
2 жыл бұрын
thank you so much for this video, it is really amazing. I have a request, would you please give us more details about formulas on how to extract data from the email body (split, skip...). thanks again
@bavandetemadi589
3 ай бұрын
Brilliant. So clear, so concise. Nice one.
@fazrinfarook7557
3 жыл бұрын
If Kevin Post a video I will watch it, whether Do I need this tutorial or not => From Sri Lanka
@VirtualkitchenwithLaura
3 жыл бұрын
I really like this method. Thank you for your knowledge.
@KevinStratvert
3 жыл бұрын
Glad it was helpful!
@fallonopperman8293
2 жыл бұрын
Thanks Kevin! I was having issues getting Step 2 until I turned off split in the settings of Step 1.
@dmclean3324
3 жыл бұрын
Beats using Power Query for sure. Looking at implementing this and then having that data go into Planner
@Milhouse77BS
3 жыл бұрын
Not sure anything beats Power Query for ease of use
@dmclean3324
3 жыл бұрын
@@Milhouse77BS Normally I would agree but getting emails into Excel using Power Query is tricky (and only supposed to be available if you have an Enterprise license). You also have to set up rules properly so you're not sorting through so much data all the time.
@erib156
2 жыл бұрын
I'm gonna cry, you changed my life! The first video simple and well explained 😍
@BrunoDallavalle
Жыл бұрын
Thank you Kevin! Took me some time to get how these functions are working, not really straightforward. If you could do some deep dive on them I'm sure it will be greatly appreciated!
@gumikebbap
2 жыл бұрын
sup Kevin great content! I think at 10:24 the expression should say 'Cookie Type' instead of 'Quantity', when looking for the Cookie Type.
@bernipremium9193
2 жыл бұрын
I thought the same!
@bryankendig3989
2 жыл бұрын
Great video. Very helpful. Could you please show expressions if row headings , “cookie “, “quantity “, “delivery method” were switched to column headings??
@vivekshanbhag7422
Ай бұрын
My flow is not getting triggered when i send an email . can someone please help me with this?
@brendamartinezgomez2297
Жыл бұрын
All your videos are very insightful and meaningful.
@DannyWiraDharma
3 жыл бұрын
Thank you so much, Kevin! I shared this video to my friends and clients.
@KevinStratvert
3 жыл бұрын
You rock!
@elishatech4600
3 жыл бұрын
since I discovered your channel I have learnt a lot from you. Thanks man keep up
@KatRG6453
Жыл бұрын
You're videos are amazing and I appreciate them so much!
@anurangaehelepola1245
10 ай бұрын
A really great explanation! Thanks for this!
@svjkswamivivekanandajnanak7052
2 жыл бұрын
Awesome presentation
@chhayakankariya2748
3 жыл бұрын
Plz make big video on excel from basic to advanced ! Thank yu
@KevinStratvert
3 жыл бұрын
This is a little older... here's an intro I filmed on Excel: kzitem.info/news/bejne/xm2ural9qpmhYIY Here's also a playlist with all my Excel content: kzitem.info/door/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@chhayakankariya2748
3 жыл бұрын
@@KevinStratvert ok tysm
@chukumaisaac6958
8 ай бұрын
Thank you for such an insightful Video. Please can you automate it to create a new sheet daily, so all emails for today will be on sheet today's date and tomorrow's emails will be on sheet 2 (tomorrow's date). Please assist anyone. Thank you all.
@MrDirewolf4377
Жыл бұрын
the hardest part of this tutorial, the expressions, gets completely glossed over. The examples given in the text don't make any sense.
@perfectpipesplumbing3992
Жыл бұрын
Everything was great, right up to the section on Expressions. It's quite a bit more complicated when you need to extract from a much larger body of text.
@huntermccall6002
Жыл бұрын
Maybe make multiple similar automations? I myself have people essentially order multiple things in one email ("x lbs of y cookie type" and curious how to reverse the order. Idk how to get something like this to figure it out so I'm pondering trying out emailparser. Have you had any other success?
@perfectpipesplumbing3992
Жыл бұрын
@@huntermccall6002 It takes a little trial and error, i.e. doing some test runs to dial it in. But between this tut and the other, I got it working. The other tut shows how to extract the data, and this tut teaches how to update the Excel sheet via updating a table.
@vidajavan6922
6 ай бұрын
Very helpful. Thank you for this great tip!
@miransh
3 жыл бұрын
Very detailed and step by step vide Kevin- thanks so much for your hard work- appreciate it ! I went thr half and gave up the idea of proceeding when codes came in - I think this is still too complex for a common person , Microsoft should still simplify this for us...and Stop forcing us to us ONE DRIVE - that a dampener- once they make you use one drive then Microsoft will keep complaining about account size--- I let it go ..thanks....
@vijayarjunwadkar
3 жыл бұрын
Super helpful tutorial Kevin! This is going to open many possibilities for me and my team! Thanks a lot! 😊👍
@RealRaze1
3 жыл бұрын
Nice video🎥
@ronniesakai9811
3 жыл бұрын
Hey kevin, quick question what if there are repetitive parameters for example Cookie type: Chocolate Chip and then Quantity etc and next paragraph same parameter Cookie type :Vanilla then quantity. Btw your tutorial video is easy to understand. keep it up !
@brunorocha2317
2 жыл бұрын
I was thinking the same question. Did you @Ronnie Sakai find a solution for that need. Kevin do you have some tips?
@rlerolle
10 ай бұрын
Hi kevin, You re doing an Amazing job !! 🎉❤🙏 !!
@JustBlankNoInfo
3 жыл бұрын
A very informative and fantastic video! Thank you for the handsome smile in the thumbnail! Really bright
@AvanishKesharwani
3 жыл бұрын
Very nice video, it is really helpful 👍
@un852
Жыл бұрын
a lot dev needed, but great for retrieving purchase order receipts to keep track of inventory
@RichardWadeUK
3 жыл бұрын
Amazing tutorial Kevin, thanks!
@prokorshopal4865
3 жыл бұрын
0:01 - Hi Kevin! 👋 13:32 - 560th thumbs up from me! 👍 Cheers!
@gsd2404
3 жыл бұрын
That poor soul was smart 😀, nice work kevin love your videos 👍🏼
@KevinStratvert
3 жыл бұрын
Thanks 👍
@neilgoodman2885
Жыл бұрын
I have to work with this, bat it does look promising. Stay In Touch , Respectfully, NHG
@Andrea_Bassi
3 жыл бұрын
Great contents, thanks!
@KevinStratvert
3 жыл бұрын
Glad you enjoyed it!
@claudiamartinmaldonado9268
3 жыл бұрын
This video is EXCELLENT! How do I create the email template so that my customers fill in the fields? Thank you!
@show_me_your_kitties
Жыл бұрын
I filled everything in, took a cropped screenshot and sent to customers.
@alertbox
3 жыл бұрын
Another brilliant video from Kevin
@gladysannescobido437
3 жыл бұрын
Kevin, please do a tutorial about microsoft sway!!! Thanks!!!
@KevinStratvert
3 жыл бұрын
Here's an intro video I filmed on Sway a little while back: kzitem.info/news/bejne/sKiPv4WsiZudhqA
@gladysannescobido437
3 жыл бұрын
Thanks a lot. It is a big help!!!
@Samechaitv
3 жыл бұрын
Useful video, you got a new subscriber, keep up the good work, Thanks
@gajabathiarjuntg2390
3 жыл бұрын
Great video Kevin. This method is very easy and helpful to import emails to excel. Thanks Kevin for pulling out this video :)
@saajalsharma659
2 жыл бұрын
Hey Kevin, this really helped in creating an email tracker for one of my processes, Thanks a lot :)
@airizzo4283
2 жыл бұрын
Good afternoon, I am wondering if I can possibly figure out what programming language this is called first(skip(split(first(split(body('Html_to_text'),'Delivery Method')),'Quantity: '),1))? I am trying to replicate your work, but on a much bigger scale in terms of items going into my table. It's about 500 items, and I'm trying to figure out how to write that in expression code. But when I try to find an example online to learn more...I can't seem to find it. Only Regex is remotely close. Is their a repository where I can learn more of this?
@kristis61
3 жыл бұрын
finally the video i waited for! but i would like to automate the fulfilled column! is there an automation where when the email is dragged from inbox to another folder named «done” to record the day i dragged the email to that folder? is this possible Kevin?
@aditimankar1588
2 жыл бұрын
Hi Kevin, its a nice tutorial but do you have a tutorial to write the expression for the extracting content from Email body as I got stuck at that step. Thanks
@ninobucao5982
2 жыл бұрын
Very good demo !!!!! 👌👌
@lemonlawattorneys
2 жыл бұрын
Great Stuff Kevin. Is there a way to have the automation run on all the messages that are already in the inbox, or will this automation simply work on all messages that arrive going forward?
@ar522
Жыл бұрын
This is what I am looking for too!
@zakeerrg3010
3 жыл бұрын
Kevin. Thanks bro. Love to see more of such useful videos.
@PaulRansonArt
3 жыл бұрын
Thank you for a great video. Sadly no matter how carefully I complete the setup my emails still won't populate my excel spreadsheet🙄. I'm sure it works for others but not for me.
@JWiley-kd3iw
3 жыл бұрын
I learn so much from you Kevin. Keep it coming ☆☆
@sc100200090
3 жыл бұрын
Matchless Content Buddy!
@huyfe1347
2 жыл бұрын
Hi, thanks for your video. How do you extract text from long email to Excel? How do you extract information from pdf to excel with PA?
@milvialuisadventures7716
2 жыл бұрын
Thank you!! You make it see so sample
@Shahbazali
3 жыл бұрын
Nice video
@66jagath
Жыл бұрын
Hi Kevin - I'm really loving your smiley presentation style. Your all the videos are excellent and helpful. Please let me know how to change Received Time into UTC +5.5 format and add the Reply Time to the table.
@mukamil33
3 жыл бұрын
Thank you so much Kevin, omg you have no idea how this video helped me,
@Louviewtube
2 жыл бұрын
Really helpful - thank you!
@naturesounds-9876
Жыл бұрын
@Kevin In my version I don't have expressions as on 09:02 , how I can specify my data? Thanks in advance for the valuable information 👍🏻 😍😍
@punyapeaswar4644
Жыл бұрын
Well explained👍 Was looking for this video.. Found it very helpful 😊 Thank you 🙏 And yes Delivery method - Pigeon😂 👌
@Aleph2Omega
2 жыл бұрын
Totally confused by the expressions used in the video. For instance, the first one specifies "Quantity" not "Cookie Type." The next line shows "Delivery Method" and then "Quantity". The last line shows "Quantity" again. This is confusing. I have tried to run just one expression, and the only think that I can see is that lines were added to my excel sheet. No text information at all. Can someone please help me understand what I am missing here. I am trying to extract 21 fields from the body of emails that are sent to me concerning families requesting toys 4 tots. I can't even get it just to populate the name field to begin with.
@Fruxsky
7 ай бұрын
Did you find any solution? I'm also confused in the same way.
@Aleph2Omega
7 ай бұрын
@@Fruxsky nothing as of yet. Still hopeful though.
@DocHelliday
7 ай бұрын
@@Aleph2Omegamine all failed too
@deepsajwan
Жыл бұрын
Thanks Kevin for the video :)
@weshumphrey6299
3 жыл бұрын
Wow. Well done.
@JavedAnsari-vba
4 ай бұрын
Hi Kevin, is it possible to get the attachment files ( excel, word or pdf) into this master sheet where all emails are updating automatically. Thanks for very informative video
@keithturner2889
3 жыл бұрын
Very useful video. But how do you ensure that the customer sends the email in the required format?
@huntermccall6002
Жыл бұрын
Same question. I get transposed format ("we need x quantity of y cookie type") and multiple "cookie" orders in one body of text. Did you find a solution?
@amolbdesai
3 жыл бұрын
This is a great video Kevin. Can you share how I could import a table from an email that I receive in my Office 365 Outlook inbox to a excel table?
@TheMartinBlanc
2 жыл бұрын
Have you heard back or do you have any information on getting data from tables in emails into excel? I get about 5-6 emails per day with the same tables which I want to extract data from and input into the same table on excel.
@markschipke
Жыл бұрын
Awesome, Kevin, 2 critical questions, please?
@Aaronperiod
3 жыл бұрын
I wish there was a "double-subscribe button" so I could help you to hit the million subscribers faster because man, you deserve it!
@KevinStratvert
3 жыл бұрын
Create a second account? j/k 😂
@dcarr19821
2 жыл бұрын
This was a great help. Only issue I have had is that it brings a carriage return into the spreadsheet, not sure what's caused that to happen.
@olafahmy1604
Жыл бұрын
A perfect tutorial, thank you so much, but, I have a problem mail body appears as an HTML not a text, also, I want to know how to add an attachment?
@ASTHAGUPTA-w3v
Жыл бұрын
Hi Kevin, Thanks for the tutorial, can you do something like this for MS Teams as well
@GargeeSharma
3 жыл бұрын
Delivery Method: “Pigeon” 😂😂
@KevinStratvert
3 жыл бұрын
😅
@utkarshmadaksira743
3 жыл бұрын
Sir, please upload more videos on Power Automate and Power BI. Thank you
@karinthiry1753
8 ай бұрын
Hi Kevin, thank you very much for this video. Can you tell me what trigger you use if you want to import Outlook email to Excel which are already in your inbox. I suppose not "when a new mail arrives" because they are already in your inbox. And do we have to use an instant flow instead ? Karin Thiry
@elsym613
5 ай бұрын
Hi @Kevin, the video where you show how to automate (format) your excel data. There is an end to the range example A2:A9. How can I change this to be the end of the records? My data varies everyday for instance 50 rows one day (A2:A51) others it might be 100 (A2:A101). Thank you very much for the great tutorials! Cheers, E.
@lamjs
3 жыл бұрын
Thanks for the amazing tutorial Kevin! Would you show us how to add subtitle (with customized frame/border) in future video? Thanks : )
@zulimagonzalez830
2 ай бұрын
Hi Kevin, what would be the expression if text in the body is displayed as table where first column has the field names and second column vary dependent on the order. It is similar info but there is no " :" but a table. Thanks!
@_darsh
3 жыл бұрын
Good one Kevin sir ✨
@mayankjain9819
4 ай бұрын
Hey @kevinStartvert, Do you have any video on updating the YTD Cookie Sales Excel Report on OneDrive from the daily or weekly reports we get for the cookie sales thru email on Outlook using Power Automate?
@Mchavez3421
Жыл бұрын
How would you use the expresion "first(skip(split(first(split(body('Html_to_text'),'Delivery Method')),'Quantity: '),1))" if you had a blank line/line break after the value you want to use as "Quantity"?
@mtw688
Жыл бұрын
It's a pity that Kevin doesn't respond to this question. I have the same problem. For example: I need the quantity for the Temperature errors, but there are more Temperature words in the body text. is there a possibility that you can stop the output at the end of the first word Temperature: 20?
@dennisakins3757
6 ай бұрын
Need more information on how to create the expressions that extract only the pieces of the email body I need. Where can I find those instructions?
@atiyahhisham4265
3 жыл бұрын
Hi Kevin. Thank you for the step to step. It help a lot! Can you show me how to extract email which contain table that has multiple columns and rows to Online Excel, please. Thank you.
@raushankumarpandey897
Жыл бұрын
Hi Kevin, This was really helpful. I have one request where I am getting notepad attachments that need to copy and paste in excel and then need to do delimit. As of now I am doing manually. Could you plz help me with power automate 🙏🙏
@DouglasSiringan
Жыл бұрын
Amazing tutorial... is it possible to automatically update an excel file in SharePoint by importing data from another excel file in Outlook as attachment everytime we receive it?
@mattmillward3810
Жыл бұрын
Hi Kevin, great channel and excellent video, I wonder if you can assist - I want to take this automation one step further and add a hyperlink into the table linking to the original email in outlook. Is this possible using the functions?
@jennakulaga2067
3 жыл бұрын
Hi Kevin, this awesome! Would you be willing to make a video on how to compose the expressions? Or do you know of a place where I can learn how to write expressions?
@KevinStratvert
3 жыл бұрын
Hey Jenna! Check out the following resource for all the various functions that you can use while writing expressions: docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference Using this, you can reverse engineer the expressions I wrote and that'll help you understand how they work. As a quick tip, start from the inside of the parentheses and work your way out.
@-ranglapanjab6760
Жыл бұрын
Thanks a lot 👍
@stephaniequiles2518
Ай бұрын
Is there an option for the calendar to be exported rather than emails?? I’m looking to do this exact thing but with the outlook calendar.
@jennifercox5017
3 жыл бұрын
Kevin - will this only work with columns? I'm trying it with rows and it only shows the 1 column after I click on Add a Row Into a Table. Also, does this work with Egnyte instead of One Drive? And, I'm working with an Excel Worksheet that has 4 different tabs. Is there a way to specify which tab the information needs to be entered into? I would assume the email subject would need to be different for each separate tab.?? Thank you
Пікірлер: 420