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

Prevent Flow from running in parallel

I have a PowerApp that allows staff to create a sharepoint list item.

 

I then use MS Flow to trigger off of list item creation. 

 

The flow does the following:

1) Query sharepoint list - parameters include status which I set in (4)

2) Count number of rows

3) Check if current count exceeds allowed number

4) Modify list item status to "Approved" or "Waiting List" based on (3)

 

My problem is that if several items are created within 1min of each other, the flow triggers for them at the same time, and they share the same current count, which is incorrect.

 

This then causes the "Approved" items to exceed the allowed number. Is there a way to prevent this?

 

I've gone through this forum post, which was no help. Thanks in advance 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Prevent Flow from running in parallel

So it seems that the mistake was mine. My Sharepoint query was returning only the top 100 rows. 

 

This Top Count placeholder should be fixed T.T

 

temp.jpg

View solution in original post

1 REPLY 1
Highlighted
Frequent Visitor

Re: Prevent Flow from running in parallel

So it seems that the mistake was mine. My Sharepoint query was returning only the top 100 rows. 

 

This Top Count placeholder should be fixed T.T

 

temp.jpg

View solution in original post

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,706)