Re: Power Automate - Canvas App - put HTTP Reponse... - Page 2

lee-martin · ‎03-15-2022

I'm calling an API from a Power Automate Flow.

I'm able to get the data I require in the flow, but I'm struggling to output this correctly from the Flow into my Canvas App.

In the PA Flow - I'm parsing my JSON, and putting it into a Select. The Select is then followed with a HTTP Response which I pick up in my Canvas app, and intend to put that data directly into a collection.

It is working as expected populating the collection with some sample data I've tried, but not with the data from the API call.

The collection for the data from the API is showing the field names in the Map (of the Select) as columns, but it isn't populating any data

I've tried playing around with the JSON schema adding random samples of the API data, and it's not worked.

Is there anything else I can check to get my data in my collection (including anything else I can try with the schema)

Thanks

ansrikanth · ‎03-15-2022

Right, with whatever the limited understanding i have, it seems the flow is working fine for you and is returning the proper response to your powerapp, it is just powerapp that is not able to read/collect properly.

I would cross check the flow HTTP response (the very last step of your flow) once again and ensure it has the proper JSON schema defined and in fact it is returning the output. After that, I will delete the data source/connection to flow once and reconnect again and see if that works..

You can also use Monitor, to see what response you are getting from flow to clear out the doubts.

Thank you

-Srikanth

sgtsnacks64 · ‎03-15-2022

@lee-martin wrote:
I've just tried my working sample data with a field in one row changed to Null and that's given me the same issue.

So assuming that is the issue, how would I deal with null values in the Select or Response?

You can specify more than one type in your schema,