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

[@erinh4276]

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

[@SkillsBuildTraining]

Noted!

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

[@vinithbattula1341]

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

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

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

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

[@nirmaljoshi5437]

how to do if we have different tabs in excel

[@khanghyhuynh3813]

Can somebody please share the expressions?

[@SkillsBuildTraining]

Will check on this.

[@phoenixkissme]

Please share the expression.

[@SkillsBuildTraining]

Will check on this.

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

[@gameanand]

Share the expression

[@SkillsBuildTraining]

Will check on this.

[@himanshupujari5558]

Please paste the expression

[@SkillsBuildTraining]

Will check on this.

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

[@dianarojas251]

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

[@mollyh3327]

Where is the Expression as promised :(

[@SkillsBuildTraining]

Working on it.

[@ebuxie_]

Where is the expression?

[@SkillsBuildTraining]

Working on it.

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

[@abdelaliabbouchi]

IS THAT TOOL FREE??

[@MikeSunTzu]

Expression???????

[@SkillsBuildTraining]

Will check on this.