Unanswered

Date format change from SharePoint List to Power Apps

(0) Share

Report

Posted on by CU14101822-0

I have a SP list with multiple columns. One of the columns is date type. I have a Power Apps with a dropdown field that retrieves and views the data type column from the SP list, but the date format comes back in a very different format. For example, 29/10/2024 would return 165524400000 . I can't find a way to mitigate this. Does any one have a solution?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Srini007 3,463 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can write as below

Text(DateValue(YourSharepointDateColumn), "[$-en-US]dd/mm/yyyy")

If I have answered your question, please mark it as the Answered. If you like my response, please give it a Like.

Regards,
Srini

Was this reply helpful? Yes No
WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi CU14101822-0

This will display all the dates in Text
ShowColumns( AddColumns( Sort( SPList, YourDateField, SortOrder.Descending ), DateTxt, Text( YourDateField, "dd/mm/yyyy" ) ), DateTxt )

Just be aware that writing it back as a Date will have some complexities (caused mainly by dd/mm/yyyy instead of the USA standard mm/dd/yyyy ) - the Data Card Update

With( { _Data: Split( YourComboBoxName.Selected.DateTxt, "/" ) }, Date( Last(_Data).Value, Index( _Data, 2 ).Value, First(_Data).Value ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No