cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fish01
New Member

attempting Flow to send email after comparing two excel lists

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.

 

 

4 REPLIES 4
efialttes
Super User III
Super User III

Hi!

Can you share a screenshot from your current flow design?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



efialttes
Super User III
Super User III

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



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.

 

Screen Shot 2020-09-16 at 1.41.26 PM.jpgScreen Shot 2020-09-16 at 1.42.08 PM.jpg

 

 

 

 

 

 

 

 

 

 

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

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (3,162)