create 2 collections based on HTTP response from flow containing 2 different array/object sets

(1) Share

Report

Posted on by Cgangweg01

870 Super User 2026 Season 1

Hello -

I have figured out how to get two different array/object sets into the output of an HTTP response action in power automate with the applicable and different JSON schemas. The action output is as expected.

Using a canvas button OnSelect, ClearCollect and running the flow I am able to populate the StorePrices collection, see function pictured below. This works like a charm.

Is there a way to apply the ZonePrices part of the flow HTTP response payload to a different collection without adding another canvas app button with another flow?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

BhaskarDhone 1,394 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can first get the complete power automate response into a variable and then use variable to fill collection.

Something like below

Set(varPowerAutomateOutput,GetCurrentpricebySKUresponse.Run(TextInput1.Text));
ClearCollect(colStorePrices,varPowerAutomateOutput.StorePrices);
ClearCollect(colZonePrices,varPowerAutomateOutput.ZonePrices)

Was this reply helpful? Yes No
Cgangweg01 870 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much BhaskasDhone for the reply.

I was able to set the variable and pull in the first collection for StorePrices. That worked when I ran the app.

But when I construct the second collection it does not recognize the property ZonePrices. See first screen shot.

When I try to refresh the flow connection I get an error, see second screen shot. I have a hunch that the flow Body of the HTTP response is not in a good format. I have the properties StorePrices and ZonePrices separated by a comma which does not give an error in power automate so I thought it was good. See third screen shot.

Any suggestions at this point?

Was this reply helpful? Yes No
Cgangweg01 870 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello Bhaskar,

I redid the schema in the Response action and readded the flow to the app and your solution worked! Each of the arrays is in a different collection which is exactly what I wanted. Thank you!

My next problem ... for some reason the collections are no longer showing as data sets available to any new table I add. I think it might be a bug with power apps but I'm not sure. Any idea?

Was this reply helpful? Yes No
Suggested answer

Ravindra Jadhav 342 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hii,

You Are Using Premium Connector You can Directly Pass the combined table in Power Apps

Please Closed the Question, Mark it Solved

If my answer helped resolve your issue, please consider marking it as solved to assist others facing the same problem. Additionally, giving it a like would be greatly appreciated and motivates us to keep helping

Thank You

Ravindra Jadhav

Please Subscribe to https://www.youtube.com/@jadhav_ravi_oo7

Connect On https://www.linkedin.com/in/ravindra-jadhav-powerplatform/

Was this reply helpful? Yes No