Automating email sent out once a week to someone in 'spreadsheet a' that isn't in 'spreadsheet b'

[olliehill]

Hi there!

So i'm new to power automate so sorry in advance.

Basically I want to automate an email sent out once a week, to emails in 'Spreadsheet A' that do not appear in 'Spreadsheet B'.

For context. I have a mobile app. I have 2 Microsoft forms, both linked to two different spreadsheets. Form 1 is sent to users to fill out the form, to get the download link to the app. Then at the end of the app is Form 2. I want to send an email to the ones that have completed form 1 but haven't completed form 2. 

Both forms ask for email address.

Hope this makes sense!

Any help is appreciated, thanks in advance!

[PrasadAthalye]

I found following article very helpful for excel comparisons.. Please check if it is helpful in your scenario...

https://sharepains.com/2020/11/11/compare-2-excel-files-power-automate/