Five me I am very new to PowerApps and have come in to take over someone else's work.

At the moment, we have a form in the app that builds up information for a product. We have a button to add a new product and a series of field to fill out or choose from a drop down which we should then be able to submit this new product and add it into our materials list.

Currently the error that shows is this:

The column celery in the form is a drop down that we choose an option to say if the allergen is present or not.

It exists in our database because we are able to select it from our data source here is another screen shot showing the SQL table its contained in:

Has anyone ever come across this before? Could it be to do with that the field I am trying to insert it into is an small int and the drop down is presented as VARCHAR (I'm not sure if there is something in the back ground that says option 1 = 0 option 2 = 1 and option 3 = -1)

Any help or guidance will be appreciated

Five me I am very new to PowerApps and have come in to take over someone else's work.

At the moment, we have a form in the app that builds up information for a product. We have a button to add a new product and a series of field to fill out or choose from a drop down which we should then be able to submit this new product and add it into our materials list.

Currently the error that shows is this:

The column celery in the form is a drop down that we choose an option to say if the allergen is present or not.

It exists in our database because we are able to select it from our data source here is another screen shot showing the SQL table its contained in:

Has anyone ever come across this before? Could it be to do with that the field I am trying to insert it into is an small int and the drop down is presented as VARCHAR (I'm not sure if there is something in the back ground that says option 1 = 0 option 2 = 1 and option 3 = -1)

Any help or guidance will be appreciated

• sql
• azure
• powerapps

1 Answer 1

This issue is likely related to the SQL column type and how PowerApps is handling the data submission. Here are some potential causes and solutions:

Verify SQL Table and PowerApps Data Types

• Open your SQL Server Management Studio (SSMS) and confirm the celery column is indeed SMALLINT.

• If it is VARCHAR in PowerApps, convert it before submitting.

Verify SQL Table Constraints:

• Check if the SQL table has constraints (e.g., triggers or foreign keys), Or that particular table has auto incremented values that might be blocking the insert operation. Ensure the values being submitted meet these constraints.