cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kieranrb
Frequent Visitor

Filtering Gallery by Text

Hi,

 

I have a gallery in my app and I'm trying to make it filterable so it's easier to look through. I have inserted a text control and set the onchange action to: Filter('Work Request Demo',StartsWith(Title2.Text,TextInput1.Text))

 

I don't have any errors, but my gallery doesn't change when I type anything in to the box. Is there something I'm missing?

1 ACCEPTED SOLUTION

Accepted Solutions
v-monli-msft
Community Support
Community Support

Hi @Kieranrb ,

 

Is Title2 a text column? If so, please use below formula instead in the Items property of gallery control:

Filter('Work Request Demo',StartsWith(Title2,TextInput1.Text))

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
RezaDorrani
Dual Super User
Dual Super User

Hi @Kieranrb 

 

Filter('Work Request Demo',StartsWith(Title2.Text,TextInput1.Text))

This needs to be added to the items property of the gallery

 

not the onchange of the text control

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi,

 

Thanks for the reply, however this didn't work, I get an error saying this creates a circular reference between properties. Is there something I've missed?

v-monli-msft
Community Support
Community Support

Hi @Kieranrb ,

 

Is Title2 a text column? If so, please use below formula instead in the Items property of gallery control:

Filter('Work Request Demo',StartsWith(Title2,TextInput1.Text))

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,395)