Power Platform Community Forum Thread Details

Im trying to create a SharePoint list item from Copilot Studio using the native SharePoint “Create item” connector, and I’m unable to reliably populate a multi‑select choice column.
Every approach I’ve tried either:

silently writes a blank value, or
throws a HTTP 400 (ConnectorRequestFailure)

Setup

Copilot Studio → Topic → Tool (SharePoint “Create item”)
SharePoint column:
- Type: Choice
- Allow multiple selections = Yes
- Options: Software tool, Hybrid, Manual

In the tool, the field appears as
CurrentSolutionType (Table)

Approaches tried

"Manual"
["Manual"]
{ Value: "Manual" }
Table({ Value: "Manual" })
[
{ "Value": "Manual" }
]

Outcome

At the moment:

I have not found a way to successfully populate a multi-select choice field directly from Copilot Studio
The only working workaround appears to be:
- sending values via Power Automate
- transforming them using a Select action before writing to SharePoint

But I’d rather not create additional steps for something that should be straightforward.

Has anyone successfully:

written to a multi-select choice column
using Copilot Studio SharePoint connector (Create item) directly
without using Power Automate?

Or is this a known limitation of the connector/tooling?

Categories:

Calling actions from Copilot Studio

@Rob-Air

The native SharePoint Create Item connector in Copilot Studio simply does not support multi-select choice columns reliably. Every format you tried was logically correct, but the connector cannot serialise multi-value table input properly when sending to SharePoint, which is why you keep hitting the 400 error.

The Power Automate route is the right fix for now. Pass your values into a flow, use a Select action to format the array correctly, then write to SharePoint from there. It is an extra step but it is the only reliable path until Microsoft closes this gap in the native connector.

Worth raising it on the Power Platform Ideas board — it helps Microsoft prioritise the fix.

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