Power Automate - How to extract body of email which contains multiple rows?
Vložit
- čas přidán 29. 07. 2024
- 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:'))
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
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
thanks for sharing,
I have a question on the same, if multiple parameters has to be extracted from the body like say in this video , in the yes condition box if we have extract age and gender how do you write those conditions and if the data is unstructured say if mails are received in different formats(instead of semi colon, a dash is used or details are mentioned in a single line) what method can be used.
kindly respond!
Thanks
Hi Akhil
That will be difficult. You need a pattern of data then only you can apply the rules how to extract the data.
Thanks
How to extract address field from a pdf which has different number of lines(2-5) for each person?
I don't think its supported by native connectors. You may need to look third party connectors within Power Automate. There are few out there already.
Thanks
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
Hi
Click the expression tab and type split(). Believe your cursor focus is under the Dynamic expression. Have a look on my video carefully. Split() do exists.
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.
Hi, this is excellent - I have a question if you are able to help. I would like to take certain values, loop through and add them to a row within excel, the format of each email is the same but when converted to html to text looks like:
First Name
Username1
Age
23
First Name
Username2
Age
24
Not like your example which is:
First Name: Username1
Age:23
First Name: Username2
Age: 24
I have an excel table which should update each column with these values received, and add a new row for each person’s info. You mention a ‘concat’ at the end of this video which may be a starting point for me?
Hi
I need to see the flow to comment on this. Could you please post in Power Automate Community and tag me as @abm. I will have a look.
powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Super cool! I'm trying to extract just a few lines on top of a HTML table from an email received jsut ike this example you showcased, such as Customer, Invoice No.. etc. Then the table, headers Currency, Item and so on and then the content of the table itself. Any thoughts on that? thx!!!
Hi Victor
Thanks for the support. So again here you have enter key or new line as separator.
split('email body', 'EnterKey'). Please see exact syntax in my video.
So that means it will create an array
After the array you can access the first index to get Customer and next index to get Invoice No
Below is the expression to get customer
split('email body', 'EnterKey')[0]
For invoice
split('email body', 'EnterKey').[1]
Hope it makes sense. If you need further help please let me know. Happy to help.
Thanks
@@abm4975 thank you. Your content is unparalleled. The time you take to answer and explainin each video. Hats off to you @abm
Thanks a lot Victor. Really appreciate your kind comments.
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?
Hi
You could try it. Why you need to use the AI builder?
Thanks
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?
Hi
Thanks so much for the support.
I was away for few weeks. Do you still need help in this please?
Thanks
Yes please, can u do a video and i like to extract the data into excel. Thanks for your help!@@abm4975
Hi I need help please. I have the same request@@abm4975
Hello, I wanted to extract email addresses from the body and put it in array. Please help me out with the steps..
Hi
I need to see a sample of text? Is the email under the body is always going to be in same position? If its in different place its quite difficult to extract it. For extracting the data you need the data to be placed under a specified format. Then we can apply those rules to get that particular data. See an example below of a body format:
1. Name: David Smith
2. Email: d.s@test.com
So for the above we can look the second line and extract the email using Power Automate.
Please tell me more about the email body of yours?
Thanks
Hi what if the body is like to
name:
nameof the person
how should I adjust the expression?
Yes that's correct.
Good. Tutorial 😁
Thank you! Cheers!
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?
Hi
Thanks for the question and support. Yes have a look on Power Automate skip() expression.
Thanks
Thanks dear. What about if I want a specific item in the array? let us say number 15?
Hi Ali
If you are looking for a specific item, you could add an IF condition to check the name of the item and get the specific value. Another way is using the Filter array and check item value is 15 or not? It's all depends on your data.
Thanks
This video and the other one on unstructured were really useful! Saved me lots of time & effort.
I have put them in a sharepoint list.
There are a lot of null values before the desired result and after the desired result.
Ex: [null,null,Sujitha, null,null].
Could you please let me know a way to update this without the null values?
Hi
Thanks for the question. Could you add an If condition to check whether its null?
@@abm4975 Thank you, it worked ! :)
Can u show how to export multiple body email to excell with power automate?
Hi
Could you explain with an example please. I could look into it.
Thanks
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.
Hi
Please have a look at this video from Damien.
czcams.com/video/i4GHCGMAD88/video.html
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
Hi
Could you please post in Power Automate community forum. Explain using an example. Tag me as @abm. I will have a look.
powerusers.microsoft.com/t5/Building-Flows
Hi I want to store the first 500 words from the body of the mail in share point list how can I ?
Hi
Use the expression substring('your email body', 0, 500).
@@abm4975 thanks
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.
Hi
There are no send reply action button. What you could do is get the email body from the trigger and map it in your send email action step with your custom reply.
Thanks
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.
Is that image reference is a url?
Thanks
@@abm4975 In my situation, the customers have a few sentences of text, then an image they pasted into the email, maybe a few more sentences, one or two more pasted images and then maybe another sentence or two. Via power automate I save the email (based on subject content) to a sql table and save the body as varchar(max) - then the customers are able to view the email, based on filter criteria, in a powerapps gallery; however, the images do not show. I believe they are a cid and I cannot figure how to (1) make the image show in the gallery (I believe this may not be possible), and (2) how to enable the customer to click on the image url and view the cid by clicking on this email body in the powerapps gallery. Thoughts?
Thanks for your reply. If the images are coming from a url reference then it might be possible otherwise you need to store the images somewhere. I am not sure how to store the email embedded images?
Hello Ajith. Thank you for this video. It gave me an idea on how to parse the body of the email into text. I do have one question though. Let's say instead of just extracting the name, I want to extract age and gender as well, how do I go about doing that in an Apply to Each action? I'm planning to put them in one row in an excel spreadsheet table.
Hi
I was away for few weeks. Do you still need help in this please?
Thanks
@@abm4975 yes please, can you show us how to extract the age and gender and other values and store each value in separate column in a list please ?t
I've been hitting my head into a wall on how to iterate more values
It would be appreciated and Ill subscribe and like your videos to :)
Hi @abm abm, Thanks for your valuable content, Even though I have the same doubt, Could you please share a flow on how to concat the values from an email body and add them into single row in a excel file
Same here@@albaharh
Hello, if I have a line from the message body that contains the text string "xacd" how can I get the entire line?
Hi
Use a split() expression first to get each lines into an array. Then check "xacd" contains.
@@abm4975 thanks master ❤️
Thanks
Hi
I need to extract tables from email, can u pls hlp....
Hi
Thanks for your question. Damo got a good video about this. Please have a look.
czcams.com/video/i4GHCGMAD88/video.html
Thanks
Nice video, It is possible to classify emails and extract information only on emails received on business days and business hours excluding weekends and holidays and then send a Teams message to a Chat or group?
Hi
Thanks for your question. Yes you can. Mail trigger got a value called 'Received Time'. This holds the datetime value of the email you received. You can check using the expression called 'dayOfWeek()' Here passing the Received Time from the trigger. This will return 0 for Sunday, 1 for Monday and so on. Add an If condition to determine if its a weekend or not and use Terminate action step to stop the flow. Again for checking the business hours you need to parse the Received Time using formatDateTime() expression. eg: formatDateTime('RecivedTime from the trigger here', 'HH:mm') This will return the the hours and minutes in 24 hour format. Again add a check to determine if its more than 17 (5 pm) then terminate the flow. You could add all these as one expression under the trigger too. Its a bit complicated. If you need further assistance let me know. Happy to help you via a screenshare. Good luck.
Thanks
Hello, thank you very much for the answer, its sounds quite difficult, I will try to do it. I am new to this world of programming.
Hey
I could offer a screenshare. Check my channel about section and join via teams. I will have a look into this.
Thanks
Hi, this is a fantastic solution! I solved my issue with this video. Do you know how to store this multiple rows in one row of sharepoint list?
Hi
You could add string (variable action step) and use append to string to append all the values. Finally use this string variable to update the row of SharePoint list.
Thanks
@@abm4975 Can you show how to do it? I cannot imagine where to add extra function in the flow. Thanks
Hi
If you still need help connect me via teams. Have a look at my channel about section.
In an email, how to extraxt a specific text in between other characters (in a constant email format), example: process - Request Nr. 28753 has been submitted for your review. and i need only the request number.
Hi Muhammed
Use the last() and split expression to get the value
last(split('process - Request Nr. 28753','Nr. '))
very nice video...and how to extract a table from outlook email and paste into excel?
Have a look at this video
czcams.com/video/i4GHCGMAD88/video.html
Hi, this is awesome solution but i need to take rows instead of columns what i need to do?
Hi
Thanks for the support. Is your email body data in a HTML table? If not provide an example of data.
@@abm4975
Yes, it's html table in email body.
Columns are fixed but rows get added as and when data is updated as per new mail received.
Hi
Apologies for the late reply.
Have a look at this video.
czcams.com/video/i4GHCGMAD88/video.html
Thanks
only enter is on working, its taking space but not enter
Hi
It should work for both. I need to see your flow. If you still need help check my channel about section and contact me.
Thanks
How to extract email address from subject of an email
I need to see a sample format of the subject. Are there any specific patterns in your email subject?
Thanks
The enter key part doesn't seem to work for me
So that means in your email each lines are not recognized as enter keys. Is that email generated by other systems?
@@abm4975 Its an automated email generated by a failing machine. But its structured when the email arrives.
I need to see your flow. If you ok for a screenshare then see my About section. Send me an email. Thanks