Member-only story
How to Update SharePoint List Choice Fields Using HTTP Request in Power Automate
When managing SharePoint lists, especially in automated environments, it’s often necessary to update choice fields dynamically. Traditionally, PowerShell or direct REST calls were the go-to methods. However, with Power Automate, you can achieve the same with a low-code approach. This guide will show you how to update choice fields in a SharePoint list using Power Automate and an HTTP request.
Step 1: Create a Manually Triggered Flow
First, create a flow in Power Automate that triggers manually. This will allow you to run the update process on-demand.
Step 2: Define Your Choice Values
Next, define the choice values you want to update in your SharePoint list. You can do this by creating a variable in Power Automate. In this example, we’ll use a variable named varStatusValues.
Step 3: Add the HTTP Request to SharePoint
Now, add the action “Send an HTTP request to SharePoint” to your flow. This action will make a POST request to the SharePoint REST API to update the choice field.
