Unanswered

Powerapps DatePicker Issue with Different Language

(2) Share

Report

Posted on by Community Power Pla...

Hi,

I am building a powerapps with a date picker field which returns the value in "mm/dd/yyyy" format. My browser's default value is English(US). when I change my browser's language to English(UK), the date picker starts returning the garbage value. Ex: If date selected in date picker is "14th November 2019" with English(US) language, the value returned is "11/14/2019" but with English(UK) language, the value returned is "11/02/2020" which is incorrect. can anybody help me with this and let me know a solution/workaround for this.

Thanks in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

mdevaney 29,989 Moderator on at

Like (1)

Report

@Anonymous
Hello there. What settings are you using for the DatePicker? Do they look like this? Is your language setting matching mine?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

1 people found this reply helpful.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi There,

Thanks for your response.
I updated my datepicker control to have same settings as that of yours. Now it is not returning any random value but it returns the date in "dd/mm/yyyy" format where as I want the date in "mm/dd/yyyy" format. can you suggest a solution for that as well.

thanks

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

Try changing the language property to “en-US”

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I tried changing the language to "en-US" but date picker still returns the value in "dd/mm/yyyy" format for English UK language browser setting.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Let me know if I am missing something here:

1. My browser language setting is English (UK)

2. When I specify user local in the date picker, it returns 14/11/2019

3. When I specify "en-US" in the date picker language setting, it instantly changes to 11/14/2019

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!
Hardit(Haman)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi There,

From your first screenshot I can see that your browser language in "English US", English UK is turned off. Secondly, In my case the date picker shows the date in desired format but it returns the incorrect value.
Screenshots below:
1. Browser Setting-
2. DatePicker Settings-
3. Value in DatePicker (correct format i.e. mm/dd/yyyy)-
4. Value returned by DatePicker (incorrect format i.e. dd/mm/yyyy)-

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

In my 1st screenshot, the language I set as UK English, the spell check is set to US English. But I can switch that too and check again.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Just wanted to let you know I was able to replicate your experience. I am pretty sure you know but just wanted to confirm that you do not want to use a formula to format the date with something like this?

Text(DatePicker1.SelectedDate,"mm/dd/yyyy")

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!
Hardit(Haman)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I tried to use the formulas to format the date in desired format, but the formulas also returns the incorrect date value after formatting. secondly I am performing some date comparisons on these dates, so I can not use text formula. I have to use date formatting formulas.

Was this reply helpful? Yes No