Assign default value to column in SharePoint library using powershell

Question

I am writing a script for assigning the default value of a column in SharePoint library:

$spFieldType = [Microsoft.SharePoint.SPFieldType]::Text
$sList.Fields.Add("OpCoNam",$spFieldType,$true)
$sList.Fields["OpCoNa"].DefaultValue="$sList.Title"
$sList.Update()

But no value is getting added.

Amal Hashim · Accepted Answer · 2015-03-20 12:56:56Z

1

You should update the field as below

$spFieldType = [Microsoft.SharePoint.SPFieldType]::Text
$sList.Fields.Add("OpCoNam",$spFieldType,$true)
$sList.Update()

$f = $sList.Fields["OpCoNam"]
$f.DefaultValue = "DefaultValue"
$f.Update()

answered Mar 20, 2015 at 12:56

Amal Hashim

28.4k5 gold badges33 silver badges61 bronze badges

Amal: thanks it is working but the column created is a mandatory value column. Any way to make it non-mandatory?

Aquarius24
– Aquarius24

2015-03-20 14:04:33 +00:00
Commented Mar 20, 2015 at 14:04
1

Yes, pass $false to Add method

Amal Hashim
– Amal Hashim

2015-03-20 14:05:18 +00:00
Commented Mar 20, 2015 at 14:05

Add a comment |

Stack Exchange Network

Assign default value to column in SharePoint library using powershell

1 Answer 1

Your Answer

Hot Network Questions

Assign default value to column in SharePoint library using powershell

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions