Power Automate - Update MultiChoice Field

SUDHARSAN KESAVANARAYANANSharePoint Consultant
CERTIFIED EXPERT
Microsoft MVP Office Dev focussed on Azure services, M365, SharePoint On-Premise & SharePoint Online, Power Automate, Power Apps, LiveTiles
Published:
This post lets us see how we can update the multichoice field in SharePoint list using Power Automate actions. We will update the field using the out-of-box Create Item action.
Introduction
Power Automate, formerly Microsoft Flow, is a Microsoft automation solution for repetitive tasks. Using connectors, you can create automated workflows within Microsoft applications and non-Microsoft applications.

A few examples for workflows which you can do with Power Automate are

  • Automate business processes
  • Send automatic reminders for past due tasks
  • Move business data between systems on a schedule
  • Connect to almost 300 data sources or any publicly available API
  • You can even automate tasks on your local computer like computing data in Excel.

In this post, let us see how we can update the Multichoice field in the 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 have the 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
This image has an empty alt attribute; its file name is image-9.png 2. Choose the Site Address and List A for the List Name property
This image has an empty alt attribute; its file name is image-10.png 
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 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']
This image has an empty alt attribute; its file name is image-12.png 
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
In order 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 the '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.
This image has an empty alt attribute; its file name is image-16.png 
That's it, we are done with the flow. Try to 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 List B.

Happy Flowing...
0
81 Views
SUDHARSAN KESAVANARAYANANSharePoint Consultant
CERTIFIED EXPERT
Microsoft MVP Office Dev focussed on Azure services, M365, SharePoint On-Premise & SharePoint Online, Power Automate, Power Apps, LiveTiles

Comments (3)

SUDHARSAN KESAVANARAYANANSharePoint Consultant
CERTIFIED EXPERT

Author

Commented:
Hi McKnife,

I recently published an article on Power Automate and it was published. May I know why this article needs an introductory?
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Look, not all editors are the same.
I already stated why I think it needs an introduction.
SUDHARSAN KESAVANARAYANANSharePoint Consultant
CERTIFIED EXPERT

Author

Commented:
Hi, thanks for the update. Please publish it.

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.

Get access with a 7-day free trial.
You Belong in the World's Smartest IT Community