SOLVED

Issue with Column Default Value Settings

%3CLINGO-SUB%20id%3D%22lingo-sub-1176590%22%20slang%3D%22en-US%22%3EIssue%20with%20Column%20Default%20Value%20Settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176590%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20having%20an%20issue%20with%20Column%20Default%20Values%20in%20our%20Document%20Library.%3C%2FP%3E%3CP%3EThe%20Document%20Library%20is%20in%20a%20Modern%20Team%20Site%20within%20SharePoint%20Online.%20Also%20we%20are%20using%202%20different%20content%20types%20in%20our%20library.%20One%20folder%20and%20one%20document%20content%20type.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20can%20set%20the%20default%20values%20for%20folders%20within%20the%20library%20settings%2C%20however%20when%20we%20upload%20a%20document%20to%20the%20folder%20it%20does%20not%20apply%20the%20values%20to%20the%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20tried%20multiple%20file%20types%2C%20column%20types%20and%20libraries.%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20extremely%20grateful%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1176590%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1176886%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20Column%20Default%20Value%20Settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176886%22%20slang%3D%22en-US%22%3EIs%20that%20column%20with%20the%20default%20values%20applied%20to%20the%20Document%20content%20type%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1176910%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20Column%20Default%20Value%20Settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176910%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3EHi%20Chris.%20I%20have%20not%20turned%20on%20the%20Metadata%20and%20Navigation%20filtering%20feature%20in%20this%20instance%20so%20have%20not%20applied%20column%20default%20values%20at%20a%20content%20type%20level.%20I%20have%20tried%20this%20previously%20but%20it%20still%20did%20not%20work.%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20the%20document%20content%20type%20is%20the%20default%20content%20type%20for%20the%20library.%3C%2FP%3E%3CP%3EShould%20I%20enable%20the%20Metadata%20and%20Navigation%20filtering%20feature%20again%20and%20troubleshoot%20again%20from%20there%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1176950%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20Column%20Default%20Value%20Settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176950%22%20slang%3D%22en-US%22%3EYou%20shouldn%E2%80%99t%20need%20that%20feature.%20Can%20you%20screenshot%20your%20library%20settings%20column%20section%3F%20And%20or%20above%20that%20as%20well.%20Is%20there%20a%20content%20type%20section%20In%20library%20settings%3F%3CBR%20%2F%3E%3CBR%20%2F%3EWhere%20are%20you%20setting%20folder%20content%20type%20and%20or%20the%20default%20on%20the%20column%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178428%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20Column%20Default%20Value%20Settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178428%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20find%20below%20a%20screenshot%20of%20my%20library%20settings%20which%20shows%20the%202%20content%20types%20and%20also%20the%20columns.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22nmitchell20_1-1581980933785.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171559i565A07610A1B3859%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22nmitchell20_1-1581980933785.png%22%20alt%3D%22nmitchell20_1-1581980933785.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20following%20screenshot%20shows%20me%20assigning%20the%20default%20values%20in%20the%20library%20settings.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22nmitchell20_0-1581980912897.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171558i7DDAA058C8ECD690%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22nmitchell20_0-1581980912897.png%22%20alt%3D%22nmitchell20_0-1581980912897.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20whenever%20i%20drop%20a%20document%20into%20the%20folder%20within%20the%20library%2C%20the%20columns%20are%20not%20populated%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22nmitchell20_2-1581980975730.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171560i5B770809044D4A8C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22nmitchell20_2-1581980975730.png%22%20alt%3D%22nmitchell20_2-1581980975730.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20appreciate%20your%20help%20with%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178502%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20Column%20Default%20Value%20Settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178502%22%20slang%3D%22en-US%22%3EWhich.%20Column%20in%20the%20list%20has%20default%20value%20set%20and%20expected%20to%20populate%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178509%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20Column%20Default%20Value%20Settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178509%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3EAll%20of%20the%20ones%20highlighted%20yellow.%20The%20values%20are%20set%20to%20be%20different%20values%20at%20a%20folder%20level.%20each%20folders%20values%20will%20be%20specific%20and%20entered%20individually%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22nmitchell20_0-1581987344579.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171567iADBB70FA5810ECCC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22nmitchell20_0-1581987344579.png%22%20alt%3D%22nmitchell20_0-1581987344579.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178511%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20Column%20Default%20Value%20Settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178511%22%20slang%3D%22en-US%22%3EYeah%20content%20types%20don%E2%80%99t%20work%20Quite%20like%20that.%20What%20you%20are%20looking%20for%20is%20either%20a%20power%20automate%20flow%20to%20handle%20that%20tagging%20or%20I%20believe%20there%20is%20a%20content%20processor%20or%20something%20like%20that%20that%20can%20have%20rules%20setup%20for%20metadata.%20I%E2%80%99m%20out%20bowling%20right%20now%20so%20if%20I%20get%20a%20min%20when%20I%20get%20home%20to%20look%20that%20up%20I%20will!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178525%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20Column%20Default%20Value%20Settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178525%22%20slang%3D%22en-US%22%3E%3CP%3EOk%20thanks%20Chris.%20I%20appreciate%20your%20time.%3C%2FP%3E%3CP%3EIf%20not%20no%20worries%20though%2C%20I%20can%20find%20another%20way%20to%20achieve%20the%20same%20result%20I'm%20sure%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178606%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20Column%20Default%20Value%20Settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178606%22%20slang%3D%22en-US%22%3EI%20think%20what%20you%20are%20looking%20at%20doing%20might%20involved%20using%20Document%20Sets.%20You%20can%20basically%20set%20the%20%22Shared%20Columns%22%20option%20on%20a%20document%20set%2C%20that%20will%20share%20the%20metadata%20of%20the%20Document%20Set%20itself%20(Folder%20metadata%20essentially)%20that%20will%20pass%20on%20or%20be%20shared%20to%20the%20documents%20inside%20the%20document%20set.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FIntroduction-to-Document-Sets-3DBCD93E-0BED-46B7-B1BA-B31DE2BCD234%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FIntroduction-to-Document-Sets-3DBCD93E-0BED-46B7-B1BA-B31DE2BCD234%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ETons%20of%20video's%20on%20Youtube%20as%20well.%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fresults%3Fsearch_query%3Dsharepoint%2Bonline%2Bdocument%2Bsets%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fresults%3Fsearch_query%3Dsharepoint%2Bonline%2Bdocument%2Bsets%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EMight%20check%20that%20out%20see%20if%20it%20helps!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178613%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20Column%20Default%20Value%20Settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178613%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Chris%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

