🏫 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: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
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?
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
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.
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!
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! :-)
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.🙏🙏🙏
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!
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
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.
Great video. Very helpful. Could you please show expressions if row headings , “cookie “, “quantity “, “delivery method” were switched to column headings??
@@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.
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.
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?
This is a little older... here's an intro I filmed on Excel: th-cam.com/video/e7xGuGqgp-Q/w-d-xo.html Here's also a playlist with all my Excel content: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
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....
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
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 !
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?
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.
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?
@@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.
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
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?
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?
did those formulas line up with the fields correctly? looked like you had 'quantity' under cookie type and a combo of delivery type/quantity under quantity. thanks....
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
What if we want to extract existing emails from an Inbox or subfolder? I'd like to capture data from existing emails as well as new emails that I place in an Inbox subfolder
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.
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
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.
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?
Very well done Kevin. I'm using PowerAutomate more and more and think it's been a real gamechanger for regular users. Do you know if it is possible to copy emails into a SharePoint list or library via PowerAutomate?
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!
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"?
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?
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?
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.
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.
🏫 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: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
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?
This is very helpful Kevin. Thanks!
Is there a way to also import Senders Name ?
Amazing video❤. But, can you explain more about expressions you wrote
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
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.
It’s very helpful for people who needs to import Mails for their work. They need it. Helpful Video 🎬.
You have no idea how much time you're saving me! Thanks and keep up the amazing tutorials.
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!
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! :-)
Very useful! Do make more videos on Windows power automate due to heightened focus on automation these days!! Thanks buddy!
More to come!
@@KevinStratvert really appreciate your efforts in sharing the knowledge with us!!
You are by far the best all over the internet. Thank you 🙏
Thanks Kevin. This helps me to make a big leap in my knowledge. ...
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.🙏🙏🙏
yeah, the expressions are keeping me hanging. I want to understand it in detail and how it is structured.
Delivery method: pigeon 🤣 Love Kevins humor 😁
Flying cookies....
@@nairobi203 maybe the pigeon ate them
I'm gonna cry, you changed my life! The first video simple and well explained 😍
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?
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!
😂
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!
All your videos are very insightful and meaningful.
I really like this method. Thank you for your knowledge.
Glad it was helpful!
You're videos are amazing and I appreciate them so much!
0:01 - Hi Kevin! 👋
13:32 - 560th thumbs up from me! 👍 Cheers!
A very informative and fantastic video! Thank you for the handsome smile in the thumbnail! Really bright
since I discovered your channel I have learnt a lot from you. Thanks man keep up
Brilliant. So clear, so concise. Nice one.
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
Great video Kevin. This method is very easy and helpful to import emails to excel. Thanks Kevin for pulling out this video :)
Very helpful. Thank you for this great tip!
Thank you so much, Kevin! I shared this video to my friends and clients.
You rock!
sup Kevin great content! I think at 10:24 the expression should say 'Cookie Type' instead of 'Quantity', when looking for the Cookie Type.
I thought the same!
the hardest part of this tutorial, the expressions, gets completely glossed over. The examples given in the text don't make any sense.
Awesome presentation
Hi kevin,
You re doing an Amazing job !! 🎉❤🙏 !!
Super helpful tutorial Kevin! This is going to open many possibilities for me and my team! Thanks a lot! 😊👍
Thanks Kevin! I was having issues getting Step 2 until I turned off split in the settings of Step 1.
I have to work with this, bat it does look promising. Stay In Touch ,
Respectfully, NHG
Well explained👍
Was looking for this video.. Found it very helpful 😊
Thank you 🙏
And yes Delivery method - Pigeon😂 👌
Useful video, you got a new subscriber, keep up the good work, Thanks
Very good demo !!!!! 👌👌
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.
Hey Kevin, this really helped in creating an email tracker for one of my processes, Thanks a lot :)
If Kevin Post a video I will watch it, whether Do I need this tutorial or not => From Sri Lanka
That poor soul was smart 😀, nice work kevin love your videos 👍🏼
Thanks 👍
I learn so much from you Kevin. Keep it coming ☆☆
Great video. Very helpful. Could you please show expressions if row headings , “cookie “, “quantity “, “delivery method” were switched to column headings??
My flow is not getting triggered when i send an email . can someone please help me with this?
This is so helpful!! Thank you so much!!!
Nice video🎥
Amazing tutorial Kevin, thanks!
Great tutorial. Thank you for all you do.
My pleasure!
Kevin. Thanks bro. Love to see more of such useful videos.
Very nice video, it is really helpful 👍
Thanks Kevin for the video :)
Another brilliant video from Kevin
Beats using Power Query for sure. Looking at implementing this and then having that data go into Planner
Not sure anything beats Power Query for ease of use
@@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.
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.
Thank you!! You make it see so sample
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?
Matchless Content Buddy!
Thank you so much Kevin, omg you have no idea how this video helped me,
Plz make big video on excel from basic to advanced ! Thank yu
This is a little older... here's an intro I filmed on Excel: th-cam.com/video/e7xGuGqgp-Q/w-d-xo.html Here's also a playlist with all my Excel content: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
@@KevinStratvert ok tysm
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....
This video is EXCELLENT! How do I create the email template so that my customers fill in the fields? Thank you!
I filled everything in, took a cropped screenshot and sent to customers.
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
Great contents, thanks!
Glad you enjoyed it!
Kevin, please do a tutorial about microsoft sway!!! Thanks!!!
Here's an intro video I filmed on Sway a little while back: th-cam.com/video/OrYYQvPilSk/w-d-xo.html
Thanks a lot. It is a big help!!!
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 !
I was thinking the same question. Did you @Ronnie Sakai find a solution for that need.
Kevin do you have some tips?
@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 👍🏻 😍😍
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?
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.
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?
@@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.
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
Really helpful - thank you!
Awesome, Kevin, 2 critical questions, please?
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?
Thank you bro 🙏
That poor soul happens to be me hahaha. Thank you for this video Kevin😂
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?
This is what I am looking for too!
Thanks a lot 👍
Good one Kevin sir ✨
Thanks for the amazing tutorial Kevin! Would you show us how to add subtitle (with customized frame/border) in future video? Thanks : )
Hi Kevin. Is it possible too to include the email attachment in the excel?
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?
I wish there was a "double-subscribe button" so I could help you to hit the million subscribers faster because man, you deserve it!
Create a second account? j/k 😂
Could you use this for extracting Outlook calendar entries into Excel as well?
did those formulas line up with the fields correctly? looked like you had 'quantity' under cookie type and a combo of delivery type/quantity under quantity. thanks....
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
What if we want to extract existing emails from an Inbox or subfolder? I'd like to capture data from existing emails as well as new emails that I place in an Inbox subfolder
Hi Kevin! Do we have same functionality on MacOS?
Nice video
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.
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
Same issue, can we have help on that. @kevin
Hi Kevin, Thanks for the tutorial, can you do something like this for MS Teams as well
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?
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.
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?
Very well done Kevin. I'm using PowerAutomate more and more and think it's been a real gamechanger for regular users. Do you know if it is possible to copy emails into a SharePoint list or library via PowerAutomate?
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!
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"?
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?
Can this be done on emails already in inbox?
I have the same question...
Thanka lot, can you do something in Power Automate Desktop. or might have already done this and i might have missed this.
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?
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.
Sir, please upload more videos on Power Automate and Power BI. Thank you
Hi Kevin, do you have video explain about create the expressions?
Thank You
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.