Share
ReportHi, I have a flow which pulls data from a web API using HTTP http action and it returns a json object. I want to return the data to Power Apps and store it as a table. Like down below, very simple
I did some research, found this post, https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/. Basically the idea was use Response action to return the data array back to Power Apps. and use collection the store the array.
This is the data coming in the Response after manipulate the object
And here is the Response Body JSON Schema
Everything seems very identical to the article I mentioned earlier. But when it comes to adding the flow in this step
- Configure the Button's OnSelect property to run the flow.
Action > Flows > Select the flow from the right-hand panel that pops out
there was an error saying "failed during http send request" like this
I thought it was because I had too many records (nearly 3000), then I tried using first() to get the first element in the array... it succeed. I was able to see the data in the collection. Then I tried take([array_name],count) to pass first 10 records to the Response, i got the same error. So it seems have nothing to do with the amount of records.
My question is ... Response should work the same way with http as it was with sql right? why it didn't? (in other word, why it works with single object not a array?) Is it the limitation of Response?
All responses (
Answers (
7
