Auto Generate Sequential Project Numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-2169364%22%20slang%3D%22en-US%22%3EAuto%20Generate%20Sequential%20Project%20Numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2169364%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Community%2C%3C%2FP%3E%3CP%3EFairly%20new%20SharePoint%20user%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20one%20list%20called%20(Master%20Clients)%20which%20includes%20the%20client%20name%20(Client%20Name)%2C%20and%20a%20unique%20three%20digit%20prefix%20number%20(Client%20Number)%20for%20each%20client%2Fitem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20second%20list%20(Project%20List)%20which%20when%20new%20items%20are%20entered%2C%20uses%20the%20%22Look%20up%22%20function%20to%20select%20the%20%22Client%20Name%22%20and%20it%20also%20adds%20the%20%22Client%20Number%22%20(prefix)%20to%20the%20list.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProject%20numbers%20are%20generated%20by%20adding%20the%20%22Client%20Number%22%20and%20then%20the%20next%20number%20in%20line%20for%20that%20specific%20project.%20For%20example%3A%20321%20001%2C%20321%20002%2C%20321%20003%20and%20so%20on%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20client%20has%20a%20unique%20prefix%20%22Client%20Number%22%20and%20then%20a%20project%20number.%20So%20a%20different%20client%20project%20would%20look%20like%20this%3A%20123%20001%2C%20123%20002%20and%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20ask%20if%20its%20possible%20(and%20learn%20how%20to%20do%20it)%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Auto%20generate%20a%20sequential%20%22Project%20Number%22%20for%20each%20specific%20client.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIdeally%2C%20when%20adding%20a%20new%20item%20in%20the%20%22Project%20List%22%20and%20selecting%20the%20%22Client%20Name%22%20from%20the%20Look%20up%20drop%20down%2C%20it%20would%20automatically%20create%20the%20next%20sequential%20%22Project%20Number%22%20specific%20for%20that%20client%2Fprefix%20number.%20For%20example%2C%20it%20would%20read%20like%20this%3A%20%22321001%22.%20Then%20the%20next%20project%2Fitem%20I%20add%20to%20the%20%22Project%20List%22%20for%20that%20client%20in%20this%20example%20would%20auto%20generate%20%22321002%22%20and%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20would%20be%20the%20best%20set%20up%20for%20the%20SharePoint%20list(s)%20for%20such%20an%20solution.%3C%2FP%3E%3CP%3EWould%20I%20need%20a%20separate%20list%20for%20each%20client%2C%20listed%20by%20project%20and%20then%20do%20another%20lookup%20based%20on%20the%20last%20project%20number%20added.%20I%20feel%20like%20this%20could%20be%20list%20overload%20if%20there%20are%20lots%20of%20clients.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20has%20any%20suggestions%20for%20the%20set%20up%20of%20the%20list(s)%20that%20would%20make%20such%20a%20solution%20easier%20to%20work%20out%2C%20I%20would%20love%20to%20hear%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20time%20and%20guidance.%3C%2FP%3E%3CP%3EA%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2169364%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2169518%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Generate%20Sequential%20Project%20Numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2169518%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F980022%22%20target%3D%22_blank%22%3E%40hello_a_r%3C%2FA%3E%26nbsp%3Bthis%20isn't%20do-able%20in%20SharePoint%20on%20its%20own%20but%20would%20need%20a%20flow%20in%20Power%20Automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2169526%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Generate%20Sequential%20Project%20Numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2169526%22%20slang%3D%22en-US%22%3EThank%20you%2C%20I%20am%20researching%20this%20now.%3CBR%20%2F%3EWould%20you%20suggest%20a%20centralized%20list%20for%20all%20project%20numbers%20associated%20with%20prefix%20numbers%20which%20are%20auto%20generated%20and%20then%20assigned%20to%20projects.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello Community,

Fairly new SharePoint user here.

 

I have one list called (Master Clients) which includes the client name (Client Name), and a unique three digit prefix number (Client Number) for each client/item.

 

I have a second list (Project List) which when new items are entered, uses the "Look up" function to select the "Client Name" and it also adds the "Client Number" (prefix) to the list. 

 

Project numbers are generated by adding the "Client Number" and then the next number in line for that specific project. For example: 321 001, 321 002, 321 003 and so on

 

Each client has a unique prefix "Client Number" and then a project number. So a different client project would look like this: 123 001, 123 002 and so on.

 

I would like to ask if its possible (and learn how to do it) the following:

 

1. Auto generate a sequential "Project Number" for each specific client. 

 

Ideally, when adding a new item in the "Project List" and selecting the "Client Name" from the Look up drop down, it would automatically create the next sequential "Project Number" specific for that client/prefix number. For example, it would read like this: "321001". Then the next project/item I add to the "Project List" for that client in this example would auto generate "321002" and so on.

 

What would be the best set up for the SharePoint list(s) for such an solution.

Would I need a separate list for each client, listed by project and then do another lookup based on the last project number added. I feel like this could be list overload if there are lots of clients.

 

If anyone has any suggestions for the set up of the list(s) that would make such a solution easier to work out, I would love to hear them.

 

Thank you for your time and guidance.

2 Replies

@hello_a_r this isn't do-able in SharePoint on its own but would need a flow in Power Automate.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Thank you, I am researching this now.
Would you suggest a centralized list for all project numbers associated with prefix numbers which are auto generated and then assigned to projects.