Updating the settings of a SharePoint list with Power Automate

(2) Share

Report

Posted on by GShaw

Hello all

Is anyone aware if it's possible to update the settings of a SharePoint list using Power Automate?

I would like to trigger a flow from my Power App, that will make an update to the settings of the list. In my specific case, I would like to update the available entries in a choice column, i.e. add/remove/rename the available entries here:

Appreciate any suggestions.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Suggested answer

David_MA 12,980 Super User 2025 Season 2 on at

Like (3)

Report

I have not attempted this, but using the SharePoint REST API, you should be able to do this. I found this post that explains the steps: sharepoint online - Add a new choice option to a choice field with write-in using REST without erasing existing options - SharePoint Stack Exchange

Was this reply helpful? Yes No
GShaw 33 on at

Like (1)

Report

@David MA

Thanks, that looks very promising. I'll try the steps in that document.

Thanks

Gary

Was this reply helpful? Yes No
Verified answer

S-Venkadesh 927 Moderator on at

Like (2)

Report

Hi @GShaw,

To update a choice field in a SharePoint list, Use "Send an HTTP request to SharePoint" action.

URL: _api/web/lists/GetByTitle('list-name')/Fields/GetByInternalNameOrTitle('column-name')
Method : POST

Headers:

{
"accept": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose",
"X-HTTP-Method": "MERGE",
"IF-MATCH": "*"
}
Body:
{
"__metadata": {
"type": "SP.FieldChoice"
},
"Choices": {
"results": @{variables('varStatusValues')}
}
}

Sample Screenshots:

I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No
Verified answer

GShaw 33 on at

Like (1)

Report

Hi @S-Venkadesh, thanks, appreciate your response. Both your response and the article supplied by @David MA are very useful.

For anyone else looking to do something similar, I also found the YT video called "SharePoint HTTP Action add Choice Value with Power Automate" by Shane Young very useful in explaining the steps: https://www.youtube.com/watch?v=TH6oqsfxPaE

@David MA unfortunately, this site is not allowing me to make your response as an answer for some reason, but I will try again later.

Thank you both.

Regards

Gary

Was this reply helpful? Yes No