“I’d like to copy a multiple choice SP field to another item, what’s the best way to select only the values from the array with Power Automate?”
“I need to extract only the user email addresses, I don’t need all the other user information.”
Working with Power Automate often involves working with arrays. Sometimes it’s a simple array, but more often it’s an array of objects. And with arrays of objects there’s a difference between what you get and what you can use. For example the SharePoint multiple choice column. You’ll get 3 properties for each of the choices, but you’ll need only the “Value”.
The same applies to multiple people picker. You get all the user information, but in most cases you need only the email address.
How do you then extract only the desired values, ideally in the required format?
Use the ‘Select’ action
The action you’re looking for is ‘Select’. You’ll input an entire array of objects and select what values it should return. The action has even an option to return a simple array with the values, or another array of objects.
Select only values
You can switch the action to return a simple array by pressing the small button – it’ll keep only 2 fields visible. Enter the whole array in the ‘From’ field, and select which value you want to return in the ‘Map’ field.
This is often used in combination with the join(…) expression to turn the values into a string. For example, if you want to send a single email to multiple users at once.
Select values and turn them into array of object
The other option is to return an array of objects. If you keep it in the original mode, with 3 fields, you can input the array, select what values it should return, and define the property key for the value.
This approach is used when you want to copy the values to another place and you need them in a specific format. For example, to update multiple people picker column or a multiple choice column.
Summary
‘Select’ is one of the most powerful actions in Power Automate, it’s the easiest way to get values from an array. Instead of looping through all the objects and appending the values in a variable, you can have a single action. All you need is to find the right format of the array, and ‘Select’ it accordingly.
Hi Tom,
I have been trying this with a multi-select choice field and the output of the Select action is just like yours, except for with my column “Building” and the building values. I then need to send an email with the building values listed in the body. I can’t figure out how to get just the values. I’ve created a Join action after the Select action, but the email body looks like this:
{“Value”:”Building 1″},{“Value”:”Building 4″},{“Value”:”Building 7″}
How do I remove all the “value” text and characters and just get Building 1; Building 4; Building 7
Thanks,
Beth
Hello Beth,
you should switch the ‘Select’ action to the text input only mode, without the Key value as shown on the screenshot.
Thank you for this post! It has helped me immensely!
Hi Tom, This helped me a lot, but I need to extract one item from an array (department column) that matches the department field in a single item on another list.
Source list: Department (single line of text, unique values only)
Contact (value changes)
Example: Department = Finance
Contact = John Smith
Destination: Department, Assignee, Manager, Contact
Example: Department = Finance (manually chosen from lookup)
Contact =
Objective: Src Department value = Dest Department value then update Dest with current Contact and item ID
The reason I have to do this through automate and not lookups is that this is part of a complicated time tracking process and this information will be sent to multiple lists that fulfill different objectives.
Using your steps to Select from the array, I was able to get a list of departments. However, I need to compare Source to Destination in order to update the Destination list with the Department’s current contact.
Let me know if this is an overreach! I’ve been struggling with this issue for about 3 months and I haven’t found a solution.
Thank you!
Hello Fran,
from the description I’d think that you need a lookup to find the value in the other list as described here: https://tomriha.com/how-to-lookup-data-in-another-sharepoint-list-in-power-automate/. ‘Get items’ with a Filter Query to find the corresponding department and then use the returned item to update the Contact information.