How to reference a list of projects from within a Project Site

%3CLINGO-SUB%20id%3D%22lingo-sub-2047140%22%20slang%3D%22en-US%22%3EHow%20to%20reference%20a%20list%20of%20projects%20from%20within%20a%20Project%20Site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2047140%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20hoping%20someone%20can%20help%20me%20out.%20I%20want%20to%20create%20a%20Project%20Site%20template%20(which%20I%20know%20how%20to%20do).%20But%20within%20this%20Site%20Template%20will%20be%20a%20custom%20list%20and%20I%20want%20to%20be%20able%20to%20select%20from%20a%20list%20of%20existing%20published%20projects%20in%20this%20list.%20In%20this%20way%20it%20would%20be%20possible%20to%20select%20a%20project%20and%20add%20notes%20to%20the%20list%26nbsp%3B%20to%20indicate%20the%20relationship%20between%20the%20current%20project%20and%20any%20other%20projects%20within%20the%20PWA%20instance.%26nbsp%3B%20I%20know%20how%20to%20create%20a%20list%2C%20but%20I%20haven't%20found%20a%20way%20to%20add%20a%20list%20of%20projects%20to%20a%20SharePoint%20list%20in%20the%20project%20site%2Fsite%20template.%26nbsp%3B%20Any%20advice%20around%20a%20solution%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThank%20you!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlison%3CBR%20%2F%3E%3CBR%20%2F%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2047236%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20reference%20a%20list%20of%20projects%20from%20within%20a%20Project%20Site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2047236%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F176520%22%20target%3D%22_blank%22%3E%40Alison%20Howes%3C%2FA%3E%26nbsp%3B%2C%20nothing%20out%20of%20the%20box%20to%20do%20this%20but%20here%20are%20some%20options%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3ECreate%20a%20new%20choice%20column%20at%20as%20a%20site%20column%20and%20manually%20maintain%20the%20choice%20options%20centrally%20then%20use%20this%20site%20column%20on%20the%20list%20in%20the%20Project%20Sites%3C%2FLI%3E%0A%3CLI%3EHave%20a%20central%20list%20called%20%22Projects%22%20for%20example%20with%20a%20column%20for%20Project%20Name%20and%20maybe%20Project%20ID.%20Have%20a%20Power%20Automate%20flow%20run%20that%20will%20keep%20the%20central%20list%20updated%20with%20the%20new%20Projects%20added%20to%20Project%20Online.%20Then%20on%20the%20Project%20Sites%2C%20have%20a%20new%20list%20that%20has%20a%20look%20up%20column%20to%20the%20central%20%22Projects%22%20list.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3EThere%20are%20more%20options%20but%20these%20are%20the%20simpler%20ones%20I%20can%20think%20of%20currently.%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2047945%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20reference%20a%20list%20of%20projects%20from%20within%20a%20Project%20Site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2047945%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8793%22%20target%3D%22_blank%22%3E%40Paul%20Mather%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EHi%20Paul%2C%20Thanks%20so%20much.%26nbsp%3B%20In%20respect%20of%20your%20comment...%3CBR%20%2F%3E%22T%3CSPAN%3Ehen%20on%20the%20Project%20Sites%2C%20have%20a%20new%20list%20that%20has%20a%20look%20up%20column%20to%20the%20central%20%22Projects%22%20list%22%2C%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EHow%20exactly%20do%20I%20do%20this%20%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CBR%20%2F%3EAlison%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

I'm hoping someone can help me out. I want to create a Project Site template (which I know how to do). But within this Site Template will be a custom list and I want to be able to select from a list of existing published projects in this list. In this way it would be possible to select a project and add notes to the list  to indicate the relationship between the current project and any other projects within the PWA instance.  I know how to create a list, but I haven't found a way to add a list of projects to a SharePoint list in the project site/site template.  Any advice around a solution would be greatly appreciated.


Thank you! 

 

Alison

 

5 Replies

Hi @Alison Howes , nothing out of the box to do this but here are some options:

  1. Create a new choice column at as a site column and manually maintain the choice options centrally then use this site column on the list in the Project Sites
  2. Have a central list called "Projects" for example with a column for Project Name and maybe Project ID. Have a Power Automate flow run that will keep the central list updated with the new Projects added to Project Online. Then on the Project Sites, have a new list that has a look up column to the central "Projects" list.

There are more options but these are the simpler ones I can think of currently.

Paul

@Paul Mather 
Hi Paul, Thanks so much.  In respect of your comment...
"Then on the Project Sites, have a new list that has a look up column to the central "Projects" list",

How exactly do I do this ?

Thanks


Alison

@Paul Mather 

Hi Paul, 

Thank you. I'm unclear on what you mean by "centrally" in your comment  "manually maintain the choice options centrally" - could you clarify please ?

Thanks

Alison

Hi @Alison Howes ,

Just a site collection choice site column created in PWA.

Paul

@Paul Mather 

Hmmm, OK Thanks Paul,

 

I need to investigate this further. Thanks for the steer. 

 

Alison