Power Automate Flow to Send Emails Based on Condition from SharePoint List

[codinenthusiast]

Hi,

I am trying to create a Power Automate flow to automate email notifications based on certain conditions in a SharePoint list. The goal is to send emails to specific senders if a file has not been uploaded and a planned handover date is approaching within two weeks.

Here is my SharePoint list structure:

Project Train Uploaded     Sender               PlannedHandover

a	1	2/3/2025	a.b@abc.com
a	1		n.v@abc.com
a	1		s.b@abc.com
a	1			3/3/2025
b	22		jeff.p@gmail.com
b	22		a.s@gmail.com
b	22	4/5/2025	m.e@gmail.com
b	22			2/3/2025
c	32		a.b@gmail.com
c	32		jeff.p@gmail.com
c	32		n.v@abc.com
c	32			5/3/2025

• I need to send email notifications to the "Sender(s)" if the "Uploaded" field is empty and the "PlannedHandover" date is approaching within two weeks.
• The Planned Handover date applies to the rows above until a new date is encountered. For example, the 3/3/2025 date in row 4 applies to rows 1 to 3, and the next "PlannedHandover" date (in row 😎 applies to rows 5 to 7, and so on.
  
  
  Here is my flow screenshots.
  
  

Any help would be appreciated. Thanks!

[christinepayton]

Reza has a good video on a similar topic here:

https://www.youtube.com/watch?v=v54QozIEGyw

It's sending email reminders based on a date field to people in a person column in the list. You could probably adapt that to your situation by doing a riff on this. 

[Anonymous · Accepted solution]

Thanks for the reply from lbendlin , please allow me to add some more information:
Hi  @codinenthusiast ,

Thank you for providing a detailed description of your issue and the screenshots. You should write the conditions in the OData filter of SharePoint GetItems, instead of using several conditions for further for each judgment, and then appending to an array to generate the email list for sending emails

You can specifically refer to this blog:

www.spguides.com

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please ask here Microsoft Power Platform Community Forum Thread