Hi Chad, after struggling throughout the day with trying to add a control statement for a multi-select SharePoint column, I finally stumbled across your video and you saved sanity.
Thank you so much for this! I've been trying different ways to address this based on suggestions from other users and nothing has worked... until now! (If I had realized you had a video on this subject, I would have started here because I have learned so much from you!) Thanks so much for sharing your knowledge!
Very grateful for this! I have done like you suggested with get items, but not with get just one item (row in the list). This can help me to send emails only to multiple persons for just one item. Thanks Chad!
Hi Chad, I saw your video but I am still struggling with how to get the data from the Compose inside the Apply to each. I'm trying to automatically fill in a Word document with the values from a SharePoint list, and one of them has a multi selection option. But the problem that I'm facing is that it's repeating the whole array for all items. I don't know what I'm missing. I opened a question in the community. If you could also help me, I'd appreciate.
Hi Chad. Thank you so much. Does this work if the input for the Select Data was from a Trigger: "For a selected file" > Add an input (multi-select text list)? I have tried but I cannot get the input to appear in the Dynamic List?
I just tested this and the response data from an Input with multi-select text choices is simply an array of the selected values. So, if the input choices are "red", "blue" and "green" and all three are selected, the data appears in the flow as ["red", "blue", "green"]. I'm not sure what you'd want to DO with that data, though. If you wanted to save it into a text field, for example, you can use the join expression to concatenate the values with your preferred delimiter.
Hi, I'm trying to transform a string A;B;C;D into an array with these values to add them to a Lists with a multiple selection column. Could you please help me? Thanks
You can use the "split" expression to convert that string into an array. The syntax is split(,''). So, split('A;B;C;D',';') will take care of the first part. As for how to "add them to a Lists", I need a bit more information on what exactly you mean by that. Do you have a multi-select choice column in a List with those values already? What are you actually trying to accomplish?
@@cvkealey Thank you for the reply! And you are right, it's a Choice column with multiple selection, the values are not there yet but Add values manually is enabled.
@@maltbycentre3394 OK...so where are the values that you want to record into that column coming from? Off the top of my head, I believe you need to get the values into an array in this format, then put that array into the field in an update item action: [{"Value":""},{"Value":""},etc.]
@@maltbycentre3394 I thought I had a video on this already but I couldn't find it. So, I recorded a new one: ruclips.net/video/-3CvB3Cq69o/видео.html In the video, I'm getting the data from MS Forms choice questions, but regardless of where your data's coming from, the format to save it in the choice column in SharePoint is the same.
Hi Chad - thanks for this video. I am trying to do something which can be called as 'Select within a select'. I have output from a list into a variable. I am using a Select operation to map values from each column and then this Select is being fed into 'Create HTML Table' operation. However, one of the columns in the list is a multi-select column and I want the values from this column to appear as comma separated values within the corresponding HTML table column. Any suggestions how can this be done? Thanks.
I know I've done something like that before, but can't seem to find the flow I used to do it. I recall using the Join expression within the "Value" field in the Select action to merge the "Value" for each selected choice in the column. The trouble is that I don't remember the syntax I used inside that expression to specify the values. I just tried a few quick tests and wasn't able to figure it out. I'll take another look at it over the weekend.
@@cvkealey I also thought of using a join, but cannot figure out the syntax which will work. I did find this one, which is good to get just one value from that column: item()?['Countries_x0020_Impacted']?[0]?['Value'] I let you check and come back if you can find something. It will be great help to me. Thanks
@@rohitagarwal8544 You might also want to post a message here in case one of the experts in the community already knows the answer: powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Those Compose actions aren't required, I only use them for demonstration purposes to show the structure of the data coming from the list. The "Inputs" are just the field names. For example, in this image (www.screencast.com/t/NXSCxaQLfo ), you can see the "Compose single-person value" is just the "Single-Person" dynamic content coming from the "Get item" action. That being said, you don't need them in your flow (I often stick them in there as I'm building a flow and remove them after testing and debugging - it's very useful to be able to examine the data when troubleshooting a flow).
@@cvkealey ok great. I'm getting there using a Form of multi-selects, updating a SPO multi-select choice column, and then trying to get the join of the values into a Planner Task detail. Chipping away and this is a great coaching video without doing the work for me :)
Hi Chad, could you help me make this work with 'Get Items'? When I try this approach with 'Get Items' there ends up being another inner Apply to each 2 loop for the multi-select user column. Mine fails with "The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array." Thanks.
Chad, I am trying to pass the value or contents of a multi-select person field from a PowerApps form with a SharePoint list data source to the CC: field of a "Send an email (V2)" action in Power Automate. I am using an instant flow triggered by a PowerApps button click and sending parameters to the flow. I have an array variable created to receive the multi-select person object in my Power Automate flow and I suspect that I'll need to grab the email addresses from each array element available in the object, but I am not sure how to proceed programmatically in Power Automate. Can you help? PS. My customer requires that the event be triggered by a button rather than when a new item is created in the data source or SharePoint list.
The simplest way to do what you want would be a Select action (to extract the email addresses into a single-column array) and a Join (to stitch them together into a single, semicolon-separated string that Outlook will accept). See ruclips.net/video/q7oOBCf0eB0/видео.html for an example. In that video, the array I'm starting with is the list of members of a group, but in your case, it would be the list of people in that multi-select person field. I assume you're already passing the ID of the list item to your flow, so you might need to use Get item to retrieve that item's properties.
Hi Chad, after struggling throughout the day with trying to add a control statement for a multi-select SharePoint column, I finally stumbled across your video and you saved sanity.
Thank you so much for this! I've been trying different ways to address this based on suggestions from other users and nothing has worked... until now! (If I had realized you had a video on this subject, I would have started here because I have learned so much from you!) Thanks so much for sharing your knowledge!
Exactly what I needed, thanks!
Very grateful for this! I have done like you suggested with get items, but not with get just one item (row in the list). This can help me to send emails only to multiple persons for just one item. Thanks Chad!
This was very useful - thank you so much
THANK YOU ! u helped me a lot
Hi Chad, I saw your video but I am still struggling with how to get the data from the Compose inside the Apply to each. I'm trying to automatically fill in a Word document with the values from a SharePoint list, and one of them has a multi selection option. But the problem that I'm facing is that it's repeating the whole array for all items. I don't know what I'm missing. I opened a question in the community. If you could also help me, I'd appreciate.
Hi Chad. Thank you so much. Does this work if the input for the Select Data was from a Trigger: "For a selected file" > Add an input (multi-select text list)? I have tried but I cannot get the input to appear in the Dynamic List?
I have not tried it with a multi select trigger input. Off hand, I'm not sure what format the comes in as, but I'll take a look at it today.
I just tested this and the response data from an Input with multi-select text choices is simply an array of the selected values. So, if the input choices are "red", "blue" and "green" and all three are selected, the data appears in the flow as ["red", "blue", "green"]. I'm not sure what you'd want to DO with that data, though. If you wanted to save it into a text field, for example, you can use the join expression to concatenate the values with your preferred delimiter.
Hi, I'm trying to transform a string A;B;C;D into an array with these values to add them to a Lists with a multiple selection column. Could you please help me? Thanks
You can use the "split" expression to convert that string into an array. The syntax is split(,''). So, split('A;B;C;D',';') will take care of the first part. As for how to "add them to a Lists", I need a bit more information on what exactly you mean by that. Do you have a multi-select choice column in a List with those values already? What are you actually trying to accomplish?
@@cvkealey Thank you for the reply! And you are right, it's a Choice column with multiple selection, the values are not there yet but Add values manually is enabled.
@@maltbycentre3394 OK...so where are the values that you want to record into that column coming from? Off the top of my head, I believe you need to get the values into an array in this format, then put that array into the field in an update item action: [{"Value":""},{"Value":""},etc.]
@@maltbycentre3394 I thought I had a video on this already but I couldn't find it. So, I recorded a new one: ruclips.net/video/-3CvB3Cq69o/видео.html
In the video, I'm getting the data from MS Forms choice questions, but regardless of where your data's coming from, the format to save it in the choice column in SharePoint is the same.
Hi Chad - thanks for this video. I am trying to do something which can be called as 'Select within a select'. I have output from a list into a variable. I am using a Select operation to map values from each column and then this Select is being fed into 'Create HTML Table' operation. However, one of the columns in the list is a multi-select column and I want the values from this column to appear as comma separated values within the corresponding HTML table column. Any suggestions how can this be done? Thanks.
I know I've done something like that before, but can't seem to find the flow I used to do it. I recall using the Join expression within the "Value" field in the Select action to merge the "Value" for each selected choice in the column. The trouble is that I don't remember the syntax I used inside that expression to specify the values. I just tried a few quick tests and wasn't able to figure it out. I'll take another look at it over the weekend.
@@cvkealey I also thought of using a join, but cannot figure out the syntax which will work. I did find this one, which is good to get just one value from that column: item()?['Countries_x0020_Impacted']?[0]?['Value'] I let you check and come back if you can find something. It will be great help to me. Thanks
@@rohitagarwal8544 You might also want to post a message here in case one of the experts in the community already knows the answer: powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Hi Chad - very nice walk-thru. Did you show the Compose actions for the values before the branch? What would one look like?
Those Compose actions aren't required, I only use them for demonstration purposes to show the structure of the data coming from the list. The "Inputs" are just the field names. For example, in this image (www.screencast.com/t/NXSCxaQLfo ), you can see the "Compose single-person value" is just the "Single-Person" dynamic content coming from the "Get item" action. That being said, you don't need them in your flow (I often stick them in there as I'm building a flow and remove them after testing and debugging - it's very useful to be able to examine the data when troubleshooting a flow).
@@cvkealey ok great. I'm getting there using a Form of multi-selects, updating a SPO multi-select choice column, and then trying to get the join of the values into a Planner Task detail. Chipping away and this is a great coaching video without doing the work for me :)
@@cvkealey similar to a text label field to see the results differently during coding in Power Apps and removing them later. Got it!
Hi Chad, could you help me make this work with 'Get Items'? When I try this approach with 'Get Items' there ends up being another inner Apply to each 2 loop for the multi-select user column. Mine fails with "The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array." Thanks.
I'm not 100% sure what your use case is, but this might help: ruclips.net/video/fjYNT0EgzAU/видео.html
Chad,
I am trying to pass the value or contents of a multi-select person field from a PowerApps form with a SharePoint list data source to the CC: field of a "Send an email (V2)" action in Power Automate. I am using an instant flow triggered by a PowerApps button click and sending parameters to the flow.
I have an array variable created to receive the multi-select person object in my Power Automate flow and I suspect that I'll need to grab the email addresses from each array element available in the object, but I am not sure how to proceed programmatically in Power Automate. Can you help?
PS. My customer requires that the event be triggered by a button rather than when a new item is created in the data source or SharePoint list.
The simplest way to do what you want would be a Select action (to extract the email addresses into a single-column array) and a Join (to stitch them together into a single, semicolon-separated string that Outlook will accept). See ruclips.net/video/q7oOBCf0eB0/видео.html for an example. In that video, the array I'm starting with is the list of members of a group, but in your case, it would be the list of people in that multi-select person field. I assume you're already passing the ID of the list item to your flow, so you might need to use Get item to retrieve that item's properties.
@@cvkealey Thank you very much! I'll give that a try.