Unanswered

create a consecutive number

(0) Share

Report

Posted on by Adinator

212

Hi, I have a question, I have created an app for 5s methods. I want to take a photo of a tool with the app and upload it to sharepoint. The problem is, can you automatically create a consecutive number from 1 to ??? and enter it in sharepoint? so i start the app there should then automatically be e.g. 17 if there are already 16 entries in the sharepoint then you know ah okay this is the 17th entry then when i upload it. I hope I was able to explain it.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Adinator

All SharePoint lists already have a hidden but accessible Id column that generates a sequential number. It can be unhidden in SharePoint. Ref. https://sharepointmaven.com/how-to-add-a-unique-identifier-to-a-sharepoint-list-or-library/

Solution: https://powerusers.microsoft.com/t5/Building-Power-Apps/how-to-set-Automatic-sequence-number-in-sharepoint-List-whenever/td-p/523104

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
Lyessdt18 14 on at

Like
a
(0)

Report
Copy link

Link copied!
You can use this formula in On select property of a Power Apps control :
Patch(SharePointTableName, Defaults(SharepointTableName),{IDColumnName: If(IsEmpty(SharepointTableName),1,CountRows(SharepointTableName) + 1)})
WarrenBelz 156,730 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Adinator ,

You also need to allow for someone deleting a record, so you cannot simply count the Rows - the value you are looking for is

First( Sort( SPListName, ID, SortOrder.Descending ) ).ID + 1

You can add this to the Default of a card hidden on a Form (I will use the field name Counter here)

If( YourFormName.Mode = FormMode.New, First( Sort( SPListName, ID, SortOrder.Descending ) ).ID + 1, ThisItem.Counter )

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