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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

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