Power Automate - How to extract SharePoint multi-select choice field text values?

This video explains how to extract SharePoint multi-selected choice field text values using Microsoft Power Automate.

[wilhelmdietrich]

You're a life saver. I've been trying to solve this for like an hour and I'm certain I've visibly aged in that time.

[Chris-znxt]

struggled in getting this to work for hours from other online guidance until I viewed this. 10 minutes later all working. thanks

[komalahmeds]

Hi, thank you for creating this video. I just started with PowerApps and found this to be a very helpful tutorial. :)

[shighaabraham]

Really helped with my problem. Thanks for the illustration and clearly describing the steps.

[courtneybryson]

Hello. Thank you for your video! I have been looking for a solution everywhere and this has helped me extremely,

[ion]

Thank you for the short and easily explained video.

[glaringmind-rqxu]

Hi! this is very helpful! i am trying to save the muti select values in another list as single select value. for your example i would like to create 3 items in list B for Rugby, Football and cricket. I am having trouble with the array. can you show how to create 3 list items using flow ?

[vaibhavvaidya]

I just want to let you know, I search lot of solutions on internet but didn't find suitable as you explain, all I want following output and I got ["value1", "value2", "value3"] thank you so much

[josephhaney]

Thank you very much for posting this video! It was driving me a little crazy figuring that out. :)

[RaeSindy]

You are awesome! Thank you so much for getting me on the right track with this.

[bobbirowlett]

Hello - What happens if sometimes the people select many and sometimes they pick only one sport? How would you handle that?

[SherifKhalaf]

Thank you soo much, it worked perfectly :)

[nicolashtr]

This is really helpful, thanks a lot!

How can I get this output into a HTML table?

[shahg]

This is top class solution. i have a small question. when i get these values now my next control is to send an email and populate these values in html table form in body of email. i have two columns one is item name and other is item picture. so if it get three values there will three columns. eg. Laptop, Keyboard/mouse, Mobile. on left side picture column i want a default static picture of each item and on item column these item names only.

[christelleteissieres]

great tips. how to combine with more than 1 field, using a sharepoint list that includes fields with multi-select and fields with regular string content. In you example how to retreive the 'Sports' as joined values (alike what you did) and two addionnal columns like 'Created' and 'UNR' for instance

[mjmann]

Love this video. Is there any way to make this work with a list of items containing multiselect fields that you would like to display the value in an html table? I have rewatched all of your videos but each time the odata string returns or else if I use value, it's just null.

[wendymeyer]

Hello, and thank you for this video - your method seems a whole lot simpler than other solutions I've found.
I just have one question though: I'm able to replicate all your steps successfully, but the next step in my Flow includes a Condition and I can't seem to figure out what properties I need to plug in there. Using your example with the "Sports" column, if my Condition for instance is dependent on a simple statement such as: "Sports value is equal to Football", what are the correct properties to plug in here please? Inserting the "Sports value" field in there throws an "Apply to Each" around the Condition, and I've tried all kinds of other variations with your string code outputs but I'm just not getting it right. (My Condition is such that if a particular choice is selected out of the multi-choice options, then a certain Flow sequence needs to run.)

[cmakenny]

Once I have the join value created how can you then use that value as dynamic content in another action? I can only seem to select the apply for each and not the actual join value

[woopy]

The join action returns the correct output, but I cannot use the output when I try to create a new item. The option in dynamic content does not appear. Any solution?

[kabax]

Thank you for this. This video was helpful. AFter Compose, how can I get the values in the body of an email notification?