Power Platform Community Forum Thread Details

Hello community ..
I am working on extracting data from a Power Automate HTML table to PowerApps with dynamic columns that change every time. While I can display the data in PowerApps using HTML text, the CSS styling for formatting the table is not working. Could you help me fix this issue or suggest an alternative method for extracting and displaying the data?

Categories:

Building Power Apps

I believe the HTML Text Control needs the CSS to be inline.
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-html-text

I do know you can update a simple HTML table using "Substitute" to find each cell, row, header, etc., element that you want to add css to.
E.g. here I'm adding some styling to the headers

And I've used this before to add borders and background fill to tables in the past.

Still, it’s kind of tedious and limited, so what I prefer to do is just return my data as an array to Power Apps and convert it to a table to display in a gallery.
Return Array to Power Apps
Here I return the JSON Array output by the "Select" action to Power Apps in the "array" parameter of the "Respond to a Power App or Flow"

Save Flow Response as Variable in Power Apps
Set(vFlowResponse,ReturnArrayandHTMLtoPowerApp.Run())

Convert the Array as String into a Table
Use Table() and ParseJSON() to convert the string returned from the flow.

Add Controls to your Gallery and Select Columns From Table
Reference column values by "ThisItem.Value.<column_name>"

This method gives you much more latitude to style your data collection, and use other controls like images, links, buttons, etc., with your data.

If this helped you, please click "Does this answer your question" and give it a like to help others in the community (+ close the ticket)!

Power Platform Developer | LinkedIn: Mark Nanneman | Blog: Power Stuff | YouTube: Mark's Power Stuff |