Forum Discussion
Edit List won't update date fields
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?
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.
7 Replies
- 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.
ChrisWebbTech 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.
- 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.
