How to Import Outlook Emails into Excel with Power Automate & Why Do It!

In this tutorial, we'll show you how to import Outlook emails into Excel with Power Automate, and why it's a game-changer for your workflow.
Enjoy the Video
⏰Timestamps⏰
00:00 Intro
00:38 Why Automate the Process
01:21 Demo
02:31 Create Excel Sheet
04:21 Create Power Automate Flow
13:10 Outro
***Career Resources***
📺 Recommended For You 📺
🔥 How To Embed HTML in Outlook Email | Microsoft 365 & Outlook Live
• 🔥 How To Embed HTML in...
30 Awesome Microsoft Outlook Tips and Tricks
• 30 Awesome Microsoft O...
💻 To get more of our best content on IT careers and IT certifications, go to:
Be sure to leave any questions or comments below!
See More Videos and Subscribe
/ skillsbuildtraining
Website:
Instagram: / skillsbuildtraining
Facebook: / skillsbuildtraining
Twitter: / skillsbuildt

[@Kakarot_Karthi]

How to transfer the table format data from email to excel using power automate?

[@erinh4276]

Really wish there was something that would assist me with the expressions....that's the key to this automation.

[@SkillsBuildTraining]

Noted!

[@JohnRobertEnriquez]

Is there a way that if I change the status of that delivered tab to yes. The email from my inbox will automatically move to a specific folder that I created for example I created a folder “Done”. If I change the status in the folder excel file. That email will automatically moved to “done” folder.

[@amation1]

I tried this expression /--first(skip(split(first(split(body('Html_to_text'),'Event Description')),': '),1)) ---/ in outlook V3 to automate, I'm getting the following error, Flow save failed with code 'WorkflowOperationParametersExtraParameter' and message 'The API operation does not contain a definition for parameter 'item/Event Type.Description'.'., looks like this expression only works for V2, is there any other way to resolve this?

[@karinthiry1753]

Hi thank you for the video. Could you tell me what if we want to import Outlook emails into Excel which are already in my inbox. Which trigger do I have to use ? Not "when a new mail arrives" because the emails are already there. Thank you for your response. Karin Thiry

[@nihitmhatre2241]

Could you please help me with video for moving emails from shared mailbox to desired subfolders of shared mailbox

[@PreneshKp]

cant you use the rules in outlook to do that ?

[@jcalzadaz]

I am doing it just as stated on the video but keep recievieng the info as html.

[@mohammedmudassirmudassir7909]

Thanks. Could you please help me with this. I receive email with data in a table but no excel file. How can i automate it to go to one drive excel file using automated cloud flow

[@Kakarot_Karthi]

Found any solution?

[@vinithbattula1341]

What action needs to be used to import the tabular part from email body to excel using powerautomate.?

[@Kakarot_Karthi]

Found any solution?

[@gameanand]

Share the expression

[@SkillsBuildTraining]

Will check on this.

[@RuvinTharakaPalihakkara]

Please share the expressions

[@jamesmoisesllalleperez3079]

error : Correct this to include a valid reference to "Html_to_text" for the input parameters of the "Add_a_row_to_a_table" action.
help me please

[@himanshupujari5558]

Please paste the expression

[@SkillsBuildTraining]

Will check on this.

[@phoenixkissme]

Please share the expression.

[@SkillsBuildTraining]

Will check on this.

[@khanghyhuynh3813]

Can somebody please share the expressions?

[@SkillsBuildTraining]

Will check on this.

[@nirmaljoshi5437]

how to do if we have different tabs in excel

[@rohitbabu-jk5lh]

Sir could you help me to sort the problem which I’m facing while importing the mail content into excel; Please help me to complete the task which made me sleepless for past 2 days; I’m seeking the help to get rid off to get good sleep pls help me

[@fredypena9542]

Thanks, please paste the expression

[@SkillsBuildTraining]

Will do.

[@sameerpanchal361]

Please share the expression

[@SkillsBuildTraining]

Will check on this.

[@karelibeltran327]

Please! :)

[@user-ln6jm1uy5z]

Where is the expression??

[@SkillsBuildTraining]

Will check on this.

[@logisticsguy7019]

first(skip(split(first(split(body('Html_to_text'),'Video Type')),': '),1))
or
first(skip(split(body('Html_to_text'),'Video Type'),1))

[@amation1]

I tried this expression /--first(skip(split(first(split(body('Html_to_text'),'Event Description')),': '),1)) ---/ in outlook V3 to automate, I'm getting the following error, Flow save failed with code 'WorkflowOperationParametersExtraParameter' and message 'The API operation does not contain a definition for parameter 'item/Event Type.Description'.'., looks like this expression only works for V2, is there any other way to resolve this?

[@Jandalf353]

@@amation1 Same here, but still have no answer

[@mollyh3327]

Where is the Expression as promised :(

[@SkillsBuildTraining]

Working on it.

[@ebuxie_]

Where is the expression?

[@SkillsBuildTraining]

Working on it.

[@dianarojas251]

Where is the expression, if he doesn’t share no reason to follow those videos

[@abdelaliabbouchi]

IS THAT TOOL FREE??

[@teomcam]

Basically without expression, the entire videos purpose has been nullified.

[@SkillsBuildTraining]

Will check on this.

[@user-wb7wj1wp9z]

where is the expression ?

[@SkillsBuildTraining]

Will check on this.

[@MikeSunTzu]

Expression???????

[@SkillsBuildTraining]

Will check on this.