Power Automate - Get SharePoint Multi-Select Choice Field Values & Comparisons

This video explains how to get SharePoint multi-select choice field values and do comparisons in an IF condition.

Expression I used here is:
item()?['Value']

[josemanuelimbachivarela]

Man, you just solved a huge problem i had with that line of text, thank you!!!

[wendymeyer]

@abm - Thank you for this great video. Your approach to multi-select choice fields is by far the simplest solution I've found on the web. This will really help me a lot with my Flows.

[peterlavery]

How would you go about this if you wanted to extract the value whilst keeping it associated it to columns?

For example, if the Value is football, then return the row with football and all of the other column data?
If the row does not equal football, skip that row, but the next row it finds equal to football, keep all the data in the row

[ajaysinghrandhawa]

expression for the mapping of select wont work for me, it requires a key to be mapped

[Chineeex]

Great tutorial and best way to deal with multi choice column values! Thank you!

Question, after the Join, how could I compare the value of the Join output with a value from another share point list? In the video you manually type the value “o/s” in the if condition but what it I just want to grab all values at once instead of one by one?

[Rob_K]

Hi @abm thank you for this video very informative.
1 question I have which I can’t seem to find the answer too. In the condition you type “Rugby” or “Football” to see if it contains these. How would I go about using dynamic content? I want this to trigger an email based on a users input - if the input matches one that is already on the list an email will get sent to all those with the same choice. For example I choose football & Rugby. The condition sees that these already exist on the list and will email those with this choice to let them know someone else has also chosen these fields.. does that make sense?

[nguyengiandara]

Hi! I'm using the create csv table action to transfer most of my other columns. can I just apply your step to get multiple choice field after the csv table action? thanks a lot!

[rodneyroche]

Great tutorial, quick question Sir, how do I add the output to the email? I cannot find the Compose, it is showing under Apply to each

[saicharanreddy]

Hello,
Great tutorial. I want save the choice values in excel sheet I am using "add row into a table" connector, in the column field: I have entered body('Select'), but in excel values are copying like [" Football", "Rugby"] is there any way i can only copy Football, Rugby into my sheet?

[malexanderr]

This doesn't work if the value you are looking for is contained in one of the other choices.

[anujpathak]

thanks for this solution, I could replicate it, but my output is printing the multiple times. e.g I have t items in the field like laptop Mobile. so the output will be Laptop, Mobile, Laptop Mobile. The out is getting print the number of item in the field

[abcrandy]

Your solution worked but I'm experience a big difference in run time. Prior to adding the select and join functions, it took my flow an hour to run. Now its 4 hours. Any idea what could be causing this and is there a solution to reduce the run time?