Unique id in title / column

%3CLINGO-SUB%20id%3D%22lingo-sub-2113935%22%20slang%3D%22en-US%22%3EUnique%20id%20in%20title%20%2F%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2113935%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20trying%20to%20create%20a%20knowledge%20database%20in%20Microsoft%20List%20%2F%20Sharepoint.%3CBR%20%2F%3EI%20would%20like%20when%20my%20colleagues%20creates%20and%20knowledge%20article%20the%20title%20gets%20an%20unique%20title%20%2F%20ID.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EFor%20exampel%3A%3CBR%20%2F%3E%3CSTRONG%3ETitle%3A%20KB0000001%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSTRONG%3EAnd%20when%20the%20next%20person%20creates%20an%20article%20the%20title%20will%20be%20default%20be%26nbsp%3B%3CSTRONG%3EKB0000002%26nbsp%3B%3C%2FSTRONG%3Eand%20so%20on%20and%20so%20on.%3CBR%20%2F%3EThink%20you%20get%20the%20point%2C%20but%20how%20do%20I%20do%20it%3F%26nbsp%3B%3Aface_with_rolling_eyes%3A%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20bright%20brains%20out%20here%20that%20can%20help%20me%3F%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Ewahlbang%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2113935%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2114164%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20id%20in%20title%20%2F%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2114164%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F955045%22%20target%3D%22_blank%22%3E%40wahlbang%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20show%20the%20unique%20article%20Title%20to%20users%20on%20list%20form%20(while%20creating%20new%20item%20in%20list%2Fbefore%20submitting%20new%20article)%2C%20you%20have%20to%20do%20that%20with%20Power%20Apps%20customized%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20if%20you%20want%20to%20create%20the%20unique%20article%20Title%20after%20item%20creation%20then%20you%20can%20use%20Power%20Automate.%20So%2C%20when%20user%20will%20create%20a%20new%20item%20in%20list%20they%20will%20not%20see%20the%20unique%20article%20title%20immediately.%20It%20will%20be%20updated%20and%20shown%20in%20list%20view%20after%20Power%20Automate%20flow%20completes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20you%20can%20choose%20between%20Power%20Apps%20or%20Power%20Automate%20based%20on%20your%20requirements%20and%20user%20understanding.%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2114092%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20id%20in%20title%20%2F%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2114092%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373269%22%20target%3D%22_blank%22%3E%40ganeshsanap%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20using%20Sharepoint%20online%20(Microsoft%20Lists)%2C%20so%20I%20guess%20either%20Power%20apps%20or%20Power%20automate%2C%20what%20would%20be%20the%20smartest%20to%20use%20here%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2113971%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20id%20in%20title%20%2F%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2113971%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F955045%22%20target%3D%22_blank%22%3E%40wahlbang%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhich%20version%20of%20SharePoint%20you%20are%20using%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20not%20possible%20using%20SharePoint%20out%20of%20the%20box%20capabilities.%20So%2C%20you%20will%20need%20custom%20solution%20for%20this.%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20will%20need%20to%20get%20the%20last%20SharePoint%20list%20item%20created%20and%20then%20use%20it%20as%20a%20reference%20to%20create%20Title%20of%20new%20item.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20using%20SharePoint%20server%20(classic)%20then%20you%20achieve%20this%20using%20JavaScript%20%26amp%3B%20REST%20API%20OR%20If%20you%20are%20using%20SharePoint%20Online%20then%20you%20can%20do%20this%20using%20Power%20Apps%20customized%20form%20or%20you%20can%20update%20list%20item%20with%20new%20Title%20using%20Power%20Automate%20after%20article%20creation.%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%26nbsp%3B%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%26nbsp%3B%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone,

I'm trying to create a knowledge database in Microsoft List / Sharepoint.
I would like when my colleagues creates and knowledge article the title gets an unique title / ID.

For exampel:
Title: KB0000001


And when the next person creates an article the title will be default be KB0000002 and so on and so on.
Think you get the point, but how do I do it? :face_with_rolling_eyes:

Any bright brains out here that can help me?

Best regards,

wahlbang

3 Replies

@wahlbang 

 

Which version of SharePoint you are using? 

 

This is not possible using SharePoint out of the box capabilities. So, you will need custom solution for this. 

You will need to get the last SharePoint list item created and then use it as a reference to create Title of new item.

 

If you are using SharePoint server (classic) then you achieve this using JavaScript & REST API OR If you are using SharePoint Online then you can do this using Power Apps customized form or you can update list item with new Title using Power Automate after article creation.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

@ganeshsanap 

I'm using Sharepoint online (Microsoft Lists), so I guess either Power apps or Power automate, what would be the smartest to use here?


@wahlbang 

If you want to show the unique article Title to users on list form (while creating new item in list/before submitting new article), you have to do that with Power Apps customized form.

 

Or if you want to create the unique article Title after item creation then you can use Power Automate. So, when user will create a new item in list they will not see the unique article title immediately. It will be updated and shown in list view after Power Automate flow completes.

 

Now, you can choose between Power Apps or Power Automate based on your requirements and user understanding.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.