Inserting Records - Primary Key set to database sequence?

[mjsonline]

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?

[FatimahAlQadib]

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: ... });