Forum Discussion
Create new column from template
The best way is to use PowerShell
Here is the sample works for five columns with same choice. If you want it for more replace the value 5 in the for loop
############################Description########################
#Create new column with same choice
#############################################################
# Replace the values below with your own values
$siteUrl = "https://contoso.sharepoint.com/sites/SPDev"
$listName = "Custom List"
$choices = "Not Started","Pending","Completed"
# Connect to SharePoint Online
Connect-PnPOnline -Url $siteUrl -UseWebLogin
# Add five "Status" columns to the list with the specified values
for ($i=1; $i -le 5; $i++) {
$columnName = "Status$i"
Add-PnPField -List $listName -DisplayName $columnName -InternalName $columnName -Type Choice -Group "Demo Group" -AddToDefaultView -Choices $choices
}