Hello,
I have built the list below for counting staff into our offices as they begin to re-open following the COVID-19 crisis.
We'd like a flow to update the status column for a list item if the "Staff" column equals the same number as the "Capacity" column.
By default this column is set to "Available".
Solved! Go to Solution.
First, you could use a calculated column in SharePoint - no need for a Flow. Using a calculated column will help you avoid an infinite loop.
If you want to use a Flow, see my example below:
If you implement this solution please see this blog post that I wrote.
Updating the same item that triggered the Flow will create an infinite loop - that's what my blog post addresses.
First, you could use a calculated column in SharePoint - no need for a Flow. Using a calculated column will help you avoid an infinite loop.
If you want to use a Flow, see my example below:
If you implement this solution please see this blog post that I wrote.
Updating the same item that triggered the Flow will create an infinite loop - that's what my blog post addresses.
Thanks @ScottShearer that was much more simpler and makes sense. I was trying to over-complicate my workflow!
Glad to help! Please watch out for the infinite loop.
It seems to be working correctly. What signs should I look out for re. Infinite Loop?
The trigger that you are using fires when an item is created or modified. The Flow may update the list item. If the list item is updated, then the Flow will started again causing another update and causing it to start again......
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
User | Count |
---|---|
27 | |
26 | |
25 | |
24 | |
18 |
User | Count |
---|---|
56 | |
44 | |
33 | |
31 | |
30 |