You’re offline. This is a read only version of the page.
40
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.
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.
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.
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.
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.
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.
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
