cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrobbins
Frequent Visitor

Extract Columns From HTML Table so I Can Send the Table in Email

I am trying to extract three pieces of data from an HTML table to put those three data elements (or a new HTML table) in an email. My struggle is to get the values out of the automatic HTML table so I can manipulate them (like formatting the date). Here is my flow and the HTML table output.

 

mrobbins_0-1655223075225.png

Here is my HTML table

  • Columns in yellow are the only columns I want in the table.
  • In the first column in blue is the time that I need to parse and convert to CT
  • In the 2nd column, I only want the "LookupValue" to get the name of the person making this update
  • The 3rd column is fine as is.

mrobbins_1-1655227488343.png

 

How do I get this prettied up?

1 REPLY 1
MarconettiMarco
Super User
Super User

Hello,

most probably you should add the "Parse JSON" action after the "Create HTML Table" one in order to get that properties.

 

BR,

Marco

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,784)