cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jwim
Level: Powered On

(not solved) Date Picker error - Entry required or invalid value

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Lavp
Level: Powered On

Re: (not resolved) Re: Date Picker error - Entry required or invalid value

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.

View solution in original post

13 REPLIES 13
Community Support Team
Community Support Team

Re: Date Picker error - Entry required or invalid value

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

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jwim
Level: Powered On

Re: Date Picker error - Entry required or invalid value

Unfortunately, that didn't work either Smiley Sad

 

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

jwim
Level: Powered On

(not resolved) Re: Date Picker error - Entry required or invalid value

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

jwim
Level: Powered On

Re: (not resolved) Re: Date Picker error - Entry required or invalid value

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

Community Support Team
Community Support Team

Re: (not resolved) Re: Date Picker error - Entry required or invalid value

Hi @jwim,

 

Please consider open a support ticket for this.

https://powerapps.microsoft.com/en-us/support/pro/ticket 

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Lavp
Level: Powered On

Re: (not resolved) Re: Date Picker error - Entry required or invalid value

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.

View solution in original post

haleyradt24
Level: Powered On

Re: (not resolved) Re: Date Picker error - Entry required or invalid value

I am also having this issue and I am a Sharepoint Admin and I created the list and form. 

jwim
Level: Powered On

Re: (not resolved) Re: Date Picker error - Entry required or invalid value

This was an issue with permission levels at the SharePoint level. I gave everyone Ownership level access and all of my issues went away.

CharlesDingas
Level: Powered On

Re: (not resolved) Re: Date Picker error - Entry required or invalid value

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?

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 454 members 5,338 guests
Please welcome our newest community members: