Comparing date in an excel sheet with today's date

Like (0) Share

Report

Posted on 15 May 2024 12:42:56 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.

Skjermbilde 2024-...

All responses (2)

Answers (1)

andmik 4 on 16 May 2024 at 06:29:31

Like (0)

Report
Re: Comparing date in an excel sheet with today's date

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

v-qiaqi@microsoft.com on 16 May 2024 at 04:39:48

Like (0)

Report
Re: Comparing date in an excel sheet with today's date

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')