cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

ID required in ADD ROW to SQL - how do i send null for SQL to assign the ID

I have been using flow for about a year on the same sql table.  When an item is added in a different location the trigger is supposed to add a new row to the sql table.  It has been working great for some time.

 

Now, recently, it is wanting me to assign the ID to the new row in SQL, which historically, it creates the ID on it's own.

 

is this a setting in SQL that someome may have changed, or is this a change in FLOW?  is there a way to get the max id form SQL and add 1?  or is there a better solution?

 

 

1 REPLY 1
Highlighted
Helper IV
Helper IV

Re: ID required in ADD ROW to SQL - how do i send null for SQL to assign the ID

Hi ,

 

Oddly, I did not require assign ID to the new row in SQL when using Insert row.
 
Can you share your Flow? This ID is required to be added by itself, or the system will automatically generate a unique ID.
 
If you want to get Max id, you may try to use Get rows to get all the ids, then store them in an array variable, and then get the maximum value in the array with max() function.
 
This value should be max id.
 
Maybe you can try it.
 
Regards.

 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,423)