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%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%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
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 :)

 

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

@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

 

 

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?

@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.

 

 

 

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

@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

 

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!

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 

best response confirmed by nmitchell20 (Occasional Contributor)
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!

Thanks Chris@Chris Webb 

@nmitchell20 Did you ever resolve this?  We do this every day and update many columns for each document that is added to a folder. I also noticed that your sources for the default value are all over the place and when I look at my settings, they are all sourced to the document library. How did you set up your default values?  Did you use a term set or set them up in library settings via the default column value menu? 

Rippy79_0-1632366186502.png

 

@Rippy79 I ended up using document sets for this as I couldn't get it working with folders.