cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sudosaurus
Post Partisan
Post Partisan

Set status based on number value of another column

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".

 

offices.png

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

@sudosaurus 

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:

image.png

 

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.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

5 REPLIES 5
ScottShearer
Super User
Super User

@sudosaurus 

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:

image.png

 

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.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Thanks @ScottShearer that was much more simpler and makes sense. I was trying to over-complicate my workflow!

@sudosaurus 

Glad to help!  Please watch out for the infinite loop.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

It seems to be working correctly. What signs should I look out for re. Infinite Loop?

@sudosaurus 

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......

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,221)