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?
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)!
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
991
