Convert entire table to upper/ lower case OR filter array & excel list excluding character casing

[fabiofa]

Hello All,

I am having some trouble filtering two lists.

My flow is supposed to do the following:

1- Fetch a list of members from Outlook group

2- Fetch a list of users from an excel table

3- Convert the Outlook members lost into an array of e-mails and lower case all entries

4- Filter and compare the excel list with the array of Outlook group e-mails

5- Add to an Outlook group the list of users from Excel who are not present in the outlook group previously fetched in step 1 

The step I get stuck at is #4 I'm unable to properly filter the list

Example Input

Outlook Group Members	Excel List
john@microsoft.com	billy@Microsoft.com
billy@microsoft.com	JOHN@microsoft.com
sarah@microsoft.com	laura@microsoft.com
bob@microsoft.com	sarah@microsoft.com

The Outlook group list is all lower case and in an array.

The Excel list has mixed casing.

After filtering the two lists I should be left with: 

laura@microsoft.com   

because that entry does not match anything in the outlook group list

This is the filter I am using 

Outputs are the following:

What is contained in the lowercase array of group members

the input and output after performing the filter 

 Since the e-mail is upper case the filter is not working properly, john@microsoft.com  is already present

Please let me know if I am doing the filtering wrong or how would I go about converting an entire excel table into lower case so I don't have to perform lowercase filtering in advance.

[DamoBird365 · Accepted solution]

Hi @fabiofa 

Try this...

No need for an apply to each, make sure you swith the Select to Text Mode.  This gives you an array of emails in lower case to compare with the emails of the Excel Table.

I have an excel table

You can see my input and output here:

With only John Present.

Your other option is to create an array of lower case emails from teh value of excel using a select.

You then end up with the following:

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks