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 "verified". I want to build a flow that will check the status of all items in the list and send an email when they are all in the "verified" status. As of now, it sends an email when each status is changed to verified, but only want 1 email for all. Any ideas out there?
Thanks
- 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 ;). rbutgins21
My understanding of your desired solution:
Each branch has their own item in a list (bank branch list) and every morning, the status is supposed to be "unverified". So that when they are finished, they update their status to verified. When every status is verified, an notification should be sent to inform that everyone is finished. When that has happen, the status of every item should go back to be unverified (to be set for the next day).
Suggestion for solution:
Have two lists, one for the bank branch, and another one for Power Automate counter (one object in the list with number column). Whenever an item is updated in the bank branch and the field has gone from unverified to verified, update the other object in the Power Automate counter list with +1.
When the number reaches the same amount as all of the branches, then trigger an notification. After the notification has occured, either have a button triggered reset for the verified/unverified status, or make it automatic.
I hope this makes sence, if anything is unclear, please tell and I will try to explain further.- Try this: add(triggerBody()?['number'],1)
