Forum Discussion
Checking the status field of all items in a sharepoint list
I have a sharepoint list that is maintained throughout the day by each of our bank branches. Each branch has their own item in the list. When they are done for the day, they change their status to ...
That could work. But I would use a get list items on a scheduled run every 5,10,15 minutes or so. Whatever is acceptable.
Then get items action on the list.
Next out a condition and out the get items status field in the check and this will add an apply to each loop. For the condition put in = verified.
For the no branch when false out an end workflow (might be terminate) action.
This will make it not continue if all the items aren’t true. After the loop then do what you want when all items are verified. You can then also do another update item and use the get items status column update in it and it will loop through each item and you can reset it automatically And also plug your email action before or after this loop through the items. If you don’t want to reset then obviously skip this step.
Anyway the other suggested option will work too but this way you can do without an additional list but a little more complicated.
Hope it helps ;).
Then get items action on the list.
Next out a condition and out the get items status field in the check and this will add an apply to each loop. For the condition put in = verified.
For the no branch when false out an end workflow (might be terminate) action.
This will make it not continue if all the items aren’t true. After the loop then do what you want when all items are verified. You can then also do another update item and use the get items status column update in it and it will loop through each item and you can reset it automatically And also plug your email action before or after this loop through the items. If you don’t want to reset then obviously skip this step.
Anyway the other suggested option will work too but this way you can do without an additional list but a little more complicated.
Hope it helps ;).