Unanswered

Power automate stop and wait for approval

(0) Share

Report

Posted on by AE-12082315-0

Hello,

I have a sharepoint list which I customized with PowerApps . I then added a lookup field to the sharepoint list and made the necessary steps to integrate the lookup field into PowerApps. The lookup column comes from a smaller sharepoint list call “section list” it only has two fields. Section name and approvers name. When I plug everything into the power automate flow the flow does not stops and wait for approval. The flow just runs and says it was successful. It’s supposed to stop in the “stop and wait for approval “ step and send an email to the appropriate “approver name” from the lookup up column section field. Please advise if you have any idea what is going on. Thank you.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Double check to see what the varApprovers variable is set to when the start and wait for an approval step uses it. Since you are using a Set Variable inside a loop you are overwriting the value every time it loops. So I suspect when you exit the loop it may be blank. If the approval isn't assigned to anyone because that variable is blank it will continue immediately. I suspect what you want inside the loop is an append to string variable action instead of a Set variable action.

Was this reply helpful? Yes No
AE-12082315-0 44 on at

Like (0)

Report

Hello @Pstork1
Thank you for your reply. I changed the variable to append string variable like you suggested. In the value it shows the correct email it’s supposed to go to. But it still does not send me the email to approve.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Is it just one approver? If not you need to put a semicolon after the email when you add it. Also, can you show me the configuration of your Start and wait for an approval?

Was this reply helpful? Yes No
AE-12082315-0 44 on at

Like (0)

Report

It’s just one approver per section. I have a look up column on my sharepoint list. It has 6 sections and one approver per section depending on the section the user picks from the drop-down. In my start and wait for approver “assigned to” field I have the Varapprovers I created from the variable.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

I would suggest adding a compose right in front of the start and wait for an approval step to see what is in varApprovers at that point. It should be a semicolon delimited list of email addresses. Is the approver name column an email address, a fullname, or a People column? The assigned to needs to be a string that is an internal email address.

Was this reply helpful? Yes No
AE-12082315-0 44 on at

Like (0)

Report

Thank you for your reply. So I think the issue might have to do with the look up column. Because it shows as empty in my filter query ! In the filter query I had my “sections” column which is the option the user picks from the list drop down . According to the section they pick it should go to a specific approved and that’s why I used the variable for to get the approver emails.

Was this reply helpful? Yes No