Hi Alice,
I have tried your solution however, it doesn't update the field after every approval, only after all approvals are completed
My requirements are as follows:
1. A user adds one or multiple people to a sharepoint field to request approval from. They also add a deadline for this approval
2. A user starts the flow on a selected document through sharepoint
3. The approval is sent and all users from the sharepoint field are added to a new field called 'not approved'
4. When an approval is completed, the users name should be removed from the 'not approved' field so that the initial user can see who still needs to approve the document.
5. If the approval deadline passes, the people who have not replied to the approval, are sent an email.
I have attempted to fulfill these requirements by doing the following:
1. Creating a string variable called 'new list of not approved'. This variable would be updated everytime an approval is completed and would be used to update the 'not approved' field in sharepoint
2. The above would be done by using a replace() expression to remove names from the string variable based on who has completed the approval.
3. A variable 'number of approvals' that counts the number of approvals and decrements each time one is approved. Put simply, it is a counter for the 'Do until' loop.
As you can see the main problem is trying to update the sharepoint field whilst the approval is running. I have tried using parallel branches to solve this but the branch is unable to pick up responses to the approval.
Here are screenshots of my flow:
Checking the deadline and sending an email if it has passed
Do until loop that updates the sharepoint list
Initialising all the variables and appending some to string variables
Thank you for your help! Let me know if you have any more questions
