Power Automate – Update MultiChoice Field

Introduction

Hi friends, in this post let us see how we can update multichoice field in SharePoint list using Power Automate actions. We will update the field using the out-of-box Create Item action.

Focus on the Flow

The scenario is by creating an item in List B when an item in List A is created or updated. Both the lists has same fields listed below

  1. Title – Default field
  2. Sample Choice – Multichoice field, internal name is SampleChoice

Let us start designing the flow

  1. Create an automated flow, give a unique name to the flow and select the trigger named ‘When an item is created or modified‘ as shown below

2. Choose the Site Address and List A for the List Name property

3. Add an action ‘Initialize Variable‘ and provide the properties as mentioned below. This variable will store the choices from an item from the source list.

  • Name – Choices
  • Type – Array
  • Value – []

4. Save the flow.

5. Add an action ‘Apply to each‘ and provide the input as “triggerOutputs()?[‘body/internal-name-of-the-choice-field’]“. In our case the internal name is ‘SampleChoice

6. Add an action ‘Append to array variable’ inside the ‘Apply to each’ action. Provide the following properties for the append action.

  • Name – Choose the initialized array variable
  • Value – items(‘Apply_to_each’)?[‘Value’]

7. Add an action ‘Select‘ after the ‘Apply to each‘ and not inside the ‘Apply to each‘. ‘Apply to each‘ must have only one action inside the loop. Provide the following properties to the ‘Select‘ action.

  • From – Choose the variable Choices
  • Map – Value in the first column and item() in the second column

Inorder to update the multichoice value to the item field, SharePoint expects the input argument in the below format, so we have to define the structure using ‘Select‘ action.

[
    {
        Value: 'Choice 1'        
    },
    {
        Value: 'Choice 2'
    },
    {
        Value: 'Choice 3'
    }
]

8. Add an action ‘Create Item’ and choose the following properties

  • Site Address – SharePoint site collection url
  • List Name – List B
  • Title – Choose the title value from the source list.
  • Sample Choice – Click on the ‘T‘ on the right end to change the field to text and select the output from the ‘Select‘ action.

Thats it, we are done with the flow. Try add or modify an item in List A, the flow should be triggered and the same item with all the metadata including the multichoice should be added to the List B.

Happy Flowing…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s