I'm trying to export an SPO list into CSV, which is working fine for Single line of text fields, however, when trying to export a managed metadata field, I'm getting the following appear in the CSV for the column:


The script I am using is from this website http://www.sharepointdiary.com/2016/03/export-list-items-to-csv-in-sharepoint-online-using-powershell.html.

How can I modify the script to show the value of the managed metadata field?



Found the answer. For anyone else looking:

[Microsoft.SharePoint.Client.Taxonomy.TaxonomyFieldValue]$Value = $_["FieldName"]

$ExportItem | Add-Member -MemberType NoteProperty -Name "Field Label" -value $Value.label
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.