Sharepoint List wont accept array from choices form

Questions
1

Hi Everyone,

im currently facing this issues for days, i already tried to fix it putting code node here and there but Sharepoint List still didnt want to accept the array

every naming on my form and list is 100% matched, so i dont know whats the issues here
Thanks!

{0916640A-0B68-48E8-92E8-E48560C9AE3C}
{0916640A-0B68-48E8-92E8-E48560C9AE3C}377×200 14.7 KB

{B7CB075F-EE17-4FC9-AE47-D3325A9045F3}
{B7CB075F-EE17-4FC9-AE47-D3325A9045F3}700×174 4.94 KB

2

@luminal0 sharepoint multi-choice columns wont take a plain array, graph needs the field tagged with an odata type next to the values and the n8n node doesnt add it, hence the 400. use an HTTP Request node to the graph list-items endpoint with it annotated:

{
  "fields": {
    "Pre-construction & Permits@odata.type": "Collection(Edm.String)",
    "Pre-construction & Permits": {{ $json['Pre-construction & Permits'] }}
  }
}

heads up, graph wants the columns INTERNAL name not the display name (the - and & get encoded), so if it still 400s grab that from the column settings and use it on both lines.

3

I was using the official sharepoint node from the n8n

I’ve tried both of the option that you mentioned including changing it to internal name but it still gave me 400s

4

@luminal0 the internal name is probably the catch. sharepoint hex-encodes spaces and symbols, so the real name for “Pre-construction & Permitting” has x0020 for each space and x0026 for the &, nothing like the display name, and a guessed one still 400s. dont type it out, do GET /sites/{site}/lists/{list}/columns and copy the exact “name” value into your patch. if it still fails after that, paste the exact body youre sending and ill spot it.