web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Help with removing con...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by 2

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.

Categories:
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    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

  • Bprice502 Profile Picture
    2 on at

    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? 

    Sample Raw Output.PNG

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    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......

  • Verified answer
    v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @Bprice502 ,

     

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

    Sapmle:

    vxiaochenmsft_0-1652752191288.png

    vxiaochenmsft_1-1652752200832.png

     

    Best Regards,

    Wearsky

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 474

#2
11manish Profile Picture

11manish 268

#3
David_MA Profile Picture

David_MA 243 Super User 2026 Season 1

Last 30 days Overall leaderboard