Hi,
You can achieve this by comparing the date column from SharePoint with the current system date inside your scheduled flow. Sometimes the comparison does not work as expected because SharePoint stores dates in ISO format, while the value you see in the list is displayed according to the regional settings.
One approach you could try is:
Flow pattern
-
Trigger
Use the Recurrence trigger to run the flow once per day.
-
Get items (SharePoint)
Retrieve the records from your SharePoint list.
-
Condition / Filter
Compare the SharePoint date column with today's date using the utcNow() function.
For example, you could use an expression like:
formatDateTime(items('Apply_to_each')?['YourDateColumn'],'yyyy-MM-dd')
and compare it with:
formatDateTime(utcNow(),'yyyy-MM-dd')
This ensures both values are in the same format before comparing them.
-
Check if the value is empty
You can also add a condition to check whether the required field for that employee is empty or null.
Example expression:
empty(items('Apply_to_each')?['YourColumnName'])
-
Send email notification
If the date matches today and the column value is empty, use Send an email (V2) to notify the employee.
Example logic
If DateColumn = Today
AND DataColumn is empty
→ Send email notification.
Normalizing the date format using formatDateTime() often resolves issues where date comparisons appear not to work correctly.
Hope this helps. If this resolves your issue, please consider marking the response as Verified so it may help others facing a similar scenario.
