Import Outlook to Excel with Power Automate Tutorial

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to import email from either Gmail or Outlook into Microsoft Excel using Power Automate. First, we visit Office.com and sign in with a free account. Next, we set up a new workbook in Microsoft Excel and enter the columns that we want to populate with content from an email. We proceed to Power Automate, where we set up a flow to take the contents of an email and insert them into our workbook table. Finally, we test the flow to ensure that the email successfully imports into the Excel worksheet. By the end, you'll be able to take the contents from an email and fill it into your Excel workbook. The resulting flow will work automatically in the cloud and there's no need to launch Outlook, Gmail, or Excel for this to work.
👋 Additional resources
- How to use Microsoft Power Automate: • Power Automate Tutoria...
- Reference guide to using functions in expressions for Power Automate - this will help you understand the expressions below and how they parse text in an email: docs.microsoft.com/en-us/azur...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
- The expression in the "Cookie Type" field:
first(skip(split(first(split(body('Html_to_text'),'Quantity')),': '),1))
- The expression in the "Quantity" field:
first(skip(split(first(split(body('Html_to_text'),'Delivery Method')),'Quantity: '),1))
- The expression in the "Delivery Method" field:
first(skip(split(body('Html_to_text'),'Delivery Method: '),1))
⌚ Timestamps
0:00 Introduction
0:56 Sign into office.com
1:28 Create new Excel workbook
3:07 Navigate to Power Automate
4:02 Build automated cloud flow
5:15 Example email to import into Excel
5:39 Step 1: Check when a new email arrives & filters
6:35 Step 2: Convert HTML into text
7:20 Step 3: Add new row into Excel table with email contents
9:55 Extract content from body of email using expression
11:28 Test flow
13:05 Wrap up
📃 Watch related playlists
- Playlist with all my videos on Power Automate: • Power Automate
- Playlist with all my videos on Outlook: • 📨 How to use Outlook
- Playlist with all my videos on Excel: • ❎ How to use Excel
🚩 Connect with me on social
- LinkedIn: / kevinstratvert
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
🔔 Subscribe to my KZbin channel
kzbin.info?...
🎬 Want to watch again? Navigate back to my KZbin channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert

[@KevinStratvert]

🏫 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: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@SWD2529]

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]

Amazing video❤. But, can you explain more about expressions you wrote

[@loloysan6417]

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

[@francismastro]

You have no idea how much time you're saving me! Thanks and keep up the amazing tutorials.

[@peterxxl1244]

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! :-)

[@_alphin_joe]

It’s very helpful for people who needs to import Mails for their work. They need it. Helpful Video 🎬.

[@erib156]

I'm gonna cry, you changed my life! The first video simple and well explained 😍

[@vijayarjunwadkar]

Super helpful tutorial Kevin! This is going to open many possibilities for me and my team! Thanks a lot! 😊👍

[@SavageGothamChess]

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!

[@user-js5th1qv5i]

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.

[@gajabathiarjuntg2390]

Great video Kevin. This method is very easy and helpful to import emails to excel. Thanks Kevin for pulling out this video :)

[@RichardWadeUK]

Amazing tutorial Kevin, thanks!

[@miransh]

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....

[@KatRG6453]

You're videos are amazing and I appreciate them so much!

[@elishatech4600]

since I discovered your channel I have learnt a lot from you. Thanks man keep up

[@HenryGonzalezTv]

You are by far the best all over the internet. Thank you 🙏

[@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!

[@JWiley-kd3iw]

I learn so much from you Kevin. Keep it coming ☆☆

[@DannyWiraDharma]

Thank you so much, Kevin! I shared this video to my friends and clients.

[@KevinStratvert]

You rock!

[@brendamartinezgomez2297]

All your videos are very insightful and meaningful.

[@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]

yeah, the expressions are keeping me hanging. I want to understand it in detail and how it is structured.

[@fallonopperman8293]

Thanks Kevin! I was having issues getting Step 2 until I turned off split in the settings of Step 1.

[@zakeerrg3010]

Kevin. Thanks bro. Love to see more of such useful videos.

[@anurangaehelepola1245]

A really great explanation! Thanks for this!

[@alertbox]

Another brilliant video from Kevin

[@ulligruber1344]

Delivery method: pigeon 🤣 Love Kevins humor 😁

[@nairobi203]

Flying cookies....

[@qrsimon]

@@nairobi203 maybe the pigeon ate them

[@saajalsharma659]

Hey Kevin, this really helped in creating an email tracker for one of my processes, Thanks a lot :)

