web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Date Format for datepi...

Power Apps

Answered

Date Format for datepicker getting changed

(0) Share

Report

Report

Posted on by Kumar902402

18

Hi All,

I have a Powerapps Newform where I have date picker. I have updated the format of date picker to "dd/mm/yyyy". Even SharePoint site I have updated the format to "dd/mm/yyyy". When I save the record from powerapp to SharePoint, date is getting saved in correct format.

However, when I use Gallery label to show the datepicker, format again gets changed to "mm/dd/yyyy" format. Any advice would be much appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Kumar902402 ,

All dates are actually stored in UTC format, but displayed according to your formatting and settings. In the gallery, display it as

Text(YourDateFieldName,"dd/mm/yyyy")

Please click Accept as solution 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 Thumbs Up.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@Kumar902402,
Based on the issue that you mentioned, do you want to format the date as "dd/mm/yyyy"?
Could you please share a bit more about the scenario:
Is this related date column a DateTime type in the SP list?
How you format the Date in your Label?
I assume that it is a DateTime column in your SP list. And @WarrenBelz has provided a correct direction, you could take a try. If this could work, please mark @WarrenBelz 's solution as an answer to help other users to find it easily.
Combine that with your description, there is something wrong when you display DatePicker selected date in the Label.
I have a test to reproduce your issue when you put the following formula within the Text property of the corresponding Label, the date will display as "mm/dd/yyyy":
So please modify to set the Text property of the corresponding Label within the Gallery as below:
Text(DatePicker2.SelectedDate,"[$-en-US]dd/mm/yyyy")
If your problem is still, please share more details about the above questions.

Best Regards,
Qi

Was this reply helpful? Yes No

Join the conversation