09-25-2020 12:44 PM
09-25-2020 12:44 PM
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?
09-25-2020 02:42 PM
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.
09-25-2020 11:15 PM
09-28-2020 10:45 AM
@ArefHalmstrand What is the syntax for adding 1 to a number field in Power Automate?
09-28-2020 12:43 PM
@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....
09-28-2020 12:54 PM
09-28-2020 01:04 PM
@rbutgins21 I rebuilt the flow, but changed the status to status value and then had it send an email when it was true - that worked. Now, when I delete the email step and do an update item, it is telling me "could not find the list item"
09-28-2020 01:12 PM
09-28-2020 01:21 PM
@ArefHalmstrand The condition step seems to be working, but now it is failing when I'm trying to update the 2nd list that contains the count.
09-28-2020 02:07 PM
09-29-2020 06:57 AM
@ArefHalmstrandI guess I should ask the question - is it possible to have a trigger where an item is created or modified from one list and check the status on that list and if it meets the criteria - process an update item for another list. I'm basically trying to count the number of branches on the trigger list, that have been changed to verified, by updating the count on a separate list. The update step is where it is failing - it's telling me that the list item is not found.
09-29-2020 07:01 AM
@rbutgins21 That should really not be an issue, updating a second list based on a trigger on the first list is common. However the connection has to be configured. I will try to find time to create a similar solution to try it out and see if I can recreate the same error that you are receiving.
09-29-2020 07:05 AM
@ArefHalmstrand I'm thinking it has something to do with the *ID (unique identifier of item to be updated). I was just choosing ID, but I don't think that uniquely identifies the item in the list.
09-29-2020 07:28 AM
09-29-2020 08:15 AM
@ArefHalmstrandIt's the first and only item in the list, but I am still getting the following error...