Answered

Increment counter to update sharepoint list

(0) Share

Report

Posted on by dmclaughlin

349

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.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

ScottShearer 25,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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().

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No