Create SharePoint Online list columns using powershell

Question

Create SharePoint Online list columns using powershell

SR VSP 1,251

Hello,

I want to create a SharePoint Online list having 50 columns with different datatypes like Text, Choice, Multi Text, Lookup... can you advise if any PowerShell script to create this columns ?

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Hi @SR VSP ,

Long time no see, how are you?

Please run the below PnP PowerShell script as an admin. It's worth noting, don't create more than 12 Lookup columns(fields) in the same list.

#Config Variables  
$SiteURL = "https://domain.sharepoint.com/sites/sitename"  
$ListName= "ListNameA"  
$ParentListName="ListNameB"  
   
#Connect to PnP Online  
Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)  
#Get the ID of the Parent List  
$LookupListID = (Get-PnPList -Identity $ParentListName).ID  
   
#Define XML Schema for Text Field  
$ProjectCodeFieldXML= "<Field Type='Text' Name='ProjectCode' ID='$([GUID]::NewGuid())' DisplayName='Project Code' Required ='FALSE' EnforceUniqueValues = 'TRUE' Indexed='TRUE'></Field>"  
   
#Define XML Schema for Multiline Text Field  
$ProjectDescriptionFieldXML= "<Field Type='Note' Name='ProjectDescription' ID='$([GUID]::NewGuid())' DisplayName='Project Description' Required ='FALSE' RichText='TRUE' RichTextMode='FullHtml' ></Field>"  
  
#Define XML Schema for Choice Field  
$PriorityFieldXML= "<Field Type='Choice' Name='Priority' ID='$([GUID]::NewGuid())' DisplayName='Priority'>  
                 <CHOICES>  
                      <CHOICE>(1) High</CHOICE>  
                      <CHOICE>(2) Normal</CHOICE>  
                      <CHOICE>(3) Low</CHOICE>  
                </CHOICES>  
                <Default>(2) Normal</Default>  
            </Field>"  
  
  
#Define XML Schema for Lookup Field  
$ParentProjectFieldXML= "<Field Type='Lookup' Name='ParentProject' ID='$([GUID]::NewGuid())' DisplayName='Parent Project' List='$LookupListID' ShowField='Title'></Field>"  
   
#Add Text Field to list from XML  
Add-PnPFieldFromXml -FieldXml $ProjectCodeFieldXML -List $ListName   
  
#Add Multiline Text Field to list from XML  
Add-PnPFieldFromXml -FieldXml $ProjectDescriptionFieldXML -List $ListName  
  
#Add Choice Field to list from XML  
Add-PnPFieldFromXml -FieldXml $PriorityFieldXML -List $ListName  
  
#Add Lookup Field to list  
Add-PnPFieldFromXml -FieldXml $ParentProjectFieldXML -List $ListName

Here is my test:

Thanks,
Echo Du

======================================

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.

SR VSP 1,251 Reputation points

2022-02-22T07:07:38.497+00:00

Thank you so much Echo as always.

Yes i was busy with some new project in PowerApps for the past few months. And now back here again.

Have a question why we need 2 lists here ? and if i don't want to create any lookup columns can i still run the same script ?

$ListName= "ListNameA"
$ParentListName="ListNameB"
Echo Du_MSFT 17,341 Reputation points

2022-02-22T07:54:52.373+00:00

Hi @SR VSP ,

If you don't want to create a Lookup column then you can delete or hide the following commands

Note: '#' is a comment for a PowerShell script language

#$ParentListName=" ListNameB" #Define XML Schema for Lookup Field #$ParentProjectFieldXML= "<Field Type='Lookup' Name='ParentProject' ID='$([GUID]::NewGuid())' DisplayName='Parent Project' List='$LookupListID' ShowField='Title'></Field>" #Add Lookup Field to list #Add-PnPFieldFromXml -FieldXml $ParentProjectFieldXML -List $ListName

Thanks,
Echo Du
Echo Du_MSFT 17,341 Reputation points

2022-02-28T10:13:48.103+00:00

Hi @SR VSP ,

Is there anything else I can help with regarding this issue?

You can comment us at any time and we will continue to follow up.

Thanks,
Echo Du
SR VSP 1,251 Reputation points

2022-03-02T01:27:43.507+00:00

Thank you so much Echo. It worked like a magic.

And what is $ParentListName="ListNameB" ?
SR VSP 1,251 Reputation points

2022-03-02T04:00:26.273+00:00

Also how to create multiple columns with the same datatype using this scrript ? like Ex: 10 different columns with same Type "Single Text"

Share via

Create SharePoint Online list columns using powershell

0 additional answers

Your answer