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.

Table of Contents:

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

Check IF Date is Today Using Power Automate

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.

How to Check IF Date is Today Using Power Automate

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.