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.
