Extract information from the body of an email into a sharepoint list

(2) Share

Report

Posted on by BD-05121759-0

Hello guys

I want to extract information from the body of an email and save this information in a sharepoint list according to each column/ information.

I tried following the flow of the picture, but it's not working . In "HTMl in text", I just put que "body" of the email.

In Compor = split(body('Html_to_text'),decodeUriComponent('%0A%0A'));

In Compor 1 = trim(split(outputs('Compose')[0],':')[1]);

Compor copy = split(body('Html_to_text'),decodeUriComponent('%0A%0A'));

Compor 2 =trim(split(outputs('Compose')[0],':')[2]);

After that, i select the outputs of Compor 1 and Compor 2 , and tested the flow , getting the 2 picture .

I dont know where the error is, can somebody help me ?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Michael E. Gernaey 53,958 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @BD-05121759-0

Please share the email format itself. Please also share the flow run, with the outputs etc. And also your flow expressions, in the action so we know which is which

Then should be able to help :-)

Oh and if you can explain the Body of the email, and what you want from it. I love the expressions but that requires us to re-verse engineer what you are thinking, if you could simply say from line 1 i need xyz etc please

Thanks!!

Was this reply helpful? Yes No
VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

Try to use this approach: https://ivasoft.com/parsemsinvoiceflow.shtml instead of "HTML to text" action.

Was this reply helpful? Yes No
Suggested answer

rzaneti 4,476 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @BD-05121759-0,

It looks like you are placing your expressions directly in the "Compor" inputs, and not in the expression pane, so Power Automate is saving the expressions directly in the SharePoint List. Just highlight your Compor input and click in this Fx:

This pane will appear. Enter your expression (in red) and once you're done, hit add (in green):

To confirm that everything is fine, your input may look like this after clicking Add:

After it, save your flow and test it again.

If you find any specific issue with your expressions (which is pretty normal), please provide a sample of email body and the expected output for each "Compor". Make sure to remove any sensitive data before sharing it :)

I'm also sharing a few contents related to this topic for your reference:

- Video: Automate data extraction from email to Excel with Power Automate - https://youtu.be/RIaAi6Cmevw

- Blog: How to extract and clean texts with Power Automate - https://digitalmill.net/2023/08/12/how-to-extract-and-clean-texts-with-power-automate/

- Blog: Writing expressions in Power Automate - https://digitalmill.net/2024/02/27/writing-expressions-in-power-automate/

Let me know if it works for you or if you need any additional help!

If this is the answer to your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

Check more Power Platform content on my website.
Lets connect on LinkedIn.

Was this reply helpful? Yes No