need help-SharePoint online powershell to copy choice to managed metadata column

Question

can anyone please help me out with the PowerShell or any-other solution here.

I have a SharePoint library with 4000 documents and it has a choice column called "test". and each document is set with at least one choice using this column. We want to convert a choice column into a managed metadata filed. I created a column called "test-metadata" and mapped with Managed metadata which has all the term sets similar to choice filed names.

What I was thinking is that using PowerShell can we do something like, based upon choice column set to each file, tag the document with the term set value of the same name.

ex: document A has a choice column(test) with a choice called "Montreal" then a new managed metadata column(test-metadata) should be set with the "Montreal" term set.

Answer 1

Test Demo for you reference:

Install PnP PowerShell from here.

$SiteURL="https://xxxxx.sharepoint.com/sites/dev"
$ListName= "Doc"

#Connect to PNP Online
Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)

#sharepoint online pnp powershell get list items
$ListItems = Get-PnPListItem -List $ListName -Fields "Choice"

#Loop through each Item
foreach($ListItem in $ListItems)
{ 
if(!($ListItem["Choice"] -eq $null)){
    Write-Host "Title:" $ListItem["Choice"]
      #'testMetaData|test|' is your metadata tree structure, TermGroup|TermSet|Term
      $metadatapath = -join("testMetaData|test|", $ListItem["Choice"]);

      Set-PnPTaxonomyFieldValue -ListItem $ListItem -InternalFieldName 'test_x002d_metadata' -TermPath $metadatapath
      }
}

Here is the thread for you reference:

https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/set-pnptaxonomyfieldvalue?view=sharepoint-ps

Update:

Try below script:

$SiteURL="https://xxx.sharepoint.com/sites/dev"
$ListName= "Doc"

#Connect to PNP Online
Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)

#sharepoint online pnp powershell get list items
$ListItems = Get-PnPListItem -List $ListName -Fields "Choice"
$Array = New-Object System.Collections.ArrayList
#Loop through each Item
foreach($ListItem in $ListItems)
{ 
$results = @{}
if(!($ListItem["Choice"] -eq $null)){
    #Write-Host "Title:" $ListItem["Choice"]
      $option = [System.StringSplitOptions]::RemoveEmptyEntries

      $($ListItem["Choice"].split(' ',$option)).foreach{
      $metadatas = '';
      $value = ""+$_+"";
      $term= Get-PnPTerm -Identity $value -TermSet "test" -TermGroup "testMetaData";
      $Id = $term.Id;
      #$metadatas ='"' + $Id +'"'+ "=" +'"'+ $value + '"' ;
      #Write-Host $metadatas 
      $results.Add( $Id.ToString(),$value);

      }


      Set-PnPTaxonomyFieldValue -ListItem $ListItem  -InternalFieldName 'test_x002d_metadata'  -Terms  $results
      }
}