cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

(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
Microsoft
Microsoft

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
Highlighted
Community Support
Community Support

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.
Highlighted
Helper I
Helper I

Re: Date Picker error - Entry required or invalid value

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

Highlighted
Helper I
Helper I

(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

Highlighted
Helper I
Helper I

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

Highlighted
Community Support
Community Support

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
Microsoft
Microsoft

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

Highlighted
Advocate I
Advocate I

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. 

Highlighted
Helper I
Helper I

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.

Highlighted
Regular Visitor

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
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (12,412)