cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Community Support
Community Support

Re: Add a filter box in a gallery

Hi @AlexTB ,

 

If you have set the OnSelect property of the control or set its TabIndex property to 0 or higher, you need to edit the accessible-label property to describe it. Otherwise, try to delete the control and recreate it.

If Not funciton isn't supported, change the filter condition to Status.Value= "Other Choices 1" && Status.Value= "Other Choices 2" && Status.Value= "Other Choices 3"

To make the gallery show all records if nothing input, add if function to check the text box is empty.

The code:

 

Filter('PR&C Accountability Board';If(IsBlank(TextInput1.Text),true,Owner=TextInput1.Text && Status.Value= "Other Choices 1" && Status.Value= "Other Choices 2" && Status.Value= "Other Choices 3" ))

 

Hope this helps

Sik

 

 

Highlighted
Frequent Visitor

Re: Add a filter box in a gallery

Thank you all... however... filter does not works.

I have rebuild all pages.  The Gallery is working, selecting the line it goes in the new page to modify the records. Adding button regularly works going in the new record page and save button works. All is good but the filter does not work.

So, I inserted a textinput box, I tried with

1 - Filter('PR&C Accountability Board',Owner=TextInput1.Text &&Not(Status.Value="Completed"))

1 - Filter('PR&C Accountability Board';Owner=TextInput1.Text &&Not(Status.Value="Completed"))

2 - Filter('PR&C Accountability Board',Owner=TextInput1.Text)

3 - Filter('PR&C Accountability Board';Owner=TextInput1.Text)

There is no formula on textbox... do I have to put something there?

I should be an easy command in my mind:

a) no text into the box --> results all records excluding the completed ones

b) any digit into the box--> results all records selected with the same digit into the Owner colomn

What I can do? Please tell me which information you need or I have to check and I will provide

Thanks a lot

Alessio

 

Highlighted
Frequent Visitor

Re: Add a filter box in a gallery

Ok guys, navigating I found this very good video and I follow ut step by spep.

Finally... IT WORKS!!! Hurrà!!!!

Thanks to all have dedicated time to me!

 

Final formula is

Filter('PR&C Accountability Board', TextInput1.Text in Owner &&Not(Status.Value="Completata"))

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (8,829)