Answered

Getting users from a list filtered by Region and use those people in an approval

(0) Share

Report

Posted on by Community Power Pla...

Hello,
Currently I have an approval workflow that gets approvers from a list.
The filter query uses Region as the key field and based on what I am seeing I am getting the users from NA as expected.

Here is the input and output.

The filter query pulls two people but for some reason it is only sending an approval to one approver and that person is getting TWO approvals. One approval happens and he approves it, expecting that the other person from the region would get an approval but the first approver gets a second approval again.

Any help here would be appreciated.

All responses (3)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Getting users from a list filtered by Region and use those people in an approval

I believe I found the issue.
There are two NA Approvers.
Not sure why or how a loop happened.
Community Power Pla... on at

Like (0)

Report

Re: Getting users from a list filtered by Region and use those people in an approval

This worked but I am getting duplicate approvals

Teams "Activity" sent me the first approval and once I approved it I received a Teams notification "Final Status - Completed" then right after that I received another Teams notification for approval.

The system sent an approval to both approvers as expected.
And I approved it as shown below.

I then received this notification.
Am I missing something in my configuration?
Thank you for your help!
Verified answer

v-litu-msft on at

Like (1)

Report
Re: Getting users from a list filtered by Region and use those people in an approval

Hi @Anonymous,

You should initialize an array variable, not a string variable, then use Append to array variable action to add accumulate these approver emails.

Then use join() function to convert the array variable to a string separated by ";", to make it could be used in the Approval action:

join(variables('Approvers'),';')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.