Forum Discussion

Iron Contributor

Jul 27, 2017

Add-PnPFile adding column value where column name contains a spoace

Hi I am trying to add a file to a library using Add-PnPFile. One of the columns in the content type of the file is called Business Unit and its a Taxonomy column. So I used in the Add-PnP...

Manidurai Mohanamariappan

Iron Contributor

Jul 28, 2017

Hi,

You need to use Guid value of terms and you can find the guid value from site setting -->site administration -->term srore management --> terms set-->terms -->Unique Identifier

Example:

add-pnpfile -path C:\test.csv -values @{jobname="33e7276f-f7ae-4629-9a72-9b5a4b573f38"}

Nigel_Price9911
Iron Contributor
Jul 28, 2017
Hi Manidurai Mohanamariappan

The documentation says you can do this :-

Managed Metadata (single value with path to term): -Values @{"MetadataField" = "CORPORATE|DEPARTMENTS|FINANCE"}

I have added this to the PnP PowerShell list of issues.

Regards

Nigel
- Nigel_Price9911
  Iron Contributor
  Jul 28, 2017
  Hi Manidurai Mohanamariappan
  
  It looks as if Set-ListItem has been updated to handle Paths as well as GUIDs but Add-PnPFile has not.
  @Wobba @ErwinVanHunen.
  
  Regards
  
  Nigel
  - Manidurai Mohanamariappan
    Iron Contributor
    Jul 28, 2017
    Yes, your correct set-pnplistitem supports both path and guid but douctment only available for set-pnplistitem and not for add-pnpfile. and i guess managed metadata path supported recently.so it will updated soon to add-pnpfile.