I have customised a form in a SPO list. The SPO site has a UK regional settings, however it's accessed from users around the world and each user may have set their own region in their profile.
RIght now, even though the site's region is set to UK and my profile region is set to UK, the date format in the form is US. But when the date column displays in a view, it shows in UK format as expected.
I need the date fields in the form to follow the user's region. How do I do that?
From within Power Apps there is no direct way to access a users regional setting. SharePoint does use this. but from Power Apps unfortunately not (yet).
You should also vote on @YatinMumbai 's idea: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Date-formats-using-user-s-locale-or-regional-da...
I have created a workaround to get a users Email Inbox folder naming because that is language specific upon creation but I would not recommend it for bigger organizations en with more than 2 languages it becomes an hassle.
You can edit the Date Picker Control (see https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-date-picker for more info on the control )and the following properties are relevant:
What I often do so I can centrally manage the format that I want:
Then language 1 Dutch =
And language 2 English US =
So you can put a texts like "[$-nl-NL]ddd dd mmm yyyy" directly in the Date Picker Control in the Format Property but when you have multiple Date Pickers throughout your Power App you may want to centralize the management of the format 👍
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!