Power Platform Community Forum Thread Details

I have a Dataverse table with several Choice columns. Single-select Choice columns work correctly.
Multi-select Choice columns:
Project Engagement
Process Workflow
Secondary Project Type

All have "Selecting multiple choices is allowed" enabled.

The values are:
Project Engagement:
FEAS = 965810000
EVAL = 965810001
COMP = 965810002
NEWB = 965810003
REN = 965810004
EXP = 965810005
FIT = 965810006
TEMP = 965810007
STUD = 965810008

I am using Power Automate with:

1. HTTP action
2. Parse JSON
3. Dataverse "Add a new row" (and also tested "Update a row")

Single-select fields such as Sector and Primary Project Type save successfully.

For multi-select fields I receive:

"Edm Object passed should have the options selected."

I have tried:
Sending comma-separated values
Sending arrays of integers
Sending arrays of strings
Using Add Row
Using Update Row

What is the correct JSON payload format for a Dataverse multi-select Choice column when using Power Automate?

For example, if I want:
NEWB (965810003)
FEAS (965810000)

Should the payload be:

[965810003,965810000]
or
["965810003","965810000"]
or
"965810003,965810000"

or an EDM object structure?

In Power Automate, what expression should be placed in the field for a multi-select Choice column?

Are there any special requirements when the Choice column is synced to a Global Choice?

{
"type": "object",
"properties": {
"dataverse_payload": {
"type": "object",
"properties": {
"Process Workflow": {
"type": "array",
"items": {
"type": "integer"
}
},
"Project Engagement": {
"type": "array",
"items": {
"type": "integer"
}
},
"Secondary Project Types": {
"type": "array",
"items": {
"type": "integer"
}
},
"Primary Project Type": {
"type": "integer"
},
"Sector": {
"type": "integer"
}
}
}
}
}

{
"dataverse_payload": {
"Process Workflow": [965810001, 965810000],
"Project Engagement": [965810003],
"Secondary Project Types": [],
"Primary Project Type": 965810009,
"Sector": 965810000
}
}
If I leave the multi-select fields blank, the row is created successfully. The failure happens only when I populate the multi-select Choice fields.
I also tested typing/selecting one value manually in the Update Row action, but the designer UI appears as a dropdown and does not clearly allow multiple selections.