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

Add a filter box in a gallery

Dear all, first... a big hello to all of you.

I'm really new in power app and I've created a new app with a gallery. My problem is that I would like to add a filter to the gallery to select the records with a specific owner, plus remove from the list the "completed" actions

The data source is a sharepoint table with:

Owner = text field

Status = dropdown with unic value choise

name of gallery = 'PR&C Accountability Board'

Can you help me with a step by step process considering that I'm really new?

Thanks a lot for helping

Alex

 

1 ACCEPTED SOLUTION

Accepted Solutions
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

13 REPLIES 13
Highlighted
Super User
Super User

Re: Add a filter box in a gallery

@AlexTB 

How is the owner being stored in your SharePoint list?  Is it a Text Column, a Choices column, a People Picker?

Highlighted
Frequent Visitor

Re: Add a filter box in a gallery

Hello @mdevaney 

it is a Text Column. I tryied to use a combobox but I read from the post that this is not easy to manage when filtering by Power App, therefore I decided to stay on the Text colum (there are no many names in the organization) Thanks

Alex

 
Highlighted
Community Support
Community Support

Re: Add a filter box in a gallery

Hi @AlexTB ,

 

1. Add a TextInput Box at the top

2. Set items property of Gallery:

 

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

 

Hope this helps

Sik

Highlighted
Frequent Visitor

Re: Add a filter box in a gallery

doesn't work (see picture of the result).

Just a question... do I have to set the textinput box in some way?

 

Highlighted
Community Support
Community Support

Re: Add a filter box in a gallery

Hi @AlexTB 

 

The Status is Choices type column, right?

What is the error message on items property? Please share it via screenshot.

Sik

Highlighted
Frequent Visitor

Re: Add a filter box in a gallery

Yes, the status column is a choises type colum (single choise)

attached the screenshot (sorry... it is in Italian)

it seems there is an error on characters, could be possible the "&" in the gallery name is generating the error? If yes, how can I change?

 

Highlighted
Community Support
Community Support

Re: Add a filter box in a gallery

Hi @AlexTB ,

 

Please try this:

 

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

 

Change the comma to a semicolon to fit your local language.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/global-apps#formula-separators-and-chai... 

Sik

Highlighted
Frequent Visitor

Re: Add a filter box in a gallery

so... much better:

1 - the entire formula gives an error (a yellow alert) saying that "&&Not" is not supported by this connector

2 - changing the formula to --> Filter('PR&C Accountability Board';Owner=TextInput1.Text) the filter works but only if I digit some letter. Remaining empty does not appear nothing and this is not what I want. With no input the gallery should show all records

I hope I'm clear 🙂 

Highlighted
Frequent Visitor

Re: Add a filter box in a gallery

additional issues:

looking the app checker i noticed a lot of missing accessible labels and I had modified the parameter as suggested from -1 to 0

and I have introduce a name where suggested. Now... the filter, also without the && part is not working even if there is no error. Errors appears in the other pages like: name isn't valid. Is this connected? why there is a suggestion to put a name if them there is conflict?

Additionally, what I wroto above remain:

The first part of filer works (I hope, resolving the above) but only if no digit the gallery remain empty. The second part, excluding "completed" doesn't works .

Thanks for support

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!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,166)