Create an SQL row when an automatic index ID cant be empty

[martinav]

Pretty simple situation.  I have a table with an index that auto increments.  If I create a row in flow, it is a mandatory field, but I cant populate it because its auto generated. What to do in this case?

Thanks.

[abm · Accepted solution]

Hi @martinav 

A while back I have answered this. Please see this link below.

Solved: Create new record on MySQL table - Power Platform Community (microsoft.com)

Thanks

[martinav]

I was  hoping to avoid this.  Kind of iffy, especially if more than one use the app.  Its kind of a fundamental flaw in using SQL.  SP does  not have this problem.  It generates an index without you having to tell it too.  😕  C'mon microsoft.  

[abm]

I completely agree.  For auto generated field, flow should have shown as non mandatory or not shown that field.