cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rormiston
Level: Powered On

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
tfhegdbn
Level: Powered On

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

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 342 members 4,260 guests
Please welcome our newest community members: