Power Platform Community Forum Thread Details

Hi All,

I have created a flow which reads an Excel table and passes the data back to a PowerApps Canvas App using a Respond to a PowerApp action. The objective within the Canvas App is to take the data returned from the PA flow (JSON, I assume) and then use the ParseJSON command to transfer the data into a PowerApps collection.

The issue that I have is that whilst the flow appears to be working as I intended, the data that is returned to PowerApps is not quite right.

The flow uses a List Rows Present in a Table Action and then a Select Action to select the columns into an array. The output from the select looks exactly right, however, it appears a Compose Action is required before I can send the data back to Power Apps using a Respond to a PowerApp Action ...

1 - Output After Compose Action

The output from the Compose Action appears to be a correctly formed JSON array, this is exactly what I need to return to Powerapps.

2 - Output After Respond to PowerApps Action

The output from the Respond to a Power App action has changed fro the Compse step. There is now a header (the Excel table name "transactions") at the front, and there are "\" characters within the data.

I don't understand this as the Respond to PowerApps action simply takes the output from the Compose step so I wasn't expecting the data to be changed.

Clearly, I am not comprehending something so I would be very greatful for any help, as I have been tearing my hair out for days :)

Best Regards, Craig

Categories:

Using flows