cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

BUG? 'An entry is required or has invalid value' Azure SQL, Identity Column req field

I am developing a PowerApp which uses Azure SQL DB as the data source.

 

I have a table OrderHeader. The primary key is OrderHeaderID and is an int set as identity(1,1). I have a form which contains OrderHeaderID as a DataCard and for which the default is ThisItem.OrderHeaderID.

 

 

When working in the PowerApps web editor, I create a form based on OrderHeader and add the OrderHeaderID as a datacard. I can then add a new OrderHeader in the form on the web editor.

 

When I publish and run the app in the webplayer, iOS or Win Mobile, when I try to add an OrderHeader I get the error that 'An entry is required or has an invalid value' seemingly because the OrderHeaderID has not been populated.

 

If I close the app in the PowerApps Web Editor then re-open it, I get the same error when trying to add an OrderHeader, but if I delete the OrderHeaderID data card from the form and then add it again (without modifying any settings) then it works again!

 

I also have an OrderDetail data source and form with an OrderDetailID card. This behaves exactly the same way.

 

Thanks

Paul

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate III
Advocate III

Re: BUG? 'An entry is required or has invalid value' Azure SQL, Identity Column req field

This could be a longshot, but if you have a TimeStamp data type field in your table, try adding one.

In general, I've seen this solve an assortment of problems.

DatabaseMX ('mx')
Microsoft Access MVP

View solution in original post

6 REPLIES 6
Highlighted
Advocate III
Advocate III

Re: BUG? 'An entry is required or has invalid value' Azure SQL, Identity Column req field

This could be a longshot, but if you have a TimeStamp data type field in your table, try adding one.

In general, I've seen this solve an assortment of problems.

DatabaseMX ('mx')
Microsoft Access MVP

View solution in original post

Highlighted
Super User
Super User

Re: BUG? 'An entry is required or has invalid value' Azure SQL, Identity Column req field

Good call MX

 

Adding the timestamp resolved the issues - thanks so much!

 

Highlighted
Advocate III
Advocate III

Re: BUG? 'An entry is required or has invalid value' Azure SQL, Identity Column req field

It's Magic I tell you 🙂

 

And good to know this worked !

DatabaseMX ('mx')
Microsoft Access MVP
Highlighted
Anonymous
Not applicable

Re: BUG? 'An entry is required or has invalid value' Azure SQL, Identity Column req field

I'm not sure that this problem has been fixed. I tried adding a timestamp data type column in the Azure table to fix this but it didnt work for me. 

 

Isnt this a bug that should be fixed? You should be able to show a read only primary key identity field in a edit form without it throwing an error when you save.

Highlighted
Advocate III
Advocate III

Re: BUG? 'An entry is required or has invalid value' Azure SQL, Identity Column req field

It is not sufficient to have a Timestamp field in the Azure table, you also need to add it to the Edit Form.

 

I had the same issue with unreliable edits, even though my table already had a Timestamp field.

 

I've seen similar issues with application programs like Access, so as a habit, I include a Timestamp field on EVERY SQL Server table I design. The "cost" is insignificant. Purists will tell you the proper term is "rowversion", and this is because "timestamp" syntax has been deprecated, yet even in SQL Server Management Studio, only "timestamp" is accepted as a data type.

Highlighted
Advocate I
Advocate I

Re: BUG? 'An entry is required or has invalid value' Azure SQL, Identity Column req field

If that's what you call a long shot im eager to see what you class as an accurate snipin'
Fixed my issue - thanks.

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,183)