Send daily reminders to the team to complete a task in SharePoint

(0) Share

Report

Posted on by SShoyombo

Hello,

I have a requirement to send a daily reminder to my team to complete a task.

The "daily" email flow starts when a new item is created or modified in a list

until a "completed date" column is filled which signifies the date the task was done.

The flow should send emails every day till the "completed date" is entered in the list.

Regards,

SAS

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Michael E. Gernaey 53,362 Super User 2025 Season 2 on at

Like (0)

Report

Hello

I would not do it like that.
1. I would use a Reoccurring Flow
2. Have the flow do a Get Items (action)(on your SharePoint list of tasks, again I am assuming its SP)
3. For each task that is not marked Complete, then use Send Mail v2 action

Done

There are more things, like grouping the emails etc, but you just asked about how. If you do this and thats all you need, its a few actions.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
SShoyombo 24 on at

Like (0)

Report

Hello FLMike,

Thanks for your response:

Please see my flow snapshot:

This is the sequence I have there and want to achieve:

1. Create a recurrence flow (daily)
2. When a SharePoint List is Created or Modified
3. Get Items (no filter Query)
4. Filter Array when Today's date: formatDateTime(utcnow(),'yyyy-MM-dd') is greater than or equal to a "Certain Date" in the list (dynamic date).
5. Send an Email to me and continue to send until "Completed Task Date" is not empty

When I test it, modifying or creating new item, the flow keeps running on the 2nd step until it times out and no email is sent.

What am I doing wrong please?

Regards,

SAS

Was this reply helpful? Yes No
Michael E. Gernaey 53,362 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

If you look, at the instructions I gave
1. I would use a Reoccurring Flow
2. Have the flow do a Get Items (action)(on your SharePoint list of tasks, again I am assuming its SP)
3. For each task that is not marked Complete, then use Send Mail v2 action

But what you added was this
1. I would use a Reoccurring Flow
1.5 You added a Trigger (which is now blocking and it wont complete because its not the correct way to do this).
2. Have the flow do a Get Items (action)(on your SharePoint list of tasks, again I am assuming its SP)
3. For each task that is not marked Complete, then use Send Mail v2 action

You need to remove that trigger. Why would you schedule a flow to run and then also, block the flow with a second trigger? What are you trying to achieve by adding that in?

You said you needed to send an email 1 time a day for any non-completed tasks. So, I suggested that you then Check the status of all of them 1 time a day via the steps I gave.

Please remove the trigger (When an item is created or modified). This is the reason its stuck.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
SShoyombo 24 on at

Like (0)

Report

Hi FLMike,
I have removed the "When an Item is created". It works but it is sending email for all the items that are already in the list. I want to restrict the emails to items that are newly created or modified from today onwards.

Regards,

Samson

Was this reply helpful? Yes No
Michael E. Gernaey 53,362 Super User 2025 Season 2 on at

Like (0)

Report

You didn't mention anything like that before. If you can mark my answer as Resolved as it is, then we can focus on this new thing.

Then you need to add a 3rd condition and what is the TimZone?

You would have to add a check on
createdDate(or whatever your column is) is great than or equal to utcNow() of course formatting them both to be like dd-MM-yyyy so they have then same format..

of you can do a

dateDifference(MyDateValue,utcNow()) (again format them properly) is greater or equal to 0

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No