Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
codinenthusiast
Regular Visitor

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

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

a12/3/2025a.b@abc.com 
a1 n.v@abc.com 
a1 s.b@abc.com 
a1  3/3/2025
b22 jeff.p@gmail.com 
b22 a.s@gmail.com 
b224/5/2025m.e@gmail.com 
b22  2/3/2025
c32 a.b@gmail.com 
c32 jeff.p@gmail.com 
c32 n.v@abc.com 
c32  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.

    codinenthusiast_0-1739995540080.pngcodinenthusiast_1-1739995583384.pngcodinenthusiast_2-1739995610774.png

     



Any help would be appreciated. Thanks!


1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

vyangliumsft_0-1740033514502.jpeg

 

vyangliumsft_1-1740033514505.jpeg

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.

View solution in original post

3 REPLIES 3
christinepayton
Super User
Super User

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
Not applicable

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

vyangliumsft_0-1740033514502.jpeg

 

vyangliumsft_1-1740033514505.jpeg

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
Super User
Super User

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.