cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
M-DH
Frequent Visitor

Running a power automate flow on multiple records from Power Apps

Hi,

 

I managed to create an app that collects a number of records for me.

My final obstacle is getting a power automate flow to run a branch of actions on each separate record in my collection.

 

I feel like I need to convert the collection to a Json format but not entirely sure I'm on the right track.

Any help or pointer is greatly appreciated!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Running a power automate flow on multiple records from Power Apps

Hi @M-DH ,

Based on the needs that you mentioned, I agree with your though almost. Currently, Power Automate only accept String value as parameter value passed from a canvas app.

 

As an alternative solution, you could consider convert the collection records into a JSON table string value using JSON function, and then pass the converted JSON string value to your flow.

 

I have made a test on my side, please check and see if it would help in your scenario or video:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Save-a-multiples-rows-of-items-in-a-single-f...

 

https://www.youtube.com/watch?v=HLdOO4JPZ2I

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
EricLott Resident Rockstar
Resident Rockstar

Re: Running a power automate flow on multiple records from Power Apps

Here is a tutorial for sending collections to Power Automate. You could also use ForAll() to loop through your collection, but that may too resource intensive.

https://www.powerobjects.com/blog/2019/09/19/send-a-collection-from-powerapps-to-flow/

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Community Support
Community Support

Re: Running a power automate flow on multiple records from Power Apps

Hi @M-DH ,

Based on the needs that you mentioned, I agree with your though almost. Currently, Power Automate only accept String value as parameter value passed from a canvas app.

 

As an alternative solution, you could consider convert the collection records into a JSON table string value using JSON function, and then pass the converted JSON string value to your flow.

 

I have made a test on my side, please check and see if it would help in your scenario or video:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Save-a-multiples-rows-of-items-in-a-single-f...

 

https://www.youtube.com/watch?v=HLdOO4JPZ2I

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

M-DH
Frequent Visitor

Re: Running a power automate flow on multiple records from Power Apps

Hi @v-xida-msft ,

 

Helped me out perfectly, thanks!

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,784)