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

Community site session details

Session Id : kQqwf+Y6gxRjfEDLzco78y
Power Automate - Building Flows
Unanswered

Parsing text from email and inserting row into Excel

Like (0) ShareShare
ReportReport
Posted on 20 Feb 2023 06:07:33 by 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
    12 on 21 Feb 2023 at 04:24:51
    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
    12 on 20 Feb 2023 at 22:21:21
    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
    12,546 on 20 Feb 2023 at 15:46:03
    Re: Parsing text from email and inserting row into Excel

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

  • anm8tr Profile Picture
    12 on 20 Feb 2023 at 15:31:41
    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
    12 on 20 Feb 2023 at 15:14:03
    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
    12,546 on 20 Feb 2023 at 07:31:14
    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

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

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!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2