Comparing date in an excel sheet with today's date

(0) Share

Report

Posted on by andmik

Hi,

I have an Excel sheet with names in one column, emails in another and a date column with format "dd-MM-yyyy" (for instance 19.05.2024 for May 19th 2024). I am setting up a flow to loop through the date column and if the date is equal to today's date, then the flow should tag the person in a channel post in Teams with the email column.

Everything is working well except for the part comparing the dates. I look at the raw output in Power Automate and I do not get any matches with today's date because the format of the date in the Excel sheet is read as "45341" for instance. I have tried to do the comparison by writing formatDateTime("DateColumn",'dd.MM.yyyy') is equal to formatDateTime(utcNow(),'dd.MM.yyyy') but that does not work either. The flow just runs without any matches.

Any ideas? I have tried to format the column in the Excel sheet in different ways, short date, text, number, but it does not work.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @andmik,

Here are two tips for your reference:

1). You need to configure the List rows present into a table action as below:

2). Configure the condition as below:

formatDateTime(utcNow(),'yyyy-MM-dd')

Was this reply helpful? Yes No
andmik 4 on at

Like (0)

Report
Copy link

Link copied!
Thanks! I had to add
formatDateTime([DateField],'yyyy-MM-dd')
as well in the condition step. It works now!

Was this reply helpful? Yes No