Forum Discussion

Iron Contributor

Sep 17, 2020

Solved

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 "...

microsoft lists

SharePoint Online

ChrisWebbTech
Sep 19, 2020
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.

MVP

Sep 17, 2020

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.

melkinsco
Iron Contributor
Sep 18, 2020
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.
- ChrisWebbTech
  MVP
  Sep 18, 2020
  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.
  - melkinsco
    Iron Contributor
    Sep 19, 2020
    ChrisWebbTech 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