Unanswered

Power Automate - Sending an email reminder about a task being due the day before the due date (SP list column) to assignees

(0) Share

Report

Posted on by kat7777777

106

Hi, I have built a tracker app in PowerApps. The backend is a SP list. I have created a workflow to send an email to those who are assigned the task letting them know they have a new task they need to do. I also want to build a workflow to send an email to the assignees the day before the due date of the task as a final reminder. What steps do I need to place in my flow to compare the due date to the day before?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @kat7777777 , You can create schedule flow on your SharePoint list . The flow will run on daily basis once in morning as per your time zone.
It will get all items in your SP list and then use condition action within apply to each loop.
Your condition will validate the difference between Today and DueDate is 1 day, if current record satisfy the condition, then you can send email reminder.

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
The standard strategy is as follows:
Create a scheduled flow that runs once per day.
The flow should query the list and find all items that meet the date criteria (the date field is one day greater than the current date)
The flow should loop through the results, sending emails for each item.
The trick here is dates, as Power Automate and SharePoint each handle dates differently. Luckily, @ScottShearer has a nice writeup for sending these sorts of reminders here.

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
Hi @kat7777777 , I tried one repro for you to avoid any expression in Power Automate Flow, for that please check below steps:
In your SP list create 2 columns:
First column will be of name TodayDate of type Date and time which will store your today's date. Make sure to create as shown in below screenshot:

Then create another column in your SP list of name DateDiff of type calculated column as shown screenshot, the formula would be like =DATEDIF(TodayDate,DueDate,"D")

Then when a new item is created in your SP list, the SP list will look like below which is nothing but will give the date diff.

Now you just need to create a flow for all those item where the DateDiff is 1, which is nothing but the one day prior to DueDate.
Flow will be schedule flow which will run daily in morning 6 AM as shown in below screenshot, you need to select your time zone when this need to start:

Then 2nd action will be like below:

Then 3rd action will be apply to each as shown below:

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB

Was this reply helpful? Yes No
kat7777777 106 on at

Like (0)

Report

Hi, thank you for your help. I did receive an error though on Step #4. It says the formula contains a syntax error or is not supported. Any tips?

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

HI @kat7777777 , I hope you are not using the same code that I have used? You need to use your columns names in the code.
TodayDate: Is column in my list which hold todays date and
DueDate: Is column in my list which hold due date.
Can you confirm on the same please?
If you can send me the screenshot of formula and the screenshot of column names?
------------------------------------------------------------------------------------------------------------------------------
I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB

Was this reply helpful? Yes No
kat7777777 106 on at

Like (0)

Report

I had a space in my original "Due Date" column name. When I input that into the code it gave me an error. I just recreated the due date column but named it "DueDate" instead and that worked it seems. I will finish out the steps and let you know if it works. Thank you again for your help!

Was this reply helpful? Yes No
kat7777777 106 on at

Like (0)

Report

Good morning,
I received this error when I tested out my flow. "The field 'DateDiff' of type 'Calculated' cannot be used in the query filter expression." Do you have any recommendations on how to fix?

Was this reply helpful? Yes No