Power Automate - Canvas App - put HTTP Reponse In a Collection

[lee-martin]

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]

Are you saying your Select in Flow is not capturing the API data? Can you explain with some screenshots?

Thank you

-Srikanth

[lee-martin]

I don't know what it is doing. All I know is my test sample and API data are done in the same way, one is populating data, the other is not

[ansrikanth]

Have you checked what is the output values of your API HTTP response and Select output in the flow after executing it ?

What it is showing?

Thank you

-Srikanth

[lee-martin]

@ansrikanth  There is appropriate JSON in the Search and the Response

[lee-martin]

Can fields with null data be causing an issue?

[ansrikanth]

would you be able to share some screenshots? @lee-martin 

[lee-martin]

@ansrikanth  Sorry no, the work is on a different laptop and also has business sensitive data in it which I would need to show to demonstrate this

[sgtsnacks64]

Have you verified that the HTTP request (to the Web API) is actually returning data before the select operation?

I'm wondering if the filtering being done in Select is not returning the data you need, so we should eliminate that first.

Have you tried just outputting the response to the HTTP request into the HTTP response for the PowerApp (with the schema)?

[lee-martin]

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?