topic Re: Power Automate Flow to Send Emails Based on Condition from SharePoint List in Developer

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

codinenthusiast — Wed, 19 Feb 2025 20:08:46 GMT

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!

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

lbendlin — Thu, 20 Feb 2025 00:33:06 GMT

Please ask here Microsoft Power Platform Community Forum Thread

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

Anonymous — Thu, 20 Feb 2025 06:39:06 GMT

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.

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

christinepayton — Tue, 25 Feb 2025 19:51:14 GMT

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.