We are having an issue with Column Default Values in our Document Library.

The Document Library is in a Modern Team Site within SharePoint Online. Also we are using 2 different content types in our library. One folder and one document content type.

 

We can set the default values for folders within the library settings, however when we upload a document to the folder it does not apply the values to the columns.

 

Have tried multiple file types, column types and libraries.

Any help would be extremely grateful :)

 

10 Replies
Highlighted
Is that column with the default values applied to the Document content type?
Highlighted

@Chris WebbHi Chris. I have not turned on the Metadata and Navigation filtering feature in this instance so have not applied column default values at a content type level. I have tried this previously but it still did not work. 

Currently the document content type is the default content type for the library.

Should I enable the Metadata and Navigation filtering feature again and troubleshoot again from there?

Thanks

 

 

Highlighted
You shouldn’t need that feature. Can you screenshot your library settings column section? And or above that as well. Is there a content type section In library settings?

Where are you setting folder content type and or the default on the column?
Highlighted

@Chris Webb 

Please find below a screenshot of my library settings which shows the 2 content types and also the columns.

nmitchell20_1-1581980933785.png

 

 

The following screenshot shows me assigning the default values in the library settings.

nmitchell20_0-1581980912897.png

 

 

However whenever i drop a document into the folder within the library, the columns are not populated

nmitchell20_2-1581980975730.png

 

I really appreciate your help with this.

 

 

 

Highlighted
Which. Column in the list has default value set and expected to populate?
Highlighted

@Chris WebbAll of the ones highlighted yellow. The values are set to be different values at a folder level. each folders values will be specific and entered individually

nmitchell20_0-1581987344579.png

 

Highlighted
Yeah content types don’t work Quite like that. What you are looking for is either a power automate flow to handle that tagging or I believe there is a content processor or something like that that can have rules setup for metadata. I’m out bowling right now so if I get a min when I get home to look that up I will!
Highlighted

Ok thanks Chris. I appreciate your time.

If not no worries though, I can find another way to achieve the same result I'm sure

@Chris Webb 

Highlighted
Solution
I think what you are looking at doing might involved using Document Sets. You can basically set the "Shared Columns" option on a document set, that will share the metadata of the Document Set itself (Folder metadata essentially) that will pass on or be shared to the documents inside the document set.

https://support.office.com/en-us/article/Introduction-to-Document-Sets-3DBCD93E-0BED-46B7-B1BA-B31DE...

Tons of video's on Youtube as well. https://www.youtube.com/results?search_query=sharepoint+online+document+sets

Might check that out see if it helps!
Highlighted

Thanks Chris@Chris Webb