Check IF Date is Today Using Power Automate

Have you ever needed to remind someone about a task deadline or clean up old files without doing it manually? With Power Automate, you can easily automate these tasks.

In this tutorial, we will explore how to use dates in Power Automate to automate reminders and file management. Whether you need to check if a task is due today, flag tasks without deadlines, or archive old files, Power Automate can handle it efficiently.

Check IF Date is Today Using Power Automate

Suppose you have a SharePoint list named Task Tracker, where each task has a Due Date column. You want Power Automate to check if the Due Date is today, and if it is, send an email reminder to the assigned person.

Now, to do this, follow the below steps:

1. Navigate to the Power Automate Home page, click + Create, and select the Scheduled Cloud Flow. Then provide the following information:

• Starting: Provide the date you want to run your flow.
• at: Provide the time you want to run the flow, in my case, at 9:00 AM.
• Repeat every: We want to run the flow daily.

2. Then, I use the Get Items action to get the due date from the SharePoint list and provide the below parameters:

• Site Address: Select the site address where the task tracker list is present.
• List Name: Select the task tracker list from the drop-down.

3. Use a Filter array action to check if the Due Date is today. I used the below parameters in the Filter array:

• From:

@{outputs('Get_items')?['body/value']}

• Filter Query:

@{formatDateTime(item()?['DueDate'],'dd-MM-yyyy')} is equal to @{formatDateTime(utcNow(),'dd-MM-yyyy')}

4. Add a Send an email (V2) action. In the To field, enter the email address of the assigned person for the task.

• Subject: Reminder: Your Task Is Due Today!
• Body:

Dear @{item()?['AssignedTo/Email']},

This is a friendly reminder that your task @{item()?['TaskName']} is due today (@{formatDateTime(utcNow(),'dd-MM-yyyy')}). Please ensure it is completed on time.

Task Details:
Task Name: @{item()?['TaskName']}
Due Date: @{formatDateTime(utcNow(),'dd-MM-yyyy')}
Assigned To: @{item()?['AssignedTo/DisplayName']}

If you have any questions or need an extension, please contact your manager.

Best Regards,
Tsinfo Technologies

Click on Save in Power Automate after setting up all the actions. Click Test → Select Manually → Click Run Flow. The flow will fetch tasks from the Task Tracker list and filter those where the Due Date is today. If there are any tasks due today, the assigned person will receive the below email notification.

Check if the Date is Blank using Power Automate

For this example, I am using the same SharePoint list, but I want to send a reminder email if the Due Date is blank, ensuring tasks without deadlines are flagged for review.

To do this, follow the below steps:

1. Create an automated cloud flow. Give the flow a name and select the trigger When an item is created or modified. Also, provide the Site Address and List Name.

2. Then add a Condition action like below:

empty(triggerBody()?['DueDate']) is equal to true

3. Add a Send an email (V2) to notify the assigned person, prompting them to update the task with a due date. Then provide the below parameters:

• To: @{triggerBody()?[‘AssignedTo/Email’]}
• Subject: Action Required – Task Missing a Due Date
• Body:

Dear @{triggerBody()?['AssignedTo/DisplayName']},

We noticed that the task @{triggerBody()?['TaskName']} in the Task Tracker does not have a due date. To ensure proper tracking and timely completion, please update the task with an appropriate due date at your earliest convenience.

Click on Save in Power Automate after setting up all the actions. Click Test → Select Manually → Click Run Flow. Then, go to the SharePoint list, add an item, and do not add the due date.

After the flow runs successfully the assigned person will receive an email like the one below:

Check If the Date is Less than Today Using Power Automate

Imagine you are managing a OneDrive folder called “Documents” where employees upload files for review. You want to create a weekly Power Automate flow to check each file’s “Modified” date. If a file hasn’t been modified in over 30 days (its modified date is less than today minus 30 days), it must be moved to the “Archive” folder to keep the main folder updated.

To do this, follow the below steps:

1. Go to Power Automate and sign in with your Microsoft account. Select Scheduled cloud flow to set up a flow that runs on a schedule. Then provide the following information:

• Starting: Provide the date you want to run your flow.
• at: Set the Starting date and time (e.g., today at 9:00 AM).
• Repeat every: Choose 1 Week to run the flow weekly.
• On these days: Select the Friday.

2. Search for and select the List files in folder action from the OneDrive for Business connector. In the Folder field, click the folder icon and navigate to the “Documents” folder in your OneDrive.

3. Search for and select the Filter array action (this is a built-in action, not tied to a specific connector). In the From field, insert the value output from the “List files in folder” step (this contains the list of files).

Set up the condition to filter files modified more than 30 days ago:

• Left side: Select LastModified from the dynamic content (this is the file’s modified date).
• Operator: Choose is less than.
• Right side: Enter the expression addDays(utcNow(), -30) (this calculates today minus 30 days).

4. Search for and select the Move or rename a file using path action from the OneDrive for Business connector. Then provide the below parameters:

• File: Select the Path from the Filter array output.
• Destination Folder: Click the folder icon and navigate to the Archive folder in your OneDrive.

It will automatically add a for each loop.

Click Save at the top. Click Test in the top-right corner. Choose Manually and click Test. After the flow runs successfully, check the Archive folders to ensure files older than 30 days are moved correctly.

Conclusion

In this tutorial, we covered three Power Automate scenarios for handling dates. First, we checked if a task’s Due Date in a SharePoint list matched today’s date and sent an email reminder to the assigned person.

Next, we identified tasks with a blank Due Date and sent a notification prompting an update. Lastly, we automated the archiving of OneDrive files by checking if their modified date was older than 30 days.

You may also like:

• Check IF Attachment Exists Using Power Automate
• Power Automate Check If Field Is Blank
• Check If the Filename Contains in Power Automate
• Check IF SharePoint List is Empty in Power Automate
• Check if SharePoint List Already Exists in Power Automate