Unanswered

Get Last OID from SQL and Increment The Variable by One

(1) Share

Report

Posted on by LC-21011721-0

I'm setting up a flow that will read rows from Google Sheets and write them to an ArcGIS SQL db. I need to find the last object ID and increment this value by one to write the new row into SQL. I cannot figure out how to make this work with for each loops. When I try to initialize a variable, it keeps telling me the Object ID is not a valid integer, yet Insert Row (V2) requires it to work. Here is what I have so far:

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,928 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

So, unfortunately you aren't showing the Expression you have in the variable.

Since to access the value, you need to use the Array access path from the Get Items above the variable initialize, where in the Loop, I have no doubt you are probably correctly accessing it because its easier, as its in the loop currentItem or Item() property, where you do not have that in the Variable.

Please share your expression.

You can use a compose, or a Filter Array etc, but its all based on how you sort for instance) in your Get Items, Using First, Last is your best bet as it will do what you want.

First, FirstN, Index, Last, and LastN functions - Power Platform | Microsoft Learn

So essentially, you can do a First(body/value of your get items), or Last same thing, but again it depends on your sort. If you didn't sort them so its the last one, then you have to either do a Select (and only grab that column) then sort that.

Either of these will work

Was this reply helpful? Yes No
LC-21011721-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Mike,

Thanks! Do I need another connector here to add a Last() statement?

Was this reply helpful? Yes No