Reply
Level 8
Posts: 105
Registered: ‎09-21-2017

Re: Issue since last update - An entry is required or has an invalid value

I have just started getting this error in an app that was previously working fine.

 

Version 2.0.722

 

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.

Level: Powered On
Posts: 48
Registered: ‎08-31-2017

Re: Issue since last update - An entry is required or has an invalid value

I just gave up - the show had to go on and deadlines were pressing - so I just switched to Patch as an alternative.

Level 8
Posts: 105
Registered: ‎09-21-2017

Re: Issue since last update - An entry is required or has an invalid value

[ Edited ]

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.

Level: Powered On
Posts: 13
Registered: ‎11-21-2017

Re: Issue since last update - An entry is required or has an invalid value

I am having this issue as well.

Level: Powered On
Posts: 7
Registered: ‎11-18-2017

Re: Issue since last update - An entry is required or has an invalid value

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. 

 

Level: Powered On
Posts: 7
Registered: ‎11-18-2017

Re: Issue since last update - An entry is required or has an invalid value

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. 

Highlighted
Level: Powered On
Posts: 7
Registered: ‎11-18-2017

Re: Issue since last update - An entry is required or has an invalid value

Smiley Happy

Solved! 

 

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.