Trouble with the "split" function.

(0) Share

Report

Posted on by LR-11071431-0

I am very new to Power Automate and was tasked with building flows to extract certain values from an email into an Excel workbook.

I was able to get the body of the email extracted however the results returned are as shown below

  "APPLICANT",
  "Item",
  "Value",
  "Applicant First Name",
  "FName",
  "Applicant Last Name",
  "LASTNAME",
  "Named Insured Email Address",
  "name@company.com",
  "Applicant Phone Number",
  "+1 (xxx) xxx-xxxx",
 
The issue is I need to split certain values to eventually add to excel, and the syntax I used is (I believe the " is the issue)
last(split(outputs('SplitBodyText')[9],'"')), found a video on youtube to get this process but in their example they had a different delimiter in their output.
I have tried different variations and also tried the "\" to escape the double quotes. I just do not have the knowledge how to proceed.
 
I also tried to replace function to remove the ", no luck either and also tried to replace them with ' also no luck.
 
If someone has any suggestions it would be appreciated.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Infamous_Let 332 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
split(replace(outputs('Get_Email_Body'), '"', ''), ',')[8]

This should removes the quotes ("), Splits the string by commas and Gets the 9th item (index 8) which is the email.

test it in a compose action and change the index as needed

Was this reply helpful? Yes No
LR-11071431-0 12 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your suggestion, it did unfortunately did not work. I have never used Power Automate and learning as I go as this was tasked to me. I have a screenshot of the flow I found online to accomplish this, but have to alter it a little due to the html to text output difference. Hopefully this will add a little more context. If there is another way to accomplish this I will gladly tack to a different approach. Thank you everyone.

Split(Body('Html_to_text'),outputs('EnterKey'))

split(replace(outputs('SplitBodyText'), '"', ''), ',')[8]

Was this reply helpful? Yes No
Suggested answer

LR-11071431-0 12 on at

Like (1)

Report
Copy link

Link copied!

I was able to figure it out once I saw how it handles double quotes.

Was this reply helpful? Yes No