Answered

AutoGen Mandatory DB2 field blocking an INSERT

(0) Share

Report

Posted on by sludgeza

I have a PowerApps CRUD sopun up from a DB2 batabase wich has an ID field that is set to defined as generated always. Even if I set the ID field's Requierd to False in my App or remove the data card it fails to exicute the INSERT. Strangly the App will save an edit of a record. I have no idea where to from here.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @sludgeza ,

Do you set the ID as Requried/Mandatory field within your DB2 table?

Based on the issue that you mentioned, I think you have some misunderstanding on data sources in PowerApps.

Actually, the PowerApps app inherits data access permissions from data source itself. The Edit form data cards would be generated based on data source itself.

If you set the ID as Requried/Mandatory field within your DB2 table, you must provide a value for this field wthin your Edit form.

As an an fixed solution, please consider set the Default property of the Text Input box within the ID data card in your Edit form to following:

First(Sort('Your DB2 Table', ID, Descending)).ID + 1

Set the OnSelect property of the "Submit" button to following:

Refresh('Your DB2 Table'); /* <-- Add this formula */ SubmitForm(EditForm1) /* <-- EditForm1 represents the Edit form in your app */

Best regards,

Was this reply helpful? Yes No
sludgeza 27 on at

Like
a
(0)

Report
Copy link

Link copied!
OK this works :
As an an fixed solution, please consider set the Default property of the Text Input box within the ID data card in your Edit form to following:
First(Sort('Your DB2 Table', ID, Descending)).ID + 1"
But... The insert still fails with the same message that the ID field is defined as ALWAYS GENERATED. I find this odd as the edit function works where the ID field is populated on my PowerApps form but in the create form it fails. The ID field in the db2 is the Primary Key so I'm not sure if this bit of architectuer of the db2 can be changed.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

HI @sludgeza ,

Please consider edit your DB2 Table, and then remove the Auto-Generate attribute from the ID field. Then re-generate an app based on the DB2 table, try my above solution again (set Default value for ID field using formula), check if the issue is solved.

Best regards,

Was this reply helpful? Yes No