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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

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.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,665)