Power Automate - How to read email contents and extract values (unstructured data)? - Part 2/2

This video explains how to read email contents and extract values from an unstructured data using Power Automate.
First part video for structured data.
Power Automate - How to read email attachment contents and extract values? Part 1/2
• Power Automate - How t...

[@h2oski1200]

this was helpful and honestly the troubleshooting of the issue was also good to see.

[@abm4975]

Thanks a lot for your kind comments and support.

[@marcos311]

Thanks man, very useful video, you are awesome!

[@abm4975]

Glad it helped!

[@manjulmishra990]

Hello need help, i created on automation but the split function not taking the full line, its divided into 2

[@tpops2697]

Can you show how to put this information in an Excel Spreadsheet?

[@abm4975]

Hi
Yes you can. So in Power Automate you can use Add a row into table to insert the values.
Thanks

[@myheliography]

is there any way we can auto-categorize the incoming emails? for example, i am sending an email also i am getting a reply for the same, the system should read my signature and based on the signature it should categorize the email.

[@abm4975]

So you may need to check an IF condition using the Email body and use the contains operator here to check the specific signature text. I have other video regarding categorize here.

[@amitpawar20]

If we have two times name: in same email, this logic will overwrite the first occurrence, right?

[@abm4975]

Yes unless you can cater the second one into another variable or so.

[@Ajay__Baby]

Hi I want to take data's from html format. When i Used with Html to text conversion all the data's are mixed up without any space or commas. Do you have any idea to sort this out.

[@abm4975]

Hi
I need to see your flow. If you still need help then please post this under the Power Automate community and tag me as @abm. Also if you want a screenshare connect me via teams. Check my Channel About section for more details.
Power Automate Community Forum
powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Thanks

[@Ajay__Baby]

@@abm4975 Thanks for the reply. Somehow I sorted it. This video helped a lot

[@abm4975]

Thanks

[@epidot4520]

What if some values run for multiple lines in the email. Return delimiter will no longer work I assume.

[@abm4975]

That means those lines are no separated by carriage returns.

[@varunkumar-il1tf]

Hi
Can you please share a video related to the 1: How do I Read the attached mail and extract the pdf
from SharePoint

[@abm4975]

Unfortunately its not possible to using standard out of the box connectors. You may look into third party connectors.

[@yuvpav210]

How to extract text file content which is uploaded in dataverse and automatically update in same dataverse table dynamically... Expecting a suggestion

[@abm4975]

Hi
So you want to insert and append the text file in dataverse?

[@yuvpav210]

@@abm4975 yes

[@abm4975]

Interesting question. Let me think about it.

[@GDCarpetUpholstery]

What if the data is all in one line??? Name:ABC Date: 01/01/2022 Company: 12345

[@abm4975]

Hi
Still you could use the split() expression to get all the values. Use the separator as colon.
Thanks