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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.