Answered

Approval Request Filtering

(0) Share

Report

Posted on by LBelo

Hello,

I am building a flow for our IT department that tracks changes made to our network environment. I need one of the steps to be an approval request that is sent to everyone in the IT team except the person who originally entered the change control entry (in a SharePoint list).

Is there any way to create an expression or function that stores the team's individual email account and filters them to send the approval requests to anyone that doesn't match the original item creator's email?

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@LBelo ,

You can achieve this through the following steps:

1) Create an array of all users

2) Remove the user who created the request from the array

3) Convert the array into string using Join function

4) Provide the string in the "To" property of your Start and Wait for Approval action

Was this reply helpful? Yes No
LBelo 45 on at

Like (0)

Report
Copy link

Link copied!

I created the array with Initialize Variable. What function should I use to remove the email of the SharePoint item creator dynamically?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@LBelo ,

You can use the Filter function. Something like this

Was this reply helpful? Yes No
LBelo 45 on at

Like (0)

Report
Copy link

Link copied!

This isn't working for me.

The creator's email matches the first in the array, I've made sure of it. What should the item() expression be looking for when the array is just a list of emails?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It could be due to case mismatch. Add toLower() on both sides of the condition

Was this reply helpful? Yes No
Verified answer

LBelo 45 on at

Like (0)

Report
Copy link

Link copied!

Was not a case mismatch but I was able to solve the issue by doing the following:
Initialize variable with the User Email as the value.

Use the Variable as the filter.

For whatever reason, setting the dynamic data as a variable string solved the issue, even though it's using the exact same email address. Go figure.

Was this reply helpful? Yes No