Is there a way to parse HTML table output?

[Anonymous]

So the fields can be used in the POST API call?

[efialttes]

@Anonymous 

There are several posts covering this topic, suggesting different approaches either with external connectors or with built-in functionalities, for example:

https://powerusers.microsoft.com/t5/Building-Flows/How-to-parse-email-body-as-a-condition-in-MS-flow/td-p/169029

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Using-a-flow-to-extract-email-body-details/td-p/149186

Please also note some improvements are expected on Flow roadmap next month

https://docs.microsoft.com/en-us/business-applications-release-notes/April19/microsoft-flow/extract-structured-data-emails-html-pdf

Hope this helps

[Anonymous]

Hi @efialttes ,

Thank you for the reference. Do you have references on having the headers from HTML table parsed and use the parsed items to the POST API call? Thanks.

[efialttes]

@Anonymous 

This was the situation last summer

https://powerusers.microsoft.com/t5/Building-Flows/Extract-elements-from-HTML-table-from-email/td-p/176476

Some users use "HTML to Text" action block + WDL expressions as a workaround, as you will see in some of the posts I shared in my initial response.

Hope this helps

[v-zhos-msft]

Hi @Anonymous , 

Here is a case of how to use the outputs in the 'Parse JSON' action.

Please take a reference, hope it will help you.

https://powerusers.microsoft.com/t5/Building-Flows/Get-last-row-in-Excel-table-with-data-in-it/m-p/280828#M29088

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[efialttes]

@Marty9 

Extremely valuable contribution, thanx for sharing!!

[carlilelance]

So yeah, there are several answers, but there aren't any good ones. Parsing text has to be the worst possible way of going about this. There should be a built in plugin to get values from HTML objects. Is PowerApps destined to be one giant hack? Hopefully Microsoft will fix this soon.