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 ...
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)
ArefHalmstrand Having issues with my condition statement - can't get it to be true - the status has been changed to verified, but that step keeps failing. I am missing something simple as this is not a complicated flow....