[@viveksingh-nt3po]

Very useful! Do make more videos on Windows power automate due to heightened focus on automation these days!! Thanks buddy!

[@KevinStratvert]

More to come!

[@viveksingh-nt3po]

@@KevinStratvert really appreciate your efforts in sharing the knowledge with us!!

[@eleos11]

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?

[@mukamil33]

Thank you so much Kevin, omg you have no idea how this video helped me,

[@travelwell6049]

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! 😂

[@bryankendig3989]

Great video. Very helpful. Could you please show expressions if row headings , “cookie “, “quantity “, “delivery method” were switched to column headings??

[@Louviewtube]

Really helpful - thank you!

[@bavandetemadi589]

Brilliant. So clear, so concise. Nice one.

[@adepejuadegoke9960]

Great tutorial. Thank you for all you do.

[@KevinStratvert]

My pleasure!

[@milvialuisadventures7716]

Thank you!! You make it see so sample

[@sc100200090]

Matchless Content Buddy!

[@VirtualkitchenwithLaura]

I really like this method. Thank you for your knowledge.

[@KevinStratvert]

Glad it was helpful!

[@AvanishKesharwani]

Very nice video, it is really helpful 👍

[@vidajavan6922]

Very helpful. Thank you for this great tip!

[@DarkDudesAI]

A very informative and fantastic video! Thank you for the handsome smile in the thumbnail! Really bright

[@weshumphrey6299]

Wow. Well done.

[@neilgoodman2885]

I have to work with this, bat it does look promising. Stay In Touch , Respectfully, NHG

[@Samechaitv]

Useful video, you got a new subscriber, keep up the good work, Thanks

[@khaledk9069]

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

[@svjkswamivivekanandajnanak7052]

Awesome presentation

[@ninobucao5982]

Very good demo !!!!! 👌👌

[@fazrinfarook7557]

If Kevin Post a video I will watch it, whether Do I need this tutorial or not => From Sri Lanka

[@rlerolle]

Hi kevin, You re doing an Amazing job !! 🎉❤🙏 !!

[@prokorshopal4865]

<a href="#" class="seekto" data-time="1">0:01</a> - Hi Kevin! 👋 <a href="#" class="seekto" data-time="812">13:32</a> - 560th thumbs up from me! 👍 Cheers!

[@phillharris3656]

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?

[@deepsajwan]

Thanks Kevin for the video :)

[@lamjs]

Thanks for the amazing tutorial Kevin! Would you show us how to add subtitle (with customized frame/border) in future video? Thanks : )

[@Andrea_Bassi]

Great contents, thanks!

[@KevinStratvert]

Glad you enjoyed it!

[@bellam2413]

Thank you !

[@adriandsilva9250]

Hi Kevin, this has been extremely beneficial. Thanks so much! On one of my recent forms, I've run into an issue with having an apostrophe . Any suggestions on how to overcome that when creating my expression? Ie, what if the email had Delivery Method's. Thanks for your time.

[@hshs4]

Thank you bro 🙏

[@_darsh]

Good one Kevin sir ✨

[@punyapeaswar4644]

Well explained👍 Was looking for this video.. Found it very helpful 😊 Thank you 🙏 And yes Delivery method - Pigeon😂 👌

[@dmclean3324]

Beats using Power Query for sure. Looking at implementing this and then having that data go into Planner

[@Milhouse77BS]

Not sure anything beats Power Query for ease of use

[@dmclean3324]

@@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.

[@nehashahpatel1741]

million thanks

[@-ranglapanjab6760]

Thanks a lot 👍

