Send an HTTP request to SharePoint - Multiple Choice Column

(0) Share

Report

Posted on by greddin1

Hi all,

I'm having an issue I can't figure out while sending an HTTP request to SharePoint to create a list item.

The error is:

"status": 400,
 "message": "An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartArray' node was expected.

Here is the flow.

"results": "variables('varArrayChoices')"

Upon failure here is the 'Send an HTTP request to SharePoint' output:

{ 
 "__metadata": {
 "type": "SP.Data.IT_x0020_PMO_x0020_Project_x0020_TimelinesListItem"
 },
 "Title": "This is a test - 1",
 "Workstream": {
 "__metadata": {
 "type": "Collection(Edm.String)"
 },
 "results": "[{"Value":"Unity"},{"Value":"SPOT"},{"Value":"Dash"}]"
 }
}

Please help!

Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

Hi , @greddin1

Can you try to delete the "" in your results property?

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
greddin1 86 on at

Like (0)

Report

Thank you for your reply but the same error happens when removing those double-quotes.

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (1)

Report

Hi , @greddin1

Thanks for your response! I test it in my side ,,, I encounter the same code in your side.

You do not need to pass the __metadata for Multiplie Choices Column, Like this:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
greddin1 86 on at

Like (0)

Report

Thank you Yueyun. It's working now.

Was this reply helpful? Yes No