Issues with Date Picker / Date Formats

[jslsmithyx]

Hello Community, 

I'm having some problems getting my dates to display / submit correctly using a Datepicker linked to a SharePoint List column configured as a date column. Searched multiple previous posts & tried many solutions but none have worked for me so far... 

Whatever I try, I cannot get dates to submit in a UK format to my SP list via a date picker. 

Dates displayed fine in the SP list itself (06/04/2020 = 06th April 2020) & initially displayed fine on the Datepicker, but whenever a new date is submitted it reverts to the US format & saves to the SP list as such. 

Things tried so far: 

Ensured SP Regional Settings are set to United Kingdom

Forcing the DatePicker format as "DD/MM/YYYY"

Setting language settings as "en-GB"

Setting the 'default' value on the Datacard itself as 'Text(ThisItem.'Target Release Date', "[$-en-GB]dd/mm/yyyy]")'

I can't understand where the Datepicker is getting the US date format from. The one thing I have noticed is when hovering over the formula in the 'update' value of the Datacard, the opposite date format is shown:

Any help would be greatly appreciated. 

Thanks! 

Joe 

[WarrenBelz]

Hi @jslsmithyx ,

Have a look at the Regional Settings of both your PC and the SharePoint site. I am in Australia and all I ever need to do is set the Format for the DatePicker to "dd/mm/yyyy".

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[v-yutliu-msft]

Hi @jslsmithyx ,

1)In powerapps, the time format will display in the format based on your current region.

That's the reason why "DatePicker1.SelectedDate" display as the US format.

2)In sharepoint, the time format will display in the format based the region that you set in the site settings.

That's the reason why you could make date display in the format of "dd/mm/yyyy".

However, time just display in different formats in two places. When updating, time format will not affect. Using "DatePicker1.SelectedDate" is enough.

I've made a similar test for your reference:

1) In sharepoint

site settings->region->UK

2)In powerapps

set the datepicker's Format:

"[$-en-GB]dd/mm/yyyy]"

 set the datepicker's DefaultDate:

ThisItem.'Target Release Date'

set the datacard's Update:

TRPicker.SelectedDate

Then you could update successfully.

Best regards,

[jslsmithyx]

@WarrenBelz thanks for getting back to me. 

I've checked regional settings on both SharePoint & my PC, both are set to United Kingdom.

I've had another look this morning & this is what appears to be happening:

When a date is initially selected in the date picker, its displayed as expected (today's date would be shown 08/06/2020)

When the form is submitted, the date is submitted & recorded on SharePoint as 06/08/2020 & when viewing on the calendar within SharePoint the date is stated '06 August 2020'.

The date picker calendar also shows '06 August 2020'.

So it looks like everything is being displayed in the correct format, but during the submission process the date is being recorded in the wrong format?

Thanks, 

Joe

[WarrenBelz · Accepted solution]

Thanks @jslsmithyx ,

This is very strange. To isolate whether it is the app or your settings,

• Make a new blank app, connect it to your data source, add an Edit form
• Make the Data Source your list name and the Item First(YourListName).
• Add the date field and set the format of the date picker to "dd/mm/yyyy".
• Add a save button with SubmitForm(YourFormName).
• Change the date to a day over 12 (20/5/2020 or something), save and see what saves
• Do the same for 8/6/2020

If they both save correctly, replace the data picker in your app and see if they helps.

If not, it is your PC, network or SharePoint settings somewhere.

[jslsmithyx]

@WarrenBelz @v-yutliu-msft, 

Thanks for both your input - going to work my way through both your suggestions & will report back when I can...

Also going to properly check through my PC & Browser region settings & see if there is something going on here. 

Cheers, 

Joe

[jslsmithyx]

@WarrenBelz thanks for your suggestion. 

I have completed your diagnostic steps & can confirm that the dates are saved & displayed in the correct format using the test app. 

I deleted / recreated the DatePicker & I've replicated all the settings on the test app DatePicker.datacard & the Date Picker itself over to the main app but still having the problem here. 

When selecting a date UK format 30/06/2020, the Powerapp chucks up this error msg

'Server Response 'Data Source' failed. The String is not recognised as a valid DateTime. There is an unknown word starting at 'Index1' 

I'm wondering whether the fact I configured the SP list column as a 'Date' Column after I created the form where the DatePicker sits is causing the problem.

It wouldn't be the worst having to delete / recreate the form entirely, however I have done some customisation on it already so if there is a known solution to the error it'd be much appreciated.

Thanks again! 

Joe 

[WarrenBelz]

Thanks @jslsmithyx ,

Another test - make another date field, add it to your current app and do the same test. If this works, it has to be the other field and you might then have to just copy any data over into the new field, delete the old field, make a new one with the same name as the old one then copy the data back.

[jslsmithyx]

Hi @WarrenBelz ,

Accepting your post as the solution - I deleted & recreated the entire datacard on my app & configured as you advised, everything is now working as expecting. 

Thanks to you both @v-yutliu-msft .

Joe 

[Walter_Wego]

Hi I was wondering if you have had any residual issues with this. my app works fine with most phones but some OS's seem to disregard the UK/AU date format and try to push it through as US Format which either gives the wrong date 5/6/20 as  6th of May or refuses to enter if the first digits are over 12 (as in there are not 13 months in a year). It has only happened with some phones though. Just wondering if you are still encountering any issues. 

Cheers