Filtering with a choice with sharepoint list

(0) Share

Report

Posted on by Jacktheripp

I am trying to get a sharepoint list to search using one column an then filter this again on a second column.

I don’t mind the order of the filtering

txtsearchbox is an input box

Sharepoint is the sharepoint table

Column1 is a column with a choice dropdown

Column2 is a column with text in it

Filter(Choices(sharepoint.Column1, TextSearchBox1.Text), sharepoint.Column2 = "1")

thank you for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report

@Jacktheripp

Please try the following,

Filter(sharepoint, StartsWith(Column1, TextSearchBox1.Text) && Column2.Value = "1")

Was this reply helpful? Yes No
Jacktheripp 5 on at

Like (0)

Report

Excellent, so close thank you but its kind of reversed
so
animal age
Chicken 30
Chicken 15
Dog 30
Chipmunk 30

the choice column is the animal and the txt the number I want search the choice animal for the word chip and then for 30 days. like yours but reversed Thank you

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@Jacktheripp

For the choice column you need match one of the choices not a part of it.

Please try the following,

Filter(sharepoint, animal.Value = "Chicken", StartsWith(age, TextSearchBox1.Text) )

Was this reply helpful? Yes No
Jacktheripp 5 on at

Like (0)

Report

you missed out on the poor Chipmunk lol

You cant search for part or "conatains" on a choice column. any work around? Like read it as a variable. The only one i can think of that is clunky would be make a calculated column on it and filter on that (probably something will stop that) seems to be a strict limitation.
my application means that i would need to write 40 filters for the 40 choices as they are prefixed with 2 different words it would be nice to filter.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Jacktheripp,

Have you solved your problem?

Do you want to search the Choice column firstly and then filter based on the age?

Actually, if all the choices from the Choice column are prefixed with 2 different words, it is better to use the StartsWith() function.

In addition, we could search for start string for a Choice column.

Filter(SPList, StartsWith(animal.Value , TextInput5.Text),age="30" )

Was this reply helpful? Yes No