cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
onyebuchiboss
Helper III
Helper III

Date fields not persisting in sharepoint list

I am new to using sharepoint list as a source of data in canvas app, I have noticed the date field when used in an edit does not update the date on the list in sharepoint. Is there any setting that needs to be done? 

So the new updated date isnt persisting in sharepoint. can someone with a better knowledge please help?

 

Thanks.

6 REPLIES 6
CNT
Super User
Super User

@onyebuchiboss Check if your date column as this setting (in the List settings in SP)

CNT_0-1622064828991.png

 

onyebuchiboss
Helper III
Helper III

Thanks for responding @CNT . This is the setting I have on the date column:

 

Capture.PNG

@onyebuchiboss How are you writing back the values to SP? SubmitForm() or Patch? Could you share some formulas please.

I am using SubmitForm().   

@onyebuchiboss Does the datepicker has this property set,

CNT_0-1622103383092.png

Also, what formula do you have in the Update property of the DataCard which holds this DatePicker?

I have just confirmed it has the property set to the "dateTimeFormat.ShortDate".

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,935)