I am new to Flow/Power Automate and I am getting stuck on an approval flow but I have a feeling the solution is relatively simple.
I have created a list in SharePoint that I attach a document to. Then I want to send this for approval (All must approve). I capture all of the responses in a column in my list. When all responses have been submitted my approval column looks like "Approve, Approve, Approve, Approve". At this point I want my flow to send an email to someone stating "Approval Complete" and then start another "Final Approval".
I have the flow working great when it is a single Approve in the column (I have been testing it by only sending it to myself so the condition that I used was "When column X = Approve" if Yes send "Successful" email if No send "Failure" email. When I then add the full condition "Approve, Approve, Approve, Approve" I keep getting "Failure" emails until all 4 approvers have responded at which point I get a "Successful" email.
Does anyone know a way that I can get the send email part of the flow to only run when ALL 4 responses have been given?
Hope that makes sense.
Can you share a screenshot from your flow design?
Also, confirm the column type on your sharepoint list you store the partial approvals... is it single line of text?
The more context info you can provide us, the fastest we all can suggest a solution
if you need to share a screenshot from Power User editor, make sure you are writing from a desktop browser client (I believe mobile browsers does not display this menu) and do the following:
Hope this helps
I think its the condition section that is causing me the issue. For reference I changed the Approval type to "Custom-wait for all responses". This seems to work better but now I am getting a rejection email from all of the respondents when one of them rejects the document
I would suggest to change your condition approach.
So instead of checking if equals to 'Approve', I would check that does not contain 'Reject'.
But please also note on your current flow design 'Send an email' is in both Condition branches inside an Apply to each, meaning if you have 4 approvers, you most likely will receive 4 emails... so my suggestion is also to move Condition after, outside the Apply to Each. Does it make sense to you?
Hope this helps
Hi @SJACooler ,
Please check this similar thread to configure the condition to determine the approval result:
Besides, you need to configure Condition outside Apply to each to check the final outcome the approval request.
And it seems that you don't need to add Apply to each, please avoid using Dynamic content prefixed with Responses if unnecessary.
Hi Sorry its taken me the weekend to come back to you on this.
I am trying to make the condition outside of the apply to each but in the email that is sent I need to capture the comments that have been made by the user rejecting the document. Each time I apply this dynamic content the system automatically places it inside an apply to each...
Any ideas please?
Hi @SJACooler ,
You could use variable to record comments and send by email.
Hope this helps.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.