How to update SharePoint Multiselect column in Power Automate

In this Power Automate tutorial, we will discuss updating file properties in Microsoft flow not showing property. And also, we will discuss how to update SharePoint Multiselect column in Power Automate.

So here we will see How to create a Flow, which will update the multi-Select column in SharePoint list or library using Microsoft Flow or Power Automate.

Power Automate Update SharePoint Multiselect column

Here we will see how to update the Multiselect column using Microsoft Flow.

In Microsoft Flow, when it comes to updating a field in SharePoint where we can select multiple items, for this there is a trick which is applied to:

  1. People Picker field
  2. Lookup field
  3. Choice Field
  4. Managed Metadata
  • I have created a SharePoint Document library called DemoPolicies, where we will save the company policies. And in this list, we have a column called Policies owners (Person column), which accepts multiple owners.
  • For example, if the user will edit the item two times, and there are two policy owners we have, so the first time we edit flow will update the one policy owner, and the second time we edit it will update another policy owner by replacing the first policy owner.
  • Therefore the end result we will get only one policy owner name, whereas we expect two policy owner names.

So, here we will create a flow that will update the multiple select policy owner using Power Automate and Microsoft Flow.

Read How to create a word document from a template in Power Automate

Steps to Update Multiselect column in SharePoint using Power Automate

Step 1: Create a Folder in SharePoint Document Library

I have already created a Folder called ‘DemoPolicies’, in the SharePoint Document library, which is having a Different column with column types.

ColumnColumn type
NameSingle Line of text
Implementation DateDate and time
DepartmentChoice
DescriptionMulti-line of text
Policy ownerPerson
SharePoint Library
Update file properties Microsoft flow not showing property
Update file properties Microsoft flow not showing property

Once your SharePoint folder for Company Policies is created, Now we will create a flow.

Step 2: Create a Flow

To create a flow login to Power Automate, and then click on Create and select Automated Cloud Flow.

power automate update file properties item with changed properties
power automate update file properties item with changed properties

Now, provide the flow name and select the trigger ‘When an item or a file is modified‘ action.

Update file properties Microsoft flow not showing property
Update file properties Microsoft flow not showing property

Step 3: When an item or a File is Modified

Now in this step, we will provide the site address, library name, and folder which you have created in SharePoint Online.

Update file properties Microsoft flow not showing property
Update file properties Microsoft flow not showing property

Step 4: Initialize variable

Now we will initialize a variable which we will use later to save the array of people. So click on the Next step and initialize variable action, and then provide a variable name, and type as array.

power automate update file properties item with changed properties
power automate update file properties item with changed properties

Step 5: Append the value to the variable

In this step, we will append the people to the array variable, so click on the next step and select Append to array variable action.

Then select the variable name from the dropdown and in value write the claim: Policy owner claim from the dynamic content, it will automatically add the Apply to each action. Here we used claim because we are using the Person field.

power automate update file properties item with changed properties
power automate update file properties item with changed properties

Step 6: Update File properties

Now we will update the Policy owner, so click on the Next step and select Update file properties action.

Then provide the site address, Library name, and id from the dynamic content. In Policy owner property, switch to the entire array and then select the variable name from the dynamic content.

Update file properties Microsoft flow not showing property
Update file properties Microsoft flow not showing property

Update File Properties column Not showing all properties

If in the Update file properties is not showing all the columns, then click on the Show advanced option, which will show the field ‘Limit Columns by view’ field, in this select ‘Use all columns (No limit)’ from the dropdown.

Once your flow is ready, click on the save and run the Flow manually.

Step 7: Run the Flow

To run the Flow click on save and Modify the item by adding another policy owner like below. And make sure that while creating the policy owner column you have turned on the ‘Allow multiple selections’ feature.

Update file properties Microsoft flow not displaying property
Update file properties Microsoft flow not displaying property

And also you can see your Flow ran successfully.

Update file properties Microsoft flow not showing property
Update file properties Microsoft flow not showing property

Related Microsoft Power Automate tutorials:

This is how we will update the file properties of a SharePoint Multiselect column using Power Automate or Microsoft flow. Also, we learn how to fix the error, update file properties Microsoft flow not showing property.

>