Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Parsing text from emai...
Power Automate - Building Flows
Unanswered

Parsing text from email and inserting row into Excel

(0) ShareShare
ReportReport
Posted on by anm8tr 12

Hello,

 

 I figured at least one way to extract the info I need from an email and insert into row in Excel.  My questions is

how to change the formatting.  Long story short,  I end up with an array of text and I'm using this formula to extract:

split(outputs('Split_Body_Text')[48],'')   it's working but the formatting looks like this inside Excel :  ["J004037535"]

 

How do I get rid of the brackets and quotes?

 

I have to sift through a lot of text in the emails, it's not a three or four line simple form with 6 words like 99% other examples I see online. I'm extracting only 5 pieces of info but the emails have tons of Html and extraneous text of no use to me.

 

Thx for any feedback!

  • anm8tr Profile Picture
    anm8tr 12 on at
    Re: Parsing text from email and inserting row into Excel

    I figured it out!  It's working now!

     

    last(split(outputs('Split_Body_Text')[37],''))

  • anm8tr Profile Picture
    anm8tr 12 on at
    Re: Parsing text from email and inserting row into Excel

    The strings I'm extracting are going into my Excel workbook.

    But they look like this: ["6300 W Sweetwater Ln Laveen, AZ 85339"]  I want the string without the brackets and quotes.  i.e.   6300 W Sweetwater Ln Laveen, AZ 85339

     

    Thx for your help!

  • VictorIvanidze Profile Picture
    VictorIvanidze 12,536 on at
    Re: Parsing text from email and inserting row into Excel

    And what do you want to do with non-empty strings?

  • anm8tr Profile Picture
    anm8tr 12 on at
    Re: Parsing text from email and inserting row into Excel

    I would assume there is a way to trim off the excess garbage.

  • anm8tr Profile Picture
    anm8tr 12 on at
    Re: Parsing text from email and inserting row into Excel

    Apparently my last reply was deleted. Very strange! This is a sample of the output from Split_Body_Text

     

    [
    "--------------------------------------------------------------------------------",
    "",
    "Property Information",
    "",
    "Property Address",
    "",
    "6300 W Sweetwater Ln Laveen, AZ 85339",
    "",
    "Inspection Due Date",
    "",
    "",
    "",
    "Gate Access",
    "",
    "",
    "",
    "Gated Code",
    "",
    "",
    "",
    "HOA Access",
    ""
    ]

  • VictorIvanidze Profile Picture
    VictorIvanidze 12,536 on at
    Re: Parsing text from email and inserting row into Excel

    Show outputs('Split_Body_Text').

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans