Power Platform Community Forum Thread Details

I want to automate task reminder and against each task completion date is mentioned and once task completion date is match with today's date then mail should trigger.

For the same purpose i have created a flow but date import from excel is in string format but i don't know how to correct it.

Categories:

Building flows

Hi @CU09040337-0

When you say Task, do you just mean the items in the Excel? Or do you mean from Planner or other Task Application?

Since you shared the Excel, I am assuming you want to compare to that Excel so that is Easy.

1. Create an Scheduled Flow, and have it run every day at whatever time you like

2. Use List Rows present in a Table

but you have to make sure to set the Date property to ISO like this

3. Add an Apply to each with the data as the value dynamic property of Excel step 2

Inside the Apply to each

--To make it clean I added 2 Compose Actions

--One to Format Today's date

--One to Format the Excels Date like this

--Then I added a Condition to check if they were equal

--and if so send the Email

Insert your file I renamed one column to s

Then inside my Compose Actions I did this

For Excel Formatting

formatDateTime(item()?['s'],'dd/MM/yyyy')

For utcNow() Formatting the expression is
formatDateTime(utcNow(),'dd/MM/yyyy')
 
Now if they match, it goes into the Yes side and you can send an email
 
Please, if this answers your question Mark it as such and maybe a like.
Thanks