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.
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
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.
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
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.