SOLVED

Edit List won't update date fields

%3CLINGO-SUB%20id%3D%22lingo-sub-1679895%22%20slang%3D%22en-US%22%3EEdit%20List%20won't%20update%20date%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1679895%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20SharePoint%20list%20with%20both%20required%20and%20optional%20date%20columns.%20If%20I%20update%20a%20row%20in%20the%20list%20using%20the%20Information%20Panel%2C%20I%20can%20make%20changes%20and%20see%20them%20take%20place.%26nbsp%3B%20If%20instead%2C%20I%20use%20the%20%22edit%22%20item%20from%20the%20menu%20bar%2C%20I%20am%20presented%20the%20form%20where%20I%20can%20make%20the%20changes.%26nbsp%3B%20If%20I%20erase%20the%20date%20(backspace%20over%20it)%20on%20an%20optional%20date%20field%2C%20it%20won't%20update%20when%20I%20save%20the%20form.%26nbsp%3B%20The%20date%20remains%20even%20though%20I've%20erased%20it%20and%20saved%20the%20form.%26nbsp%3B%20Anyone%20else%20see%20this%20behavior%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1679895%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1682057%22%20slang%3D%22en-US%22%3ERe%3A%20Edit%20List%20won't%20update%20date%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1682057%22%20slang%3D%22en-US%22%3EI%20noticed%20this%20the%20other%20day.%20Curious%20if%20you%20edit%20the%20list%20and%20the%20column%20I%20thought%20I%20recall%20an%20allow%20blanks%20option.%20Wonder%20if%20that%20is%20on%3F%20I%20think%20it%20errors%20if%20that%20is%20on%20though%20and%20it%E2%80%99s%20probability%20just%20a%20bug.%3C%2FLINGO-BODY%3E
Highlighted
Contributor

We have a SharePoint list with both required and optional date columns. If I update a row in the list using the Information Panel, I can make changes and see them take place.  If instead, I use the "edit" item from the menu bar, I am presented the form where I can make the changes.  If I erase the date (backspace over it) on an optional date field, it won't update when I save the form.  The date remains even though I've erased it and saved the form.  Anyone else see this behavior?

7 Replies
Highlighted
I noticed this the other day. Curious if you edit the list and the column I thought I recall an allow blanks option. Wonder if that is on? I think it errors if that is on though and it’s probability just a bug.
Highlighted

@Chris Webb Hi Chris, I did a bit of testing yesterday and I'm not sure of the "allow blank" in this case.  In digging, the user did edit the form to remove the Attachments column.  They then saved and republished and the date stopped working.  It made me wonder about that process.  I made a copy of the list.  Once done, I edited the form, but made no changes at all.  I saved and republished and the form stopped working in the same way.  So, zero changes, but republishing the form did break the form.  Not sure what change is made in the publishing process, but republishing the form with no changes did break the form.

Highlighted
So when you say republish you’re editing the form via powerapps? Publishing could be updating the power apps version it’s using for the form which might have a bug. Let me know if that’s the case and I’ll go try to repro myself.
Highlighted

@Chris Webb Hi Chris, sorry for the delay.  Yes.  I did edit the form with Power Apps, but made no changes at all. I then saved and published the same form and began having the issues noted above.

Thanks!

Michael

Highlighted
Best Response confirmed by melkinsco (Contributor)
Solution

@melkinsco 

 

So this is odd, but it works. Go to your Power App form, Click Settings > Advanced Settings and then enable "Formula-Level Error Management". Save and publish your form. You should then be in business. 

Highlighted

@Chris Webb Thanks Chris!  That did work though I'm a bit worried about pinning my hopes on an "Experimental" feature that may go away at any time.  :xd:

The form is up and running though and the users will be back on track.  

Many thanks!

Best,

Michael

 

 

Highlighted
It’s been there for over two years so don’t think it’s going anywhere any time soon :face_with_tears_of_joy: