Send JSON parsed data to PowerApps

(0) Share

Report

Posted on by craicovici317

Hi - I am trying to display the results of my CSV Table into a simple Gallery in PowerApps.

This is the output of my CSV Table
this is the ideal response that I am trying to use in my PowerApps Gallery but because this CSV Table resides within a loop I am not able to output it directly to the gallery.

subscriptionId,source
65a658b6fe12857c42c65caa,iFreedom
65a658b6fe12857c42c65caa,DataQuery

I tried to append the output to an array variable then link it to the next action

the data comes out in this format

{
 "statusCode": "200",
 "schema": {
 "type": "object",
 "properties": {
 "output": {
 "title": "output",
 "x-ms-dynamically-added": true,
 "type": "string"
 }
 },
 "additionalProperties": {}
 },
 "body": {
 "output": [
 "subscriptionId,source\r\n65a658b6fe12857c42c65caa,iFreedom\r\n65a658b6fe12857c42c65caa,DataQuery\r\n"
 ]
 }
}

I would really appreciate any other suggestions! Thanks in advance

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Pstork1 69,547 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, the Respond to Power Apps action can't return an array of values. So there are two possible workarounds. First, you can use the HTTP Response action to return the array of values and store it as a collection. Its very easy to do, but it does require a Premium license. The other way to do it is to return the array as a JSON string and use the ParseJSON() function in Power Apps to convert the values to a table. This is harder to do because the ParseJSON() function will output all the values as untyped values, which makes them difficult to use in controls. This article is a walkthorough of how to use the ParseJSON function. Power Apps ParseJSON Function: Get Collection From A Flow (matthewdevaney.com)

Was this reply helpful? Yes No
craicovici317 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, the response option worked!

1. Add the PowerApps (V2)
2. Your HTTP Connector
3. Parse JSON
4. Add its body to a Compose
5. Initialize dataString type string
6. Select from each output from Compose
7. Append to string Variable the output of your select (this will send the data out of the for each loop)
8. Response, and pass the dataString variable

=== BONUS ===
If you want to integrate this with PowerApps and display its data to a basic gallery, do this:
1. Add a canvas app
2. Add your flow using the side bar menu
3. Add a button and collect the data from the flow in a simple collection (ServicesList)
ClearCollect(ServicesList,'ServicesListAPI2-2'.Run());
4. Add a Vertical Gallery and set its Data Source to the Collection Name provided previously

EURIKA! Now that should work 🙂

Here's my final result

Was this reply helpful? Yes No