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
a
(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
a
(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
a
(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