Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
Any help would be appreciated. Thanks!
Solved! Go to 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:
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.
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.
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:
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
3 |