Answered

Filtering from a multiple selection choice column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a requirement where I need to filter a Get Items action from a choice column that allow multiple selections from a SharePoint list. I have seen other threads with relatively the same requirement but I can't tell if the solution is the same as they seem to all be for PowerApps objects.

Configuration: Choice column (with multiple selection enabled) called "Securities". Choices are BAM, BIP, BBU, BEP, BAMR (in that order)

I had originally set the filter query to "substringof('0', Securities)" - thinking that the first choice would have an actual value of "0" but It returned no results. I also tried "substringof('BAM', Securities)" - Which also returned no results.

Is there a way I can use the filter query to only return items where the choice column contains "BAM" but does not include "BAMR", or am I just asking for to much?

Any help would be greatly appreciated.

DWTKBrook

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @Anonymous ,
you can do it as below:
If you don't find the column, please add it as custom value.
You can add more than 1 filter condition

Please enable the experimental features following these steps:

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank you @MarconettiMarco, that looks promissing, I will attempt your advice and get back to you,

All the best!

Was this reply helpful? Yes No
jiwhite 500 on at

Like (0)

Report
Copy link

Link copied!

How do you add a custom item in the filter?

Was this reply helpful? Yes No