How to Update SharePoint Choice Column in Power Automate?

In this tutorial, I will explain how to update SharePoint choice column in Power Automate. I have taken a complete example to do the flow.

Scenario:

For that, I have taken a SharePoint list named ‘Travel requests ‘ with different columns, including choice columns.

Column Name	Data Type
Trip Title	Title column- Renamed as Trip title
Departure State	Choice column
Destination State	Choice column
Available Airlines	Choice column

Here, I am going to show you how to update the AvailableAirlines choice column based on the below conditions.

• Departure State = Colorado & Destination State = Michigan -> Update Available Airlines – Southwest Airlines, Delta Airlines, Emirates.
• Departure State = California & Destination State = Florida -> Update Available Airlines – Southwest Airlines, Spirit Airlines, Alaska Airlines
• Departure State = Alaska & Destination State = Minnesota -> Update Available Airlines -Alaska Airlines, Delta Airlines and Emirates.

Let us create the flow now using Power Automate.

Power Automate Update Choice Field Values

I will explain how to update the choice field values in a SharePoint Online list column using Power Automate.

• Create an Automated cloud flow with a trigger and give properties as shown below:
  • Site Address: Select a SharePoint site address from the drop-down.
  • List Name: Click on drop-down to select a specific SharePoint list.

• Then Click on +New step.

• Add Condition control action and provide the below-given statements as shown in the table.
• Select Add an action under the If yes section.

Choose Value (Col 1)	Operator	Choose Value (Col2)
Departure State – Dynamic content	is equal to	Colorado – Hardcoded
Destination State -Dynamic content	is equal to	Michigan – Hardcoded

• Add Update item (SharePoint) action and provide mandatory below details:
  • Site Address: Select Site Address from the drop-down.
  • List Name: Click on the drop-down to select a specific SharePoint list.
  • Id: Select ID from the dynamic content.
  • Title: Select Title from the Dynamic content.
  • Available Airlines Value: Select values from the drop-down. Here, I have taken three choice values because this choice column allows multiple selections of values.
  • These values will be updated in the SharePoint list Available Airlines column.

• Under If no condition, Click on Add an action.

• Add Condition control from Choose an operation box under the Actions tab.

• Add another Condition control and provide the condition as shown below:
  • Departure State = California (Hardcoded)
  • Destination State = Florida (Hardcoded)
• Select Add an action under the If yes condition.

• Add Update item (SharePoint) action and provide details like:
  • Site Address: Select a site address from the drop-down.
  • List Name: Select the specific SharePoint list.
  • Id: Give ID from dynamic content.
  • Title: Provide Title from dynamic content.
  • Available Airlines Value: Select values from the drop-down.
    • Here, I have taken three choice values like Southwest Airlines, Spirit Airlines, and Alaska Airlines.

• Under Condition 2, Selection, Add an action below, If no section, as shown below:

• Add Condition control action; I have given the conditions as shown below table:

Choose Value (Col 1)	Operator	Choose Value (Col2)
Departure State – Dynamic Content	is equal to	Alaska – Hardcoded
Destination State – Dynamic Content	is equal to	Minnesota -Hardcoded

• Select Add an action under If yes of Condition 3.

• Add Update item (SharePoint) action and give mandatory below details like:
  • Site Address: Select a site address from the drop-down.
  • List Name: Select the specific SharePoint list.
  • Id: Give ID from dynamic content.
  • Title: Provide Title from dynamic content.
  • Available Airlines Value: Select values from the drop-down. Here, I have included three choice values Alaska Airlines, Delta Airlines, and Emirates.

• Once the flow has been created, Click on Save and select Test.

• In the Test Flow window, Select Manually and Click on Test.

• Now, add an item to a SharePoint list to run the flow.
• If there are no errors, the flow runs successfully and displays a notification of ‘Your Flow ran successfully.

• If the created item satisfies condition 1, then the choice values will get updated in the choice column of a SharePoint list, as shown below:

• The below presented image shows the updated choice field values in the Available Airlines column if the created or modified item satisfies condition 2.

• The screenshot below represents the updated choice values in the Available Airlines column for Condition 3 in the Travel requests list:

This is how to update SharePoint Online list choice column values in Power Automate.

Conclusion

I hope you learn now how to update a SharePoint choice column in Power Automate. Using if conditions; I have explained how to update the SharePoint list choice column values.

You may also like:

• How to Build a Parallel Approval in Power Automate
• Send Birthday Emails from Excel using Power Automate
• How to Update SharePoint List Date and Time Column in Power Automate?