How to use set-pnplistitem if columns have spaces?

Question

How to use set-pnplistitem if columns have spaces?

Steve Wright 81

I am trying to use Set-PnPListItem to set a column (metadata) value but it doesn't work if the column name has a space in it. I have seen some very old posts that say to remove the spaces from the field name but keep them for the display name, but I've no idea how to do that.

Is there a proper way to handle columns with spaces in the names or must I really remove them?

BTW, I was using the "Set metadata of an existing file" example here as my reference.

JoyZ 18,111 Reputation points

2020-08-28T10:21:02.227+00:00

Hi @Steve Wright ,

Is there any progress on this issue?

Please feel free to reply.
JoyZ 18,111 Reputation points

2020-09-01T01:30:58.073+00:00

Hi @Steve Wright ,

If you feel an answer works for you, please kindly accept it as answer.

It will be beneficial to other community members reading this thread.

Thank you for your understanding.
JoyZ 18,111 Reputation points

2020-09-11T01:40:10.93+00:00

Hi @Steve Wright ,

If you find any answer helpful to you, please remember to accept it as answer.

Thank you for your understanding.

1 answer

Your answer

JoyZ 18,111 Reputation points

2020-08-28T10:21:02.227+00:00

Hi @Steve Wright ,

Is there any progress on this issue?

Please feel free to reply.
JoyZ 18,111 Reputation points

2020-09-01T01:30:58.073+00:00

Hi @Steve Wright ,

If you feel an answer works for you, please kindly accept it as answer.

It will be beneficial to other community members reading this thread.

Thank you for your understanding.
JoyZ 18,111 Reputation points

2020-09-11T01:40:10.93+00:00

Hi @Steve Wright ,

If you find any answer helpful to you, please remember to accept it as answer.

Thank you for your understanding.

Answer 1

JoyZ 18,111

PLease use the internal name of field.

Go to list settings> click on the column and get its internal name in address bar as shown below:

References:

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

https://plumsail.com/docs/help-desk-o365/v1.x/How%20To/Find%20the%20internal%20name%20of%20SharePoint%20column.html

If the response is helpful, please click "Accept Answer" and upvote it.

Share via

How to use set-pnplistitem if columns have spaces?

1 answer

Your answer