web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update SP choice colum...
Power Automate
Unanswered

Update SP choice column with HTTP request

(0) ShareShare
ReportReport
Posted on by

I am testing a flow to update the choices of my choice column. I created a flow that will get the current choices using an HTTP request, put the old choices into an array, append the array, and use a HTTP request to post the new choices to the column. For my HTTP request I am getting my SP column by title but when I try to update the column I get this error: 

The property '__metadata' does not exist on type 'SP.FieldChoice'. Make sure to only use property names that are defined by the type.

For my HTTP request to post the changes my body is: 

{ "__metadata":
{ "type": "SP.FieldChoice" },
"Choices": { "results": [ varResults ]}
}

This is what I'm using to merge the new choice with the old choices:

kingy61422_0-1706732237464.png

 

varResults is the array I used to put the old choices into. My SP column name is 'Order Type' and it is a required field.

Did I make a mistake for the body of my HTTP request or the Headers? How can I get the desired outcome of merging the new choice with the old choices?

Categories:
I have the same question (0)
  • wskinnermctc Profile Picture
    6,519 Moderator on at

    I don't know the exact answer, but I would search for examples that does not require using _metadata in the body.

     

    I think you do this by changing the content to application/json;odata=none

    and then remove the metadata part

     

    This way it doesn't expect full metadata.

     

    Here is a quick example I googled, maybe it will help

    https://powerusers.microsoft.com/t5/General-Power-Automate/Update-choice-field-using-HTTP-Request-action/td-p/849435 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard