cancel
Showing results for 
Search instead for 
Did you mean: 

mySQL and PostgreSQL connectors - add support for adding records to tables with "auto increment" primary key fields

The MySQL and PostgreSQL connectors fail to add records to tables with 'auto increment' primary key columns.

 

When a user attempts to add a record to a table with an 'auto increment' primary key column, Power Apps returns an error that prompts for a primary key field value. This is a bug, because the database will be generating this value.

There are more details about this problem in this post:https://powerusers.microsoft.com/t5/Building-Power-Apps/MySQL-Auto-Increment-Primary-Key-Incompatibi...

 

It would be great if this problem could be fixed because MySQL and PostgreSQL are the two most popular open source databases, and there is no practical way to work around this problem.

Status: New