List of project documents in a library

%3CLINGO-SUB%20id%3D%22lingo-sub-2350405%22%20slang%3D%22en-US%22%3EList%20of%20project%20documents%20in%20a%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2350405%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20populate%20a%20SharePoint%20List%20field%20with%20a%20list%20of%20project%20documents%20from%20a%20library.%26nbsp%3B%20Each%20time%20a%20document%20is%20added%20to%20the%20library%20and%20assigned%20to%20a%20project%20the%20list%20item%20for%20that%20project%20is%20updated.%26nbsp%3B%20Basically%20I%20have%20a%20list%20of%20projects%20for%20approval%2C%20one%20row%20per%20project.%26nbsp%3B%20There%20is%20a%20button%20with%20an%20approval%20flow%20attached.%26nbsp%3B%20I%20need%20to%20build%20a%20condition%20that%20a%20minimum%20set%20of%203%20documents%20needs%20to%20be%20present%20before%20the%20button%20appears%3A%20Business%20case%2C%20Finance%20report%20and%20Project%20Charter.%26nbsp%3B%20There%20is%20a%20content%20type%20for%20the%20documents%2C%20one%20of%20the%20fields%20is%20a%20drop-down%20with%20the%20above%20document%20Types%20as%20well%20as%20others.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20approval%20flow%20with%20a%20filtered%20link%20on%20the%20project%20ID%20number%20to%20the%20project%20library%20that%20works%20well%20so%20want%20to%20see%20if%20I%20can%20use%20that%20but%20I%20just%20need%20a%20list%20of%20the%20document%20types.%26nbsp%3B%20They%20don't%20need%20to%20be%20hyperlinks%20to%20the%20document%2C%20just%20the%20document%20types%20in%20plain%20text.%26nbsp%3B%20Not%20sure%20of%20the%20best%20way%20to%20do%20this%3A%26nbsp%3B%20JSON%20formatting%2C%20SP%20formula%20or%20a%20flow%3F%26nbsp%3B%20Any%20ideas%20welcome.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2350405%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFlow%20Buttons%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EJSON%20formatting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Elist%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senior Member

Good morning.  

I am trying to populate a SharePoint List field with a list of project documents from a library.  Each time a document is added to the library and assigned to a project the list item for that project is updated.  Basically I have a list of projects for approval, one row per project.  There is a button with an approval flow attached.  I need to build a condition that a minimum set of 3 documents needs to be present before the button appears: Business case, Finance report and Project Charter.  There is a content type for the documents, one of the fields is a drop-down with the above document Types as well as others.

 

I have an approval flow with a filtered link on the project ID number to the project library that works well so want to see if I can use that but I just need a list of the document types.  They don't need to be hyperlinks to the document, just the document types in plain text.  Not sure of the best way to do this:  JSON formatting, SP formula or a flow?  Any ideas welcome. 

0 Replies