Answered

Automatic email when due date is 7 days away in sharepoint list

(0) Share

Report

Posted on by CU-19081616-4

Hi,

I can't figure out how to set power automate up to send an automatic email to people listed in the sharepoint when their task due date is 7 days away. The image shows how I have currently set it up, the compose is used in the get items. This method doesn't work due to the text in compose being invalid, not sure how it should be done.

Thanks in advance

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Tom898

You are missing the closing ) in the compose.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
CU-19081616-4 on at

Like (0)

Report
Copy link

Link copied!

@SpongYe That doesn't seem to be the problem

Was this reply helpful? Yes No
Verified answer

EllenH22 23 on at

Like (1)

Report
Copy link

Link copied!

Hi @Tom898 ,
have a look at this video: https://www.youtube.com/watch?v=yfPLhCjkHek
It helped me to set up a working flow 🙂
Kind regards,
Ellen

Was this reply helpful? Yes No
CU-19081616-4 on at

Like (0)

Report
Copy link

Link copied!

Thank you that is a good video actually however it doesn't work for my list because the 'Due Date' is a calculated column, which for some reason isn't supported for that method through the reminders despite it being formatted as a date.

Was this reply helpful? Yes No
CU-19081616-4 on at

Like (1)

Report
Copy link

Link copied!

I ended up using this video which was actually really well explained, I just had to add my own extra flow to fill in a new date column from the calculated column. And then I used that new date column to set up the email reminder.

Was this reply helpful? Yes No