Hi there,
I'm creating an application to insert records into a Postgres database, but having problems with the Primary Key.
Powerapps is insisting that I try to set a value, despite the database being set to default new records to the next value in the sequence.
Is there anyway I can force PowerApps to rely on the database sequence?
I am using MySql DB. And I do the following,
You have to make sure that your primary key value is set to Autoincrement. Then in your Patch set the primary key into 0 value. The DB will take responsibility for the sequence.
OnSelect= Patch('[database_name].[table_name]',Defaults('[database_name].[table_name]'),{column_primary_key:0, column__2: ... });
User | Count |
---|---|
256 | |
109 | |
90 | |
51 | |
44 |