[@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.

[@p2kc1]

Hi kevin, thank you for the great explanation Is there any limitations in the free onedrive account?

[@un852]

a lot dev needed, but great for retrieving purchase order receipts to keep track of inventory

[@gsd2404]

That poor soul was smart 😀, nice work kevin love your videos 👍🏼

[@KevinStratvert]

Thanks 👍

[@RealRaze1]

Nice video🎥

[@utkarshmadaksira743]

Sir, please upload more videos on Power Automate and Power BI. Thank you

[@touchdowntodd]

You rock!

[@abdulrahmanbaamer8624]

Great & helpful video, can we create similar lists for all email received previously and archive (.pst files) Thanks.

[@atiyahhisham4265]

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.

[@Shahbazali]

Nice video

[@user-dx6rw5fp8g]

Hi Kevin, Thanks for the tutorial, can you do something like this for MS Teams as well

[@huyfe1347]

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?

[@chynnaleaesguerra3284]

That poor soul happens to be me hahaha. Thank you for this video Kevin😂

[@gumikebbap]

sup Kevin great content! I think at <a href="#" class="seekto" data-time="624">10:24</a> the expression should say 'Cookie Type' instead of 'Quantity', when looking for the Cookie Type.

[@bernipremium9193]

I thought the same!

[@aditimankar1588]

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

[@PapaKayOh]

Nice work. Can you do a tutorial on building a support ticketing and tracking system using MS access along with power automate?

[@mariancoman354]

Super content; keep up the great work! Quick question: is there a way to make Excel deselect the "Wrap text" automatically? I am keeping an email archive, and I always have to Ctrl+A and press twice Wrap text to keep everything ready to read. Thanks a lot!

[@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?

[@markschipke]

Awesome, Kevin, 2 critical questions, please?

[@jennakulaga2067]

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]

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.

[@anjalipatel9879]

Very helpful tutorial thanks Kevin.Can you please make a video on Sharepoint web pages formatting add-ons to create a knowledge base ? Thanks 😊

[@KevinStratvert]

Thanks for the suggestion! I've added this to my list. Stay tuned. Cheers!

[@kristis61]

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?

[@keeplearn5735]

Hi Kevin, do you have video explain about create the expressions? Thank You

[@hsobd]

Thanks Kevin, very usefull. I want to filter the extraction from email i.e I want to only add/extract rows having cookie type A, how can we add filter extraction on email text in the power automate. I tried filter expression but I am finding difficulty in making it work.

[@naturesounds-9876]

@Kevin In my version I don't have expressions as on <a href="#" class="seekto" data-time="542">09:02</a> , how I can specify my data? Thanks in advance for the valuable information 👍🏻 😍😍

[@dcarr19821]

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.

[@chhayakankariya2748]

Plz make big video on excel from basic to advanced ! Thank yu

[@KevinStratvert]

This is a little older... here's an intro I filmed on Excel: kzbin.info/www/bejne/m2jbeKh9psyjY7M Here's also a playlist with all my Excel content: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@chhayakankariya2748]

@@KevinStratvert ok tysm

[@netbuddy1089]

Thanka lot, can you do something in Power Automate Desktop. or might have already done this and i might have missed this.

[@krisihari]

Hi Kevin, this was indeed very useful! Thanks a LOT! I am trying to automate a process and wonder if you may have some ideas on this. I have an Excel file with project data piled and compiled from different systems. However not all projects are in the systems. So for some of them I need to collect the missing data. Now I can ask the project managers to go into the file and complete it but it would be much cooler if I can automatically send the missing fields to them via Email or form and ask them to send back the missing data and incorporate it in the sheet . Do you think there may be a way to do this with power automate? Thanks and keep the great work!

[@pvrameshbabu]

I think it can be done. If you email id of the project manager stored. Based on the missing fields you trigger email template from excel to outlook.

[@laddu2000in]

Hi, I find this video is very useful. It's of great help. I just needed a clarification for email received date and time is recording in my time zone format. Can you plese advise solution on this point.

[@JavedAnsari-vba]

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

[@ipconfigearth102]

Thanks for great video - can you link a video or how and what those functions mean?

[@punithrjain]

Hi Kevin it's a really helpful video and kindly keep sharing such great content. I have a query on the mail to excel if I have more than 1 line item of material will this process help or do we need to tweak the process to accommodate more line items of ordered material from mail to excel. Kindly reply on the same

[@ronniesakai9811]

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]

I was thinking the same question. Did you @Ronnie Sakai find a solution for that need. Kevin do you have some tips?

[@PaulRansonArt]

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.

[@sharvdhume]

Please make videos on excel formulas 🔥🔥🔥🔥🔥🔥👍👍👍🙏

[@BassemixTECH]

i tried to understand how the expression are made and try to modify it as per my table. but i couldn't do that. so if you have any video about how to make the expression kindly share it with me. other than this, you are making a great job, keep it up man.

[@Greathall75]

Kevin, suggestion for a future video (if you know a solution)... When copying a table from Excel and pasting into Outlook the resulting table columns are too narrow in Outlook. Any idea why, or how to avoid this issue (without manually resizing them)? I would expect a perfect copy/paste since both programs are Microsoft, but I always end up having to resize the columns.

[@lemonlawattorneys]

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!