Today we will learn how to get SharePoint multi select choice column values in Power Automate and use it to create a new item in another SharePoint list.
As you may know, it is easy to get the values of a simple choice column value in Power Automate, but when you are supposed to get the values of a multi-select choice column, it becomes a little bit difficult. In this post, I will explain the method that I used in one of my projects:
A) I have a SharePoint list and there is a multi-select choice column names “Project Gates”
B) I intend to get this column values from each item returns by “Get Items” action and then copy these values in another SharePoint list using “Create Item” action.
For this purpose, I’ve created a Power Automate workflow as follows:
1- We need to get list items by using “Get Items” action.
2- Add an Initialize Variable action and define varChoice variable.
3- Add a Compose action and then by dynamics content add “Project Gates” column as Inputs. It will force the Power Automate to add an Apply to each action, because Get Items action returns multiple items.
4- Add a Select action and fill out From and Map fields as above screenshot.
5- Finally add a Set Variable action and set varChoice in Name field and select Output for Value field.
6- Next we need to put the varChoice variable content in next action, Create Item.
7- So, add a Create Item action as follows and fill out the destination Site Address and List Name field.
8- Now, we are going to set the destination column for example in my scenario Project Gates with varChoice.
That’s all! Now we have values of multi selected choice column in destination list’s column that is multi select choice column same as source list.
For the reference I also added expression string of each item in each screenshots.