Increment an existing column number

[gazzo1967]

Hi All
I have been given an existing Sharepoint list that has a column of reference numbers (can not be changed) which are being manually added.
I would like to automate the creation process and remove a step in adding data.

Having never done this before I am looking for direction in how to build my flow.
I believe that I have to do a get items after item created loop through the entries do an DESC then get Last add an increment of 1

If thats the logic how do i apply it?
Thanks Gary 🙂

[v-jefferni]

Hi @gazzo1967 ,

I think the logic should be Get items in DESC and count 1 to get the last entry:

then you can add 1 to the number.

Best regards,

[gazzo1967]

@v-jefferni 
Thank you for the response.
I have created my Automate as this

Then i have added the 'Compose'

add(first(outputs('Get_items')?['body/value'])?['GARY_TEST_FIPs'],1)

I get this error

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'add' expects its first parameter to be an integer, a float or a decimal number. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#add for usage details.'.

The column is a number column type
Thanks 
Gary

[sebkath14]

Hi @gazzo1967 - Maybe I do not fully get your request but could you not simply update the item once it has been created? In my case (screenshot) I create a GUID that is using the value of the Sharepoint ID column and adds it to a configured prefix. Since each row ID is unique, the new GUID will be too.

concat('PREFIX_STRING',string(triggerOutputs()?['body/ID']))

If that does the trick, please mark as solution. Either way, have a great day! 🙂

[gazzo1967]

@sebkath14 @v-jefferni 
Thank you for your response but thats not what im trying to do 

I have a number column that is a numeric reference number that cant be changed (already suggested using ID)
The column is being populated by the user having to look at the last entry and adding 1
I would like to automate this so they dont have to go into the list and can use the Power App.

So my example is the the numeric column has 1345 as the last entry.
I would like to update the next new entry with 1346 after the new item created.

regards
Gary

[grantjenkins · Accepted solution]

@gazzo1967 I'm assuming the issue is that the value being returned from SharePoint is stored as a string instead of a number. Can you try the following expression to see if it resolves the issue.

add(int(first(outputs('Get_items')?['body/value'])?['GARY_TEST_FIPs']),1)

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.