Answered

Increment counter to update sharepoint list

(0) Share

Report

Posted on by dmclaughlin

347

I have an app called credit requests with a credit # I want to increment when new requests are entered. I added a sharepoint list credit numbering with 1 document with the number 2500. I've tried adding a flow when new credit request entered where I get the credit numbering document with the 2500 in it to then increment by 1 and update the number both in the credit numbering document and the credit request document. Having a syntax issue and could use some help.

I use get item on credit numbering/ then compose with function add(outputs('Credit # sequential',1). This is where I get the error. I must have syntax for add wrong.

All responses (2)

Answers (1)

Verified answer

v-alzhan-msft on at

Like (0)

Report

Re: Increment counter to update sharepoint list

Hi @dmclaughlin ,

What id the type of the column?

Could you please share a screenshot of your flow?

Could you please share more details about the error message?

I see a similar requirement as yours, and the solution is create a Number type column, I hope the solution could also be your reference:

https://powerusers.microsoft.com/t5/Building-Flows/Auto-Increment-ID-duplication-using-flow/m-p/5188...

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report

Re: Increment counter to update sharepoint list

@dmclaughlin

I believe that you had posted this in another forum - the solution was to convert the SharePoint column value to a number using either int() or float().