SharePoint Online list column default Value Setting

Navas Shereef 141

Hi all,

I am trying to set column default value for folder(Note: not using column customization) by using column default value setting in document library setting. I am trying to set multi-select value as default value for a folder. Since I can find only default value as text, I am unable to set multi-value. Anyone have solution for this?

sadomovalex 3,631 Reputation points

2022-01-10T15:08:00.303+00:00

as an idea (didn't tried by myself): create custom content type inherited from folder, add needed field there (Country), define default value for field on content type level and use this content type for folders
Navas Shereef 141 Reputation points

2022-01-10T15:49:10.72+00:00

Thanks for your suggestion but I have more than 40 different folders. I need to set different valur for different folders.
Turbo Beagle 0 Reputation points

2023-04-28T19:16:46.5933333+00:00

I used Microsoft Flow to do this:

SharePoint - when a new item is created

SharePoint - update item

Accepted answer

Allen Xu_MSFT 13,831 Reputation points

2022-01-11T06:30:53.607+00:00
Hi @Navas Shereef ,

Use this PnP PowerShell command to set it:

Set-PnPDefaultColumnValues -List <ListPipeBind> -Field <FieldPipeBind> -value <String[]> -folder <String>

Example1:

Set-PnPDefaultColumnValues -List Documents -Field testchoice -value "A","#B","#C" -folder "testFolder"

Example2:

Set-PnPDefaultColumnValues -List Documents -Field testchoice -value "A","#B" -folder "testFolder"

----------

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

1 person found this answer helpful.
Navas Shereef 141 Reputation points

2022-01-11T09:06:10.063+00:00

Thanks, AllenXu. I believe that it will work. I will test.

Navas Shereef 141 Reputation points

2022-01-11T09:20:26.143+00:00

Thanks again, AllenXu. I thought that only solution is updating using power automate. You saved lot of time.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

Harshal Gite 1 Reputation point

2022-01-10T14:19:24.213+00:00

You can just enter the text of the choice you want to set as default.
Not: Only a single choice can be set as default even if the column is of multi-value type.
Please sign in to rate this answer.
Navas Shereef 141 Reputation points

2022-01-10T15:52:09.587+00:00

Thanks for suggestion. But I need to set different values for different folders. In order to achieve that we need to go to library settings---> column default value setting(not by selecting the column and setting default value). The problem is I am unable to set mult-value as default value.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SharePoint Online list column default Value Setting

1 additional answer

Your answer