cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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

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.

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

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.

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

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?

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (28,680)