Power Platform Community Forum Thread Details

Hi. I have developed a flow that authenticates to an API and then runs a simple POST command to return a JSON response of data with 2 fields - id and name. So for example the response would have several results like

{ "id" : 123,

"name : "abc",

"id" : 234,

"name" : "bcd"

etc...

}

I have a PowerApp and can add the flow to it, my question is what additional steps do I have to take in Flows (i.e. parse json data? append to list?) and in PowerApps (create gallery based on this flow's results somehow?) to populate a dropdown or table or gallery or anything based on the "name" results only from the API flow response?

Categories:

Building Power Apps

Hi @CU12061616-0,

Na additional steps need to be taken in Power Automate, but in Power Apps you do:

In the App.Onstart property, you have to call the Power Automate flow and parse the returned JSON string before storing it in a collection. This collection can then be used to poulate the options in a dropdown control.

For parsing the JSON string, you can use the ParseJSON function in Power Apps: ParseJSON function - Power Platform | Microsoft Learn

Based on the provide schema, the formula may look something like this:

ClearCollect(
    colDropdownOptions,
    ForAll(
        Table(ParseJSON(PowerAutomateFlow.Run().Response)),
        {
            id: Value(ThisRecord.Value.id),
            name: Text(ThisRecord.Value.name)
        }
    )
)

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.