Issue in Date format imported from Excel

(0) Share

Report

Posted on by Nanig

The excel contains a table with email id and alert date. Based on this data, a mail has to be sent to the person.

-Outlook has to pick email id from the excel table

-And the trigger for sending the email should be based on alert date.. i,e if alert date is Today s date then a mail has to be sent. I have created the attached flow. The Alert date in excel format is being reflected as number. So Flow is not being executed in right manner.

How to change the format of date which is linked with excel?

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Nanig 23 on at

Like (0)

Report
Copy link

Link copied!

@RobElliott Thanks a lot for the solution, I had been trying that since long time.

Was this reply helpful? Yes No
Verified answer

RobElliott 10,383 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

@Nanig Excel formats dates as an integer so to use them in your flow you need to convert that integer to a date. You can do this with a Compose action and add the following expression (where CCheck is the column in my spreadsheet with the date, so change it to your column):

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

You then select from the dynamic content the output of the Compose action.

If you are doing a comparison of the output against today's date then always make sure you use yyyy-MM-dd.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No