Auto Increment Column with Document Sets - is this even possible?

%3CLINGO-SUB%20id%3D%22lingo-sub-66750%22%20slang%3D%22en-US%22%3EAuto%20Increment%20Column%20with%20Document%20Sets%20-%20is%20this%20even%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-66750%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20viable%20out%20of%20the%20box%20way%20to%20create%20an%20auto%20increment%20column%20with%20document%20sets%3F%3C%2FP%3E%3CP%3EI%20thought%20I%20could%20use%20the%20ID%2C%20but%20I%20wasn%20aware%20that%20the%20documents%20within%20document%20sets%20take%20up%20from%20the%20%22global%22%20ID%20set%20of%20the%20root%20folder.%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20that%20I've%20created%20a%20few%20test%20sets%20with%20documents%20my%20first%20three%20document%20sets%20have%20these%20IDs%204%2C%2025%2C%20776%20%3Ap%3C%2Fimg%3E%3C%2FP%3E%3CP%3EI%20would%20have%20been%20OK%20with%20a%20few%20gaps%20due%20to%20deletion%2C%20but%20these%20jumps%20are%20not%20viable.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-66750%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-187328%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Increment%20Column%20with%20Document%20Sets%20-%20is%20this%20even%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-187328%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you.%20I'll%20try%20to%20figure%20out%20a%20solution%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-185309%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Increment%20Column%20with%20Document%20Sets%20-%20is%20this%20even%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185309%22%20slang%3D%22en-US%22%3EHad%20a%20consultant%20build%20a%20SharePoint%20workflow.%20Therefore%20wasn%E2%80%99t%20a%20no-code%20solution.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-185094%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Increment%20Column%20with%20Document%20Sets%20-%20is%20this%20even%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185094%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EDid%20you%20find%20any%20solution%20for%20Document%20Set%20IDs%3F%20I%20have%20the%20same%20problem%20and%20I%20couldn't%20find%20any%20'no%20code'%20solution...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-69943%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Increment%20Column%20with%20Document%20Sets%20-%20is%20this%20even%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-69943%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20this%20I%20allways%20use%20a%20small%20SharePoint%20Designer%20Workflow%20with%20a%20separate%20'Number%20List'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.nothingbutsharepoint.com%2F2010%2F06%2F03%2Fsharepoint-how-to-create-an-auto-incrementing-number-field-for-use-in-a-custom-id-part-1-aspx%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.nothingbutsharepoint.com%2F2010%2F06%2F03%2Fsharepoint-how-to-create-an-auto-incrementing-number-field-for-use-in-a-custom-id-part-1-aspx%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fgeekswithblogs.net%2FThorvaldBoe%2Farchive%2F2015%2F01%2F14%2F161131.aspx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fgeekswithblogs.net%2FThorvaldBoe%2Farchive%2F2015%2F01%2F14%2F161131.aspx%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-66885%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Increment%20Column%20with%20Document%20Sets%20-%20is%20this%20even%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-66885%22%20slang%3D%22en-US%22%3EI%20can%20only%20think%20on%20doing%20by%20means%20of%20a%20Workflow%20%2F%20something%20that%20updates%20your%20Increment%20column%20based%20on%20previous%20data%20(document%20sets)%20in%20the%20library%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1057909%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Increment%20Column%20with%20Document%20Sets%20-%20is%20this%20even%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1057909%22%20slang%3D%22en-US%22%3E%3CP%3EThese%20days%2C%20I%20would%20advise%20using%20Power%20Automate%20to%20create%20a%20flow%20that%20does%20this.%20This%20will%20be%20a%20no-code%2Flow-code%20solution%20that%20doesn't%20necessarily%20require%20a%20developer%20or%20consultant%20in%20the%20middle.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337886%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Increment%20Column%20with%20Document%20Sets%20-%20is%20this%20even%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337886%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414079%22%20target%3D%22_blank%22%3E%40SabbeRubbish%3C%2FA%3E%26nbsp%3BI%20just%20stumbled%20to%20your%20comment%20%3A)%3C%2Fimg%3E%20After%20more%20than%20a%20Year%20it%20is%20still%20not%20possible%20to%20create%20a%20new%20Document%20Set%20from%20PowerApps.%20You%20can%20add%20documents%20to%20existing%20document%20set%20and%20also%20edit%20and%20save%20an%20existing%20document%20set%2C%20but%20not%20create%20a%20new%20one%20%3A(%3C%2Fimg%3E%20The%20AutoId%20number%20would%20have%20come%20handy%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Valued Contributor

Is there any viable out of the box way to create an auto increment column with document sets?

I thought I could use the ID, but I wasn aware that the documents within document sets take up from the "global" ID set of the root folder. 

Now that I've created a few test sets with documents my first three document sets have these IDs 4, 25, 776 :p

I would have been OK with a few gaps due to deletion, but these jumps are not viable.

7 Replies
Highlighted
I can only think on doing by means of a Workflow / something that updates your Increment column based on previous data (document sets) in the library
Highlighted

Hi,

Did you find any solution for Document Set IDs? I have the same problem and I couldn't find any 'no code' solution...

Highlighted
Had a consultant build a SharePoint workflow. Therefore wasn’t a no-code solution.
Highlighted

Thank you. I'll try to figure out a solution

Highlighted

These days, I would advise using Power Automate to create a flow that does this. This will be a no-code/low-code solution that doesn't necessarily require a developer or consultant in the middle.

Highlighted

@SabbeRubbish I just stumbled to your comment :) After more than a Year it is still not possible to create a new Document Set from PowerApps. You can add documents to existing document set and also edit and save an existing document set, but not create a new one :( The AutoId number would have come handy here.