attempting Flow to send email after comparing two excel lists

[Fish01]

I am attempting to use flow to automate my process of sending a reminder to people of have not completed education.  I have two excel files.  The first is one is auto-populated through MS Forms as a person completes their education.  The second excel file contains all of the people who should be completing the education including their email address which is what I am trying to use.  I have attempted to build a flow that compares the list of emails from both lists.  If their email only shows up in the second excel file (Master List) then I want to send a reminder email.  However, I have run into several problems.  I have tried to use a filter array which kinda works.  The problem I am running into now is that at times there may be people who's email shows up in the first list, but not the second (Master List) which is okay.  However, I can't figure out how to exclude those differences.  I would appreciate any help anyone can offer.

[efialttes]

Hi!

Can you share a screenshot from your current flow design?

Thanx!

[efialttes]

Hi again

Let me see if I understood the problem

So you have list #1 stored in an Excel table, a new row is added everytime Forms response is received. It stores email addresses from people that completed education, right?

And you have list #2 (Master list) stored in a differernt Excel table, each row a stutent (and its email address) that started education, right?

And, current problem is, sometimes an email address is present in List #1 but not in list #2, right?

So your point is, you read emails from list B and iterate through them one by one (by means of 'Apply to each' right?), if their email only shows up in the second excel file (Master List) you send a reminder email.

I believe you probably doublecheck it by means of a 'Filter Array' inside your 'Apply to each', so if the result is empty, you send an email

I must be missing something... I mean I do not see where the problem is

Hope this makes sense

[Fish01]

Hello and thank you for your offer to help me solve this.  You are correct about list #1.  List #2 includes the names and emails of everyone who should complete the education.  My goal of this flow is to look at list #1 and if an email is not in list #1, but on list #2 then I want flow to send an email to that person.  Right now I think I broke my flow as it is sending repeated emails.  I have attached screenshots to show what I have.

[efialttes]

Hi again

Some thoughts

1.- you should be able to move both excel get rows action blocks before first 'Apply to each'

2.- you should be able to remove second 'apply to each' this way you will avoid sending to many emails. Please note sometimes flow editor is a bit stubborn

3.- the reason to add two 'Filter array' action blocks is to validate two different conditions, right? If so, i believe input for second 'Filter array'  should be output from first 'Filter array'

Hope this helps