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?
Pretending the table name is sampletable and the value it should start with is "App" in the Name column
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)
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.
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