web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Parsing text and extra...

Power Automate

Unanswered

Parsing text and extracting text

(0) Share

Report

Report

Posted on by ssmith1

I receive an automated email message with tabular data. I have used the "HTML to Text" function and received the output listed below. I am trying to capture each identifier such as "Name," "Company," "Address," etc. There are seven such fields that I'd like to capture so that they can be displayed in an Excel file across columns.

Search Criteria:

Name

: Wiley Coyote

Company

: Acme Corporation

Address

: 123 Sunset Ln

City

: Palo Alto

State

: CA

Country

: United States

Zip Code

: 98765

Search type:

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @ssmith1

Here's one way to do it:
The first 3 actions are Compose actions:
1st Compose - just hit enter. That's how we will split the text to parse
2nd Compose - The text you posted as an example
3rd Compose:

split(outputs('Text_to_parse'),outputs('Line_break'))

Use Filter array to get the columns, by putting Compose 3 in the From field and using the following formula (entered in Advanced mode)

@or(not(startsWith(item(), ':')),endswith(item(), ':'))

Here's the result for columns:

If you want values, change the Filter array to:
@startsWith(item(), ':')

Result for values:

Was this reply helpful? Yes No

Join the conversation