Power Automate - How to extract body of email which contains multiple rows?

preview_player
Показать описание
This video explains how to extract body of email which contains multiple rows.

Expressions I used in this video is as follows:

split(outputs('HTML_to_text_2')?['body'],outputs('Compose_2'))

last(split(outputs('Compose_4'),'Name:'))
Рекомендации по теме
Комментарии
Автор

This video is really usefull to me...Thanks for video...

need one more help from you ....

I have mail with the table in body that body table need to extrext and share some line item to the other user via mail by using power automate.

Bornforbapa
Автор

Hi, I would like to ask, how can the unique code in the email subject (e.g., 00015) be used as a trigger to find a folder with the same name in SharePoint?

1. Email arrives (with the unique code in the subject).
2. Save the email and attachment as a .eml file.
3. Save the .eml file in a folder that already exists in SharePoint, with the folder name matching the unique code in the email subject.

I greatly appreciate the information you are going to provide

faishala
Автор

i have created a flow where when ever we receive an email(v3) the automation will copy the body and paste it in an excel sheet . but when i receive 2 emails at exact same time the flow is unable to trigger both the emails but only one some times none can you help me with this

SreeramSashankChundi
Автор

how would this work for an email that sends informations in a table? I want to extract the names of the headers, and the information listed below each.

enifsmr
Автор

Hello, if I have a line from the message body that contains the text string "xacd" how can I get the entire line?

cristobalramirezvalderrama
Автор

How to extract address field from a pdf which has different number of lines(2-5) for each person?

gedelasaisravya
Автор

I am using PowerAutomate to export emails to a database and then display the data in a PowerApp gallery depending on customer needs; however, many times the customer emails have pasted images and screen shots in the email. I cannot get these images to appear in a PowerApp gallery - the email text displays but the image is blank. Any ideas? I have tried using the Html text box in PowerApps as well as the Image control without any success.

tonya
Автор

Congratulations, great video! What about if I have the values in separate rows? E.g. Row1 = Name; Row2= Will Smith. is there any way to pull the information from the 'Apply to each' as I will always be receiving the same form

rubenpuertosmartinez
Автор

Hello, I wanted to extract email addresses from the body and put it in array. Please help me out with the steps..

deebantech
Автор

Hi I want to store the first 500 words from the body of the mail in share point list how can I ?

hvmfqkj
Автор

Can we extract the value by using AI builder and use the last(split expression to get only value and create sharepoint list items with the value?

thewanderingcouple
Автор

Hi... I get mail which has all the data can i add a filter to it and project what i needed in teams if yes can you please help me with the process ... Thanks

vastavchandrakesh
Автор

Hi what if the body is like to

name:
nameof the person

how should I adjust the expression?

marcussoh
Автор

The enter key part doesn't seem to work for me

benjaminfoley
Автор

Hi
I need to extract tables from email, can u pls hlp....

sadhals
Автор

Would of be possible to modify this flow to ensure that the entire email message is extracted except the greeting line end ending line of the email?

adagonzalez
Автор

This video is really helpful, and I love how you show the outputs at each stage so it makes more sense what you are doing. I am however confused as to how you extract more data after the true/false conditon. So, I got Irene. How then do I extract 54 within that condition, and then Female?

darkspeed
Автор

Hello! I have a question about e-mails that I cannot solve, but for me it seems pretty simple: Can I respond an email that my power automate flow made for me? Like: My flow sends an e-mail, and after a specific "If" function, It'll answer the e-mail for me with another message, like starting a conversation.

arthurpurcino
Автор

Can u show how to export multiple body email to excell with power automate?

bayutrianayasa
Автор

Hello, Thank you for these! I am trying to do this, but when it comes to the expression split, it says that it does not exist.. is there another expression that does the same thing

stephanieyang