Auto create running number with increment +1

(0) Share

Report

Posted on by DirkKoch

118

Hi,

I have a Power App which is connected to a Sharepoint list. For my use case I created a form which includes a number (" field Title") starting from 1 and after submitting the form the number should automatically go up by increment +1.

Currently I use the following formula as "Default" in the DataCardValue for "Title":

First(Sort('SP List Name'; Title; SortOrder.Descending)).Title+1

This works fine until I reach the number 10. Somehow after submitting the form for number 10 the increment +1 is not applied and 11 does not appear instead number 10 is still listed even though it has been saved and submitted. Whenever I click on the Title in the formula, it says 9, even though the item number 10 has been saved correctly to the SP list????

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,686 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @DirkKoch ,

Title is generally a Text column, you need to change it into a number

First( Sort( AddColumns( 'SP List Name'; "IDVal"; Value(Title) ); IDVal; SortOrder.Descending ) ).IDVal + 1

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
DirkKoch 118 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Thanks for the quick reply.
The counter does now show the correct number but when I submit the form under the new number (e.g. 11), I get an error saying "the list element could not be added or updated because duplicate value were found in the following fields of the list: [Title]". But in the Sharepoint list there is no item with Title value 11, it ends with 10. Also a refresh of the SP list within Power Apps does not solve the issue???

Was this reply helpful? Yes No
WarrenBelz 155,686 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@DirkKoch ,

What was the original name of this column (I was assuming Title) - can you please post a screen shot of the field in your SharePoint List Settings as the details you have posted presently make no logical sense to me.

Was this reply helpful? Yes No