cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Datepicker won't update in form, but updates in SharePoint list

I have created a PowerApps form from a SharePoint list where I have 2 date picker fields (Date only).

I have changed the date format of the date picker in the EditForm to:

Text(From1;"[$-en-US]dd/mm/yyy";"nl-NL")

 

But the selected date doesn't update in the form, so if I first had 30/07/2018 as a date, but want to update it 22/08/2018, the form still shows 30/07/2018. If I save the form, the item in SP list shows 22/08, but when I want to edit the form again, it still shows up as 30/07.

 

If I change the format of the date to "ShortDate", I don't have any problems with updating the form. It seems like PowerApps has issues with non-US date formats, how can I fix this? The properties of the datacard aren't unlocked.

5 REPLIES 5
Highlighted
Advocate II
Advocate II

Re: Datepicker won't update in form, but updates in SharePoint list

In the view form, I don't have this problem, only in the EditForm and CreateForm. Is there a way to fix this issue?

My browser language 'Chrome) is in Dutch, in PowerApps it shows the correct Date Format, but not in SharePoint (US format). Our SharePoint site, regional settings are Dutch and Brussels timezone.

Highlighted
Community Support
Community Support

Re: Datepicker won't update in form, but updates in SharePoint list

Hi @Gines,

 

Could you please share more details about how you configrued the format of the date within the form contol?

Text(From1;"[$-en-US]dd/mm/yyy";"nl-NL")

what does the from1 indicate here?

 

If the date could be saved successfully, then the issue here should be the format and the default property configured with the corresponding controls.

 

For the default  property, please take a try with:

Text(Parent.Default;"[$-en-US]dd/mm/yyy";"nl-NL")

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

Re: Datepicker won't update in form, but updates in SharePoint list

Hi @Gines,

 

Any update from your side?

 

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 II
Helper II

Re: Datepicker won't update in form, but updates in SharePoint list

Hello, I have a similar problem .. when I create an item with dates everything is ok but when the item changes the date changes uncontrollably and gets an incorrect value. 

Highlighted
Advocate II
Advocate II

Re: Datepicker won't update in form, but updates in SharePoint list

Hi @v-micsh-msft,

 

Sorry for my late reply. 

 

The From1 is the name of the Datacard. I tried your solution, but it is still showing me in US format. For now I have advised my people to use language settings English (United Kingdom) and it is now showing in DD/MM/YYYY, but it should be easy in Powerapps to change the Dateformat.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,822)