Working with multi-select SharePoint columns in Power Automate

Описание к видео Working with multi-select SharePoint columns in Power Automate

In this video, I show two techniques for handling data that comes into a flow from mult-select Person and Choice columns in SharePoint (or Microsoft) Lists. Basically, the data in a multi-select column is always presented/formatted as an array of objects in Power Automate. So, to get the values you want or need from that array - in the format you need it in - can be a challenge. The two approaches I show here are:
1) Use a variable and append values to it, adding an appropriate delimiter. This technically works for most of the things you're likely to do (e.g.: assigning approvers or sending emails to the email address of the selected people), but there is a performance cost to using variables. Also, this method will leave an "extra" delimiter at the end of the resulting variable value, which may not be desireable.
2) Using data operations, specifically Select and Join to extract the specific property from each object in the array, then concatenate them with a delimiter of your choice. The advantages here are no "performance cost" of variables or loops and no "extra" delimiter at the end of the resulting string.

Which of these you choose ultimately depends on your use case and what you want to achieve.

Комментарии

Информация по комментариям в разработке