Answered

Help with removing content from Email and adding it to SharePoint List

(0) Share

Report

Posted on by Bprice502

Hello all,

I am in the middle of creating a flow that takes an automated email and extracts the "wanted" data, and places it into an SP list. I am having difficulty converting the text to a usable array. Each time I have tried to create a flow using the compose feature, I end up converting the text to a single line or string of text instead of multiple lines to call out the specific information I want.

Please see the attached demo email and screenshot of my current flow with my received output.

Email Content.PNG

PA Flow.PNG

Raw Output-Compose.PNG

I would like to only extract the numerical values from each line and place them into an SP list. Thanks in advance for any help.

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report

Re: Help with removing content from Email and adding it to SharePoint List

Hi @Bprice502 ,

Do you mean that you want to remove '\n'?

Sapmle:

Best Regards,

Wearsky
Bprice502 2 on at

Like (0)

Report

Re: Help with removing content from Email and adding it to SharePoint List

Hello @v-xiaochen-msft,

Thanks for your reply. I can get this to work partially now. I am having issues with the unwanted new line designator that's being applied randomly as my flow runs. Is there a way to remove this in the raw output? Or is there a way to look past it?

Maybe my solution is to rewrite the automated message from our machines to utilize brackets [ ] around the numerical values to control where I am looking. Hmmm......
v-xiaochen-msft on at

Like (0)

Report

Re: Help with removing content from Email and adding it to SharePoint List

Hi @Bprice502 ,

It is difficult for powerautomate to extract the numerical values.

One method is to use excel script to run regular expression. It requires a license.

Some third-part connectors support extracting values .But they are not free.

Best Regards,

Wearsky