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

Поделиться
HTML-код
  • Опубликовано: 12 янв 2025

Комментарии • 61

  • @erinh4276
    @erinh4276 6 месяцев назад +2

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

  • @karinthiry1753
    @karinthiry1753 Год назад +3

    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

  • @vinithbattula1341
    @vinithbattula1341 9 месяцев назад +1

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

    • @Karthi_Max
      @Karthi_Max 6 месяцев назад

      Found any solution?

  • @RuvinTharakaPalihakkara
    @RuvinTharakaPalihakkara Год назад +4

    Please share the expressions

  • @sameerpanchal361
    @sameerpanchal361 Год назад +8

    Please share the expression

  • @gameanand
    @gameanand Год назад +6

    Share the expression

  • @himanshupujari5558
    @himanshupujari5558 Год назад +6

    Please paste the expression

  • @RajivRajvat
    @RajivRajvat 3 месяца назад

    Can you help me convert this video content into a table format? I mean, when I receive an email in a table view , I want to store the same format Columns in a SharePoint list or Excel, with columns and different rows. I’ve tried several times but haven’t been able to do it.

  • @SHUBHAM-on3rn
    @SHUBHAM-on3rn 4 месяца назад

    Sir if want to extract the info for some rows i.e from row 1 to row 8 from a received excel sheet in my email which do not have columns defined in it how to do it.........can you please guide ?

  • @mohammedmudassirmudassir7909
    @mohammedmudassirmudassir7909 11 месяцев назад

    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

    • @Karthi_Max
      @Karthi_Max 6 месяцев назад

      Found any solution?

  • @aldrinmendoza4130
    @aldrinmendoza4130 4 месяца назад

    what if the email that are being sent are in table format?

  • @nihitmhatre2241
    @nihitmhatre2241 Год назад

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

    • @PreneshKp
      @PreneshKp Год назад

      cant you use the rules in outlook to do that ?

  • @techforyoubyjr
    @techforyoubyjr 4 месяца назад +4

    DON'T waste time watching this video!!! It's missing the most important part: the expression to extract text from body!!

  • @khanghyhuynh3813
    @khanghyhuynh3813 Год назад +2

    Can somebody please share the expressions?

  • @logisticsguy7019
    @logisticsguy7019 Год назад +3

    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 11 месяцев назад +2

      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
      @Jandalf353 6 месяцев назад

      @@amation1 Same here, but still have no answer

  • @Karthi_Max
    @Karthi_Max 6 месяцев назад

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

  • @JohnRobertEnriquez
    @JohnRobertEnriquez 6 месяцев назад

    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
    @amation1 11 месяцев назад

    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?

  •  5 месяцев назад

    can you not process order from a sharepoint list if so how

  • @fredypena9542
    @fredypena9542 Год назад +1

    Thanks, please paste the expression

  • @Nathan-London
    @Nathan-London 3 месяца назад

    Where is the expression? Can you post it please?

  • @jcalzadaz
    @jcalzadaz Год назад

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

  • @nirmaljoshi5437
    @nirmaljoshi5437 7 месяцев назад

    how to do if we have different tabs in excel

  • @JaydenG-l1l
    @JaydenG-l1l Год назад +2

    Where is the expression??

  • @mollyh3327
    @mollyh3327 Год назад +1

    Where is the Expression as promised :(

  • @sermeric
    @sermeric 3 месяца назад +2

    WASTE OF TIME. He doesnt give expression on purpose. Check comments he said "will do" to those who ask for the expression, he gives the same answer, but he never gives it.

  • @teomcam
    @teomcam Год назад +2

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

  • @rohitbabu-jk5lh
    @rohitbabu-jk5lh 9 месяцев назад

    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

  • @ilyaszeb3946
    @ilyaszeb3946 Месяц назад

    Nobody will recommend this video or will trust this person because he has been giving CHURANs to everyone about the expression he promised😂

  • @jamesmoisesllalleperez3079
    @jamesmoisesllalleperez3079 Год назад +1

    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

  • @dianarojas251
    @dianarojas251 Год назад +1

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

  • @Karl-t2n
    @Karl-t2n Год назад +1

    where is the expression ?

  • @abdelaliabbouchi
    @abdelaliabbouchi 8 месяцев назад

    IS THAT TOOL FREE??

  • @vlog-tech7532
    @vlog-tech7532 5 месяцев назад +1

    This video is useless without expresion . Very disappointed!

  • @MikeSunTzu
    @MikeSunTzu Год назад +1

    Expression???????

  • @Nathan-London
    @Nathan-London 3 месяца назад

    Your video is useless without very important part which is the "Expression"

  • @ebuxie_
    @ebuxie_ 11 месяцев назад +1

    Where is the expression?

    • @SkillsBuildTraining
      @SkillsBuildTraining  10 месяцев назад

      Working on it.

    • @Nathan-London
      @Nathan-London 3 месяца назад +1

      @@SkillsBuildTraining Where is the expression? Are you purposely hiding it?