SOLVED

Use project data in Project SharePoint Site Lists

%3CLINGO-SUB%20id%3D%22lingo-sub-2621334%22%20slang%3D%22en-US%22%3EUse%20project%20data%20in%20Project%20SharePoint%20Site%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2621334%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%20I'm%20building%20a%20site%20template%20for%20use%20with%20Project%20Online.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20set%20up%20a%20list%20of%20meetings%20based%20on%20a%20custom%20content%20type%20%22Change%20Meeting%22%20with%20the%20following%20columns%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Meeting%20Type%20(Choice%3A%20Board%2C%20Steering%2C%20Working%20Group)%3C%2FP%3E%3CP%3E2.%20Meeting%20Date%20(Date)%3C%2FP%3E%3CP%3E3.%20Project%20Name%20(Prefilled%20from%20the%20associated%20project's%20data)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20then%20pull%20OData%20across%20all%20the%20project%20sites%20to%20create%20portfolio%20governance%20reports.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1%20and%202%20are%20straight%20forward%20but%20I%20cannot%20figure%20out%20how%20to%20access%20the%20project%20name%20(or%20any%20other%20project%20field).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20only%20limited%20experience%20with%20SharePoint%20and%20would%20appreciate%20your%20suggestions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EJames.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2621334%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOnline%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2621762%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20project%20data%20in%20Project%20SharePoint%20Site%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2621762%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1027394%22%20target%3D%22_blank%22%3E%40Jamsie%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EThere%20is%20no%20out%20of%20the%20box%20option%20for%20point%203%2C%20you%20might%20be%20able%20to%20use%20the%20BCS%20in%20SharePoint%20Online%20to%20build%20a%20solution%20that%20queries%20the%20Project%20Online%20APIs%20to%20get%20the%20Project%20Names%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fmanage-business-connectivity-service-applications%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fmanage-business-connectivity-service-applications%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2621929%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20project%20data%20in%20Project%20SharePoint%20Site%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2621929%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%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20advice.%26nbsp%3B%20This%20is%20a%20new%20are%20for%20so%20I'll%20study%20the%20docs.%20I%20guess%20my%20other%20option%20is%20to%20infer%20the%20name%20on%20the%20reporting%20side%20using%20some%20manual%20tie%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3EJames.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,  I'm building a site template for use with Project Online.  

 

I would like to set up a list of meetings based on a custom content type "Change Meeting" with the following columns:

 

1. Meeting Type (Choice: Board, Steering, Working Group)

2. Meeting Date (Date)

3. Project Name (Prefilled from the associated project's data)

 

I would then pull OData across all the project sites to create portfolio governance reports.

 

1 and 2 are straight forward but I cannot figure out how to access the project name (or any other project field).

 

I've only limited experience with SharePoint and would appreciate your suggestions.

 

Thanks,

James.

 

 

3 Replies
best response confirmed by Jamsie (New Contributor)
Solution

Hello @Jamsie ,

There is no out of the box option for point 3, you might be able to use the BCS in SharePoint Online to build a solution that queries the Project Online APIs to get the Project Names:

https://docs.microsoft.com/en-us/sharepoint/manage-business-connectivity-service-applications 

Paul

@Paul Mather 

 

Thanks for the advice.  This is a new are for so I'll study the docs. I guess my other option is to infer the name on the reporting side using some manual tie up.

 

Cheers,

James.

Hello @Jamsie ,

If that is the reason to do it for reporting, then yes, you can grab the Project GUID from the SharePoint web property bag and use that GUID to join the data to the Project data and get the Project Name that way in your reports.

Paul