Power Platform Community Forum Thread Details

I have a process in power automate where it send an email to 1st level leader , 2nd level leader and 3rd level leader (based off fields in sharepoint that are TEXT fields with the email addresses). I have 4 leaders where if they are listed , I'd still like the email to send but just not to them. (essentially send to everyone else but not them)

I have a get items called Get items TM Feedback
Inside an apply to each loop
Get item
Send an email

How can I get the 4 names in the array excluded - here is a visual of the flow

Categories:

Building flows

Hi @joel914823

Since I cannot see your list, I have to make this part up a little.

1. I am assuming you have a field that has the emails, but another field that tells you what they are? Level 1 2 3 4 whatever?

If that is the case you can write an odata filter to essentially say

ColumnName ne 'Leader1Value' and ColumnName ne 'Leader2Value' and ColumnName ne 'Leader3Value' and ColumnName ne 'Leader4Value'

Now it won't pull back any emails where your Identifier (not the email address) that tells you what they are (persona wise) is any of those 4 values.

Now if you are saying you ONLY know them by email address, that is not a great way, but then you would make the ColumnName the email and you would do ne 'emailaddressfield' and you may want to wrap it into toLower(emailaddressfield) depending on how you store the email address, all caps, mixed etc.

Or you can use a Filter Array and essentially you would write the same stuff above but in a different format in advanced mode in the FilterArray, which is actually more a pain imho then filtering them at the Get Items level.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey