Answered

Correct Date Format For Flow

(0) Share

Report

Posted on by szebo

Hi. I am using simple Flow to look at a spreadsheet daily and send emails if the date column in the spreadsheet matches the current date. However, the Flow is failing at the date compare stage and I think it is because I am not formatting the date in the Excel spreadsheet correctly. I've tried several different date format in Excel but the Flow always fails. Is there a specific format that must be used for Flow to compare dates from an Excel spreadsheet?

Steve

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

MJain 2,450 on at

Like (0)

Report

Hi @szebo ,

The dates when pulled in flow are treated as numbers or decimal if you have datetime in excel.

Use the following expression to convert it into date string

addDays('1899-12-30',int(['Date']))

Thanks

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report
Hi @szebo ,

You should refer to screenshot below to create the flow:

The expression for the Current date:

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

The expression for the date in excel:

formatDateTime(addDays('1900-01-01',add(int(items('Apply_to_each')?['Date']),-2)),'yyyy-MM-dd')

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @szebo

I have a post on how you can better work with date time data from Excel : https://www.bythedevs.com/post/working-with-date-time-data-of-excel-in-power-automate

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No