cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Date format converting to numbers

I have date column in excel like this:

abhishekmundra_0-1600425259618.png

I'm sending same table to outlook email but date column data is changing to 44096. Please assist

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Re: Date format converting to numbers

@abhishekmundra 

 

Hey Mate,

 

Can you try using the formatdatetime() function.

 

formatDateTime('9/22','dd-MM-yyyy')

 

CFernandes_0-1600426036147.png

 

You can find more details at https://sharepains.com/2018/11/12/formatdatetime-flow-power-automate/

 

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!

 

View solution in original post

3 REPLIES 3
Highlighted
Resident Rockstar
Resident Rockstar

Re: Date format converting to numbers

@abhishekmundra 

 

Hey Mate,

 

Can you try using the formatdatetime() function.

 

formatDateTime('9/22','dd-MM-yyyy')

 

CFernandes_0-1600426036147.png

 

You can find more details at https://sharepains.com/2018/11/12/formatdatetime-flow-power-automate/

 

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!

 

View solution in original post

Highlighted
Dual Super User III
Dual Super User III

Re: Date format converting to numbers

Hi!

44096? The number you got is due to the fact the Excel column is formatted as Date, right?

It represents nr of days since 1899-12-30; it's the internal format used by Excel.

 

So either you switch the Excel column format into text, and apply @CFernandes suggestion or, keep it as date format, and once in your Flow, transform into ISO 8601 date format, wich is the internal one handled by Power Automate. Wanna keep the date format? Then you can use the following WDL expression:

 

 

 

addDays('1899–12–30T00:00:00Z',int(item()?['TestingDate']))

 

 

 

Just replace item()?['TestingDate'] and use instead the dynamic content element representing your Date column.

 

Please note addDays() offers optionally the possibility to customize ISO 8601, in a similar way as formatDateTime() does. I haven't customized the output in my example.

 

For more info, please have a look to this excellent article:

https://www.bythedevs.com/post/working-with-date-time-data-of-excel-in-power-automate

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Dual Super User III
Dual Super User III

Re: Date format converting to numbers

@abhishekmundra 

So, you finally transformed your Excel date column format from date to text, right?

Good Job and... happy flowing!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Users online (6,068)