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.
Hi @Alison Howes , nothing out of the box to do this but here are some options:
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
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_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",
