web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Get result from two ta...

Power Apps

Unanswered

Get result from two tables which use two Power Automate

(1) Share

Report

Report

Posted on by usaman45

314

I need to get records from Two tables which need to use SQL store Procedure.

Then, I use two Power Automate flows to get result and put it into two collections.

Is there a way just use one Power Automate flow to get all result back into Power Apps?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

muzammilasif 71 on at

Like (0)

Report
Can you please share the flow, how are you returning the values in the flow? Further respond to power apps connector allows you to return multiple variables, so that you can use single flow to return the multiple values and can user in the power apps.

Set(ReturnValue, FlowName.Run(//your code here)); ClearCollect(Col1, ReturnValue.Value1); ClearCollect(Col2, ReturnValue.Value2);

Hope this helps!!

Was this reply helpful? Yes No
Cgangweg01 727 Super User 2025 Season 2 on at

Like (0)

Report

Hello usaman45,

Did you ever figure this out?

I am using Power automate HTTP response to send an array with objects payload to a canvas app. I figured out how to include two different arrays/objects sets with different JSON schemas in the output, but I can't figure out how to apply that payload to two different collections.

By the way, this works like a charm when the payload contains just one output straight into a single collection.

Thanks!

Was this reply helpful? Yes No

Join the conversation