Populate metadata information using a CSV in PowerShell
It's not possible to fill metadata information from a CSV file in PowerShell. Currently, it needs to be done in two steps using an Excel file extracted from the UI. When you have multiple lists or multiple sites to do, it's not a practical solution
Anisha Antony commented
We have a query in Fileshare to Office365 migration using Sharegate Powershell API.
We are planning to map some of the file share folders to SharePoint Online Document libraries. But in SharePoint Document library, we have some custom meta data columns other than the standard out-of-the-box columns. We understood that we can manually set custom values for these metadata columns via ShareGate UI ( Options->MetaData->Document->Set Custom Value by selecting respective meta data column).
But we will be executing the File Share to SharePoint Online migration using PowerShell leveraging ShareGate APIs. All the input parameters will be specified in a .csv file by which the PowerShell can read them and process the migration.
Will ShareGate PowerShell support reading meta data column values from CSV? If yes, what is the equivalent ShareGate API that we need to use in PowerShell to set custom values for meta data columns?
If no, please let us know the possible ways to update metadata column values using sharegate powershell API.