11-30-2017 10:57 PM
I have just started getting this error in an app that was previously working fine.
When I first try to submit the record I get the error 'An entry is required or has an invalid value'. I hit submit again (without having changed anything) and the record is saved correctly. Happens both on the creation of a new record and modification an existing record.
Backend in SQL Azure DB. I've tried tricks like adding a TimeStamp field but it didn't make any difference.
12-01-2017 12:29 AM - edited 12-01-2017 12:30 AM
All my tables have an identity column which I had included in the forms as a datacard (in some cases I was allowing deletes of existing records from the form so needed the identity to specify the record to be deleted).
Removing the ID column data cards seems to resolve this issue, though means I need to find another way of performing deletes.
12-14-2017 08:14 AM
I thought I solved this by removing the Sharepoint ID field. But when I redid the form later, the error returned and I don't have the ID field present. Very frustrating.
12-15-2017 04:26 PM
This drove me nuts, but I believe I found a workaround. I other cases, I just had to remove the item ID field from the form, however, this was not resolving one particular case.
I had a list that was populated from another SharePoint via via a PowerApps Patch function. It is a task form where the user just has to select 'Finished' and add some comments, so I made all the other fields Read-only. The Title field was required of course, but I had made it read only. On a whim, I made that field editable and error went away.
So now I will try hiding the Title field (Visible property), and use a label field to display the contents. Pretty sure that will work.
12-15-2017 04:36 PM
1. Make the desired read-only, but required Fields (e.g. Title) editable, then hide using the visible property.
2. Add a label control with the Text property referencing the field you hid.