I've come across an issue where users in other regions are getting errors when they use the date picker. They can try and type it in using en-US format or pick from the date picker, but it still defaults to their local language/date format and creates the error.
I think it has to do with either the DefaultDate, TimeDateZone or Language but am unsure.
I've attached what it looks like from my users in Germany with an example of the error in English ("an entry is required or has an invalid value. Please correct and try again.")
Dates are being captured in a SharePoint list that uses MM/DD/YYYY format.
Any help would be appreciated!
Jason
Solved! Go to Solution.
Thankyou Sir for working with us.
This is Lavpreet from Microsoft team.
Resolution : User need to have complete permissions on SP to able to use date picker.
I supsect the issue here should be related to the Language preference configured under Internet Explorer.
Besides, what is the date type configured under SharePoint list?
Please take a try the workaorund below:
Under the Update property of the DataCard for the DatePicker, Modify the formula as below:
DateValue(Text(DatePicker.SelectedDate)) Or DateTimeValue(Text(DatePicker.SelectedDate))
For how to format Date in PowerApps, see:
Show text and format dates and times in PowerApps
Regards,
Michael
Unfortunately, that didn't work either 😞
The SharePoint list is set up as date/time type. Attached is a screenshot of the SharePoint setup.
I had someone test the current DataCardValue formula Text(DateTimeFormat.LongDate,"[$-en-US]en") in both IE and Chrome. Neither worked as before. I then changed the Update Property on the DataCard as suggested from DataCardValue13.SelectedDate to DateValue(Text(DataCardValue13.SelectedDate)). This works for me, but still doesn't work for someone configured with a different Language preference (tested in Chrome).
I've taken screenshots of the current DataCard and DataCardValue properties.
Is the SharePoint list settings accurate?
Regards,
Jason
Anyone else have an idea of how to get this to work for other regions? I still can't seem to find a way to make it work, outside of potentially breaking it down to separate day/month/year drop downs and then combining them into a day. That just seems like a lot of unnecessary work though and this should be fixable.
Regards,
Jason
Bump. Can anyone help?
Been almost a week now since original question and I've got an app out in production that people in non-US countries can't enter any dates in after finally convincing the organization to stop using excel spreadsheets and use a PowerApp connected to a SharePoint list. Not the best first impression. Would love to resolve this.
I beg of you,
Jason
Hi @jwim,
Please consider open a support ticket for this.
https://powerapps.microsoft.com/en-us/support/pro/ticket
Regards,
Michael
Thankyou Sir for working with us.
This is Lavpreet from Microsoft team.
Resolution : User need to have complete permissions on SP to able to use date picker.
I am also having this issue and I am a Sharepoint Admin and I created the list and form.
This was an issue with permission levels at the SharePoint level. I gave everyone Ownership level access and all of my issues went away.
I have the same exact issue. I created a list and have a field that is Date/Time. I create the app. it works one time and then it stops working and give the error you described. Have you have any luck on an answer?
User | Count |
---|---|
193 | |
126 | |
89 | |
48 | |
42 |
User | Count |
---|---|
278 | |
162 | |
137 | |
81 | |
78 |