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:
- People Picker field
- Lookup field
- Choice Field
- 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.
Column | Column type |
---|---|
Name | Single Line of text |
Implementation Date | Date and time |
Department | Choice |
Description | Multi-line of text |
Policy owner | Person |
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.
Now, provide the flow name and select the trigger ‘When an item or a file is modified‘ action.
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.
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.
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.
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 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.
And also you can see your Flow ran successfully.
Related Microsoft Power Automate tutorials:
- Power Automate get events into excel
- Microsoft flow send email based on create date
- Power Automate or Microsoft Flow check day of week
- Power Automate Desktop Flow – How to start
- The specified object was not found in the store Power Automate
- Power Automate delete all items in SharePoint list
- Power Automate SharePoint Get Items Filter Query
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.
Bhawana Rathore is a Microsoft MVP (3 times in Office Apps & Services) and a passionate SharePoint Consultant, having around 10 years of IT experience in the industry, as well as in .Net technologies. She likes to share her technical expertise in EnjoySharePoint.com and SPGuides.com
I don’t understand where the contents of “Append to array variable” come from. “Claims” is not a list column mentioned in the article.