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,327 Super User 2025 Season 2 on at

Like (0)

Report

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 153,012 Most Valuable Professional on at

Like (0)

Report
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