Filter Gallery on a value that starts with multiple choice values

(0) Share

Report

Posted on by Stijn007

155

Hello,

I have a sharepoint list, lets name it "Staff", with a choice column named "Knowledge".

in the choice column "Knowledge" I have values like TCC1, TCC2, TCC3 , OCC1 , OCC2, OCC3

Is it possible to filter a gallery based on a value , for example TCC, and get all the records where the value in the knwoledge column starts with TCC?

so in a dropdown, i added manually all values of the choice column and added "TCC" and "OCC"

When the uer selects TCC , all records where the knowledge starts with TCC , should be in the list.

Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
Pretending the table name is sampletable and the value it should start with is "App" in the Name column

Filter(SampleTable,StartsWith(Name,"App")=true)

replace smapletable with your collection, and name with your columnn name then "App" with the dropdown.selected.value ( play with this dropdown code in a text label box first to make sure you get the syntax correct to save you a headache)

Was this reply helpful? Yes No
Stijn007 155 on at

Like (1)

Report
Copy link

Link copied!

Hello,

I still get an error that StartsWith expect a text value and the column in my sharepointlist is a choice column and not text.
I guess that's why he gives the error.
I already tried to put the table in a collection but the error remains.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
See below

Filter(ParkingMasterGarages, ComboBox1.Selected.Name in Area.Value)

ParkingMasterGarages is the Source List

ComboBox1 is where I make my selection

Area is the choice column, and .Value is the choices location in that column

Was this reply helpful? Yes No