cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Stephen1606
Level: Powered On

How to return a HTML table created from flow

I've created a flow to get football (soccer) fixtures from an api, it then creates a HTML table and saves the table as a html file in sharepoint. 

 

How can I now return that table into PowerApps?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to return a HTML table created from flow

Hi @Stephen1606

 

You can return a JSON array to PowerApps using a Request Response action. 

So I think the big deal is to convert this HTML table to a JSON object, then easy to collect this table into PowerApps.

Have a look on @mr-dang Youtube Video Replace the Array sent from Flow to PowerApps to learn how to return a JSON.

 

For convertion HTML to JSON, I can not see any easy mean, I think maybe with a lot of Data manipulations. You can find some tips here JSON cheatsheet for Flow.

 

Théo

View solution in original post

3 REPLIES 3
gokello
Level 8

Re: How to return a HTML table created from flow

I think these two options would work:

1. Store the html content in a field within SharePoint (multiple lines text with enhanced rich text formatting.  Then bind this field to the html input control in powerapps.

 

2. Convert the html into PDF.  Then use PDF viewer control in Powerapps to view it.

Super User
Super User

Re: How to return a HTML table created from flow

Hi @Stephen1606

 

You can return a JSON array to PowerApps using a Request Response action. 

So I think the big deal is to convert this HTML table to a JSON object, then easy to collect this table into PowerApps.

Have a look on @mr-dang Youtube Video Replace the Array sent from Flow to PowerApps to learn how to return a JSON.

 

For convertion HTML to JSON, I can not see any easy mean, I think maybe with a lot of Data manipulations. You can find some tips here JSON cheatsheet for Flow.

 

Théo

View solution in original post

Stephen1606
Level: Powered On

Re: How to return a HTML table created from flow

Thank you! This is exactly what I was after. Couldn’t get the MID and Find functions to work as suggested but managed to come up with a workaround for that.

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,911)