web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Html to text - how to ...

Power Automate

Suggested Answer

Html to text - how to insert output into a table in Excel file

(0) Share

Report

Report

Posted on by DŻ-22100800-0

Hello to all code crackers.

I'm struggling with one thing in PowerAutomate flow.

I want to insert the output of a Html to text body into an Excel file (each line should be inserted to a different row in the Excel table).

Output of Html to text looks like this:

Organization: Test
First Name: Test
Last name: Test
E-mail: test@tester.com
Phone number: 666666666

I tried different tutorials but none of them seemed to solve the puzzle with the expression that has to be used in order to achieve my goal.

None of the "split" nor "trim" expressions did the trick.

Can anyone help with the text expression I need to use in Add a row into a table?

Categories:

I have the same question (2)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

CU17121318-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hii,

I recommend to also insert the "body" in the Add row to table part.
for me, HTML is also the column header of the table.

You will receive the whole HTML script in the first Cell A2, but this you can filter with Mid and Trim formulas

Was this reply helpful? Yes No
Suggested answer

Tomac 4,171 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Here's what you need:

The split() function is:

split(outputs('HTML_to_text'),decodeUriComponent('%0A'))

Was this reply helpful? Yes No

Join the conversation