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
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.