web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Excel Connector dates ...

Power Automate

Unanswered

Excel Connector dates extract issue (Change from integer to dates?)

(0) Share

Report

Report

Posted on by Sam4

229

Hi I am experiencing something weird reading dates from Excel. For the last months I've been reading dates from excel as strings with integer so, given the following table

I get something like this

I then apply a formula like this formatDateTime(addDays('1899-12-30',int(DATE)),'dd/MM/yy') to get it as a Date type.

However, I've started to receive today this info as follow

Therefore the formula above is not working and impacting most of our flows.

Hopefully I'm doing something wrong instead of a change on how the Excel Connector is providing the info (it would have a massive impact!).

Can anyone point me in the right direction?

Many thanks

S

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!
try formatting the date as below :

formatDateTime(outputs('Get_item')?['body/Created'],'yyyy-MM-dd')

Was this reply helpful? Yes No

Join the conversation