Error for Primary key in PowerApps

(0) Share

Report

Posted on by OK29

388

Hi,

Created powerapps application and storing data to Oracle. Application is creating new record in Oracle table without any issue but I am getting the following error after submitting the application.

Here is the code for PrimaryKey datacard value om Submitbutton.

Refresh('[DatabaseName].[TableName]');
UpdateContext({sID: First(Sort('[DatabaseName].[TableName]', ID, Descending)).ID + 1});

Can anyone please let me know suggestion to get rid of this error?

Any help would be greatly appreciated.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

GarethPrisk 2,828 on at

Like
a
(0)

Report
Copy link

Link copied!

Looks like the data being submitted to Oracle is violating a primary key that someone setup.

I am not an Oracle expert, but this should get you started (or someone else), to further understand the requirements of the PK.

https://stackoverflow.com/questions/9689412/issue-ora-00001-unique-constraint-violated-coming-in-insert-update

Was this reply helpful? Yes No
GarethPrisk 2,828 on at

Like
a
(0)

Report
Copy link

Link copied!

Oops - responded a bit quickly.

In your code, it looks like you're trying to force the 'PrimaryKey' column to be the ID's max value incremented by 1? Is this valid?

What the actual column tied to the PrimaryKey card, is it the ID column? Can you set that manually in Oracle?

I would ensure you have an accurate value first. I suspect you are trying to Refresh the table, to ensure you have the latest data, before determining what the value should be. I would switch this to be a variable or a collection.

Is the function you noted on the Update property of the DataCard for the PrimaryKey field? Or is that mapped to the context variable (sID)?

I don't think the Refresh function will work as you expect. It will trigger it but it doesn't wait for it to finish, in my experiences, before moving onto the next function. You shouldn't need it. The simply act of setting the variable makes an explicit call.

Was this reply helpful? Yes No
OK29 388 on at

Like
a
(0)

Report
Copy link

Link copied!

Removed refresh function still I am facing same issue but record is being created with no issue. Is there anyway to turn off the error message display on the banner?

Was this reply helpful? Yes No