Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Mysql ID field required

I have an on premises gateway working as intended.


However even with a primary key (auto increment, unique) in my mysql table, when I use mysql in ms flow it asks for an "ID" value in which the ID column is the primary key in the mysql table.


I have tried index, null, no null, removing and adding the primary column etc and ms flow still asks for an ID value.


What can I do?

Community Support
Community Support

Hi @ifarmsafe,


It requires the row ID in the Get Row action: 

Also, you can have a test using the Get rows action to check the output.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Apologies but I dont understand.


When attempting to add a row to a mysql table it does not recognise the primary key column and displays that field with a red dot so I have no choice but to enter a value when in MS Flow (that will not work because once the data is sent to the table, it will produce an error because of the auto increment interger is to be created by mysql). I can see the table and all is well in MS Flow but I cant get MS Flow to ignore the primary column that is auto indexed.

This is frustrating.


So I get rows mysql. Add the Row_ID from that to insert row mysql (same table) and I get a duplicate primary error.


I cant see how it is possible to use the primary column of the table when adding data to a mysql table.

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,745)