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

Пікірлер: 43

  • @erinh4276
    @erinh42769 күн бұрын

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

  • @SkillsBuildTraining

    @SkillsBuildTraining

    6 күн бұрын

    Noted!

  • @mohammedmudassirmudassir7909
    @mohammedmudassirmudassir79094 ай бұрын

    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
    @vinithbattula13412 ай бұрын

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

  • @amation1
    @amation14 ай бұрын

    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
    @karinthiry17536 ай бұрын

    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
    @nihitmhatre22418 ай бұрын

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

  • @PreneshKp

    @PreneshKp

    7 ай бұрын

    cant you use the rules in outlook to do that ?

  • @jcalzadaz
    @jcalzadaz9 ай бұрын

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

  • @RuvinTharakaPalihakkara
    @RuvinTharakaPalihakkara9 ай бұрын

    Please share the expressions

  • @jamesmoisesllalleperez3079
    @jamesmoisesllalleperez307911 ай бұрын

    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
    @logisticsguy70198 ай бұрын

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

  • @amation1

    @amation1

    4 ай бұрын

    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
    @nirmaljoshi5437Ай бұрын

    how to do if we have different tabs in excel

  • @khanghyhuynh3813
    @khanghyhuynh381310 ай бұрын

    Can somebody please share the expressions?

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Will check on this.

  • @phoenixkissme
    @phoenixkissme11 ай бұрын

    Please share the expression.

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Will check on this.

  • @rohitbabu-jk5lh
    @rohitbabu-jk5lh3 ай бұрын

    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
    @gameanand11 ай бұрын

    Share the expression

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Will check on this.

  • @himanshupujari5558
    @himanshupujari555811 ай бұрын

    Please paste the expression

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Will check on this.

  • @fredypena9542
    @fredypena95429 ай бұрын

    Thanks, please paste the expression

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Will do.

  • @sameerpanchal361
    @sameerpanchal361 Жыл бұрын

    Please share the expression

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Will check on this.

  • @karelibeltran327

    @karelibeltran327

    Ай бұрын

    Please! :)

  • @user-ln6jm1uy5z
    @user-ln6jm1uy5z11 ай бұрын

    Where is the expression??

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Will check on this.

  • @dianarojas251
    @dianarojas2519 ай бұрын

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

  • @mollyh3327
    @mollyh33275 ай бұрын

    Where is the Expression as promised :(

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Working on it.

  • @ebuxie_
    @ebuxie_5 ай бұрын

    Where is the expression?

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Working on it.

  • @teomcam
    @teomcam9 ай бұрын

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

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Will check on this.

  • @user-wb7wj1wp9z
    @user-wb7wj1wp9z10 ай бұрын

    where is the expression ?

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Will check on this.

  • @abdelaliabbouchi
    @abdelaliabbouchiАй бұрын

    IS THAT TOOL FREE??

  • @MikeSunTzu
    @MikeSunTzu10 ай бұрын

    Expression???????

  • @SkillsBuildTraining

    @SkillsBuildTraining

    4 ай бұрын

    Will check on this.