Update a Choice Column in SharePoint Lists with Power Apps

 

Choice columns are a handy way to categorize items in your SharePoint list. But what if you need to update the selection after the fact? This post dives into various methods for updating choice columns, including Power FX code and data samples.

Understanding Choice Columns:

A choice column allows users to select pre-defined options from a dropdown menu.

These options can be single-select or multi-select.

PowerApps provides a powerful low-code environment for building custom applications. Here's how to update a choice column using Power FX:

Let's say you have a SharePoint list named "Tasks" with a choice column called "Status" containing options like "Open," "In Progress," and "Completed." You want to update a specific task's "Status" to "Completed" using a PowerApp.

Patch(

  'Tasks', // Replace 'Tasks' with your actual list name

  LookUp(

    'Tasks', // Replace 'Tasks' with your actual list name

    ID = Dropdown1.Selected.ID // Replace 'ID' with your actual unique identifier column

  ),

  { Status:{ Value:"Completed" }}

)

Note:

1. You can directly update the choice column within the SharePoint interface:

1. Open the SharePoint list containing the choice column.
2. Click on the specific item you want to modify.
3. Edit the value of the choice column from the dropdown menu.
4. Save the changes.

2. Or using Microsoft Power Automate Flow:

1. Trigger: When a new item is created in the "Tasks" list.
2. Condition: Check if the "Status" of the new item equals "Open."
3. Delay: Introduce a one-day delay.
4. Update SharePoint List Item: Update the "Status" of the item to "In Progress."

Conclusion:

Ensure you have the necessary permissions to edit SharePoint list items.

When using Power FX or Flow, test your code/workflow thoroughly before deployment.

Consider using conditional logic to update the choice column based on specific criteria.