Power Apps: Creating A Filter Control

#PowerApps #Filter
In this video I show two ways that you can create a Filter Control to refine the results in a gallery.

[@jabelltulsa]

This is another great use of that gallery "tab" selector method in the video from the other day (which I just put in place - works perfectly). I don't have a use for this quite yet, but when I do, this will come in really handy. Thanks!

[@AprilDunnam]

That's awesome Jason! Glad to hear you were able to find a use for the tabs already! Hopefully you'll find a use for the filter control soon too ☺

[@CarlosSolisNow]

So Timely. I needed this for an web portal app. AWESOME 🖐🏾🖐🏾🖐🏾

[@AprilDunnam]

Perfect! Glad it was helpful!

[@Slash1066]

Really useful, the logic in the control is simple but very clever. I do have use for this right now. Thanks for the guide.

[@AprilDunnam]

That's great glad this was useful for you Mat!!

[@feic9821]

Simple yet Awesome! Thank you!

[@AprilDunnam]

Glad you like it!

[@turisabela]

Your videos are life saving. You're helping me a lot . God bless you.

[@AprilDunnam]

Thank you Isabela - so happy to hear this! If there are any topics you would like videos on let me know!

[@narapat100]

Thanks a lot April... your videos are really helpful.. Appreciate your efforts.

[@AprilDunnam]

Thanks Narapat!

[@Laughing_out_loud_]

To the point and clearly explained video in less mins. I am glad I didnt have to go through a 20 mins video

[@AprilDunnam]

So glad to hear this was helpful! I do my best to get straight to the point :)

[@shaikzuber7945]

Thank you for making this video.

[@AprilDunnam]

Thanks for watching Shaik!

[@abbyv3424]

Hi April, Thanks for sharing this, your videos are great!! I would like the gallery to only show items that the user has created or that their manager needs to approve. 1. Is there a way to restrict the results to only show items you have created? 2. Is there a way to restrict the results to only show items someone needs to approve from a different button? I do have a list for 'Requestor' and 'Approver' that are both Person columns. Thank you!

[@tolirocks]

April, I've gotten this to work, however in my results list I have to click it twice for the record to show, it doesn't happen with all my filter choices but 3 of the 5 seem to do it

[@alpin714]

Hi April, Thanks for your great videos and to help me learn powerapps!! I have a question\doubt I have configured this filter control of yours but my search box does not search now, how can I solve this issue?

[@rushdial-hijjawi7475]

Hi April, I was trying to implement same as at ur Video but when i reach to add the command If(AssignedGallery1.Selected.Value = "Unassigned",Filter('Issue tracker', StartsWith(Title,TextSearchBox1.Text)),Filter('Issue tracker', StartsWith(Title,TextSearchBox1.Text) && Status = AssignedGallery1.Selected.Value)) its not working , what i was to achieve is when the when i click on Unassigned then only Ticket with status unassigned would be visible, is there a way to send you screenshot of my Power app?

[@ericbeauchesne3325]

Thanks April, your videos are so usefull, I'm a rookies in Power Apps, but your explanation are so clear, that i could build my own timesheet base on your saying and my company will use it. If you ever need a contract contact me, we need minds like yours to implement new solution. When I complete my application I'll send you a link. Sorry for my english i'm from Quebec with no chance to practice.

[@zaidkashour]

Awesome April. If you have to use two or three galleries the same way for filtering, will this method be ideal? or should we collect the selected gallery value to a collection and then use that Collection value in the If statement?

[@AprilDunnam]

Great question Zaid! There's no right or wrong answer here but in my opinion, if you have multiple filters like that and/or if you will have your filter and results sources on different screens then the collection approach is probably more performant.

[@sachinmangalwedhe8194]

Excellent

[@AprilDunnam]

Thank you! Cheers!

[@eriks707]

Thank you for the video, very well explained. I am trying to filter my gallery based on a search field and check box. I will add a column to my SharePoint list so I can save the list entries as Yes/no when in my edit screen, What I am then trying to do, is filter the gallery based on a check box which I plan on placing on my dash screen by the search field. If checked, it only shows SharePoint list entries marked as true, if not it shows all entries. I cant figure out how to tie the check box to the SharePoint True/False and to the filter code. Do you have any Idea how I can accomplish this?

[@AprilDunnam]

Hey Erik - There's actually a known issue right now with searching on Power Apps boolean fields that you can read more about here: powerusers.microsoft.com/t5/Power-Apps-Ideas/Properly-filter-SharePoint-Yes-No-column/idi-p/158375 My work-around is to leverage a Single Line of Text field instead and just put a 0 if false and a 1 if true. You can key off of that in your Power Apps filter

[@kittydoes7600]

Hi April, another wow video! Do you have a complete video creating this Training app?

[@AprilDunnam]

I don't have one yet but I will show it in one of my Template Tuesday videos here soon!

[@kittydoes7600]

@@AprilDunnam yehey thank you. You're the best!

[@quanngo140]

Hi April, thanks for the great and useful sharing, i'm having issue at the the line && Status = Dropdown2.Selected.Value. When there's a invalid argument type at '='. Could you advise on this ?

[@AprilDunnam]

My guess is the Status field in your data source is a Dropdown field. If so you need to add .Value to it like so: && Status.Value = Dropdown2.Selected.Value

[@quanngo140]

@@AprilDunnam Thank you April, it works perfectly. Amazing !

[@robpawlikowski4020]

I have a main page with a gallery showing a list of items (data source is an Excel Spreadsheet), showing Name of the Item, Author and Last Update. Clicking on icon opens a page showing details of the given update. I want to link the selected ID from Gallery1 (gallery on the main page) with a gallery on the Detail page that filters a second list (also an Excel Spreadsheet) that shows a list of updates. Both lists contain an ID field that can act as a key. I haven't been able to get it to work. I've tried many variations, like "Filter(SecondTable,ID=ThisItem.ID" and "Filter(SecondTable, ID=Gallery1.Selected.ID)", but nothing seems to work. Solutions anyone?

[@gemmabilboe1961]

Hey, how this work if the data is ‘choice’. It says that there’s a incompatible types for comparison and that record and text cannot be compared. Please help

[@garyhuang11]

In this example, if the Status was a lookup from another table, how would the formula look? I tried this but I get an error with invalid argument. I take it I can't use LookUp?

[@AprilDunnam]

Hi Gary - You should be able to filter by a lookup. The Filter formula would look something like this: Filter('My Training', StartsWith(Title, tbSearchTraining2.Text) && Status.Title = Gallery2.Selected.Value)

[@naveenkumar-ou1nr]

HI, I have a list : Share Point List with these columns(Name, Start Date , End Date and Count). Now i want to get the sum of the count by filtering Name, Start Date and End Date.

[@michealwick928]

So I can get my gallery to filter with just the search using "Filter('IT Help Desk Tickets',searchQuery in Description || searchQuery in User.DisplayName)" and filter using the buttons with "Filter('IT Help Desk Tickets','Issue Status'.Value = Gallery2.Selected.Value)" but I can't get it to work with: If((Gallery2.Selected.Value="All",Filter('IT Help Desk Tickets',(searchQuery in Description || searchQuery in User.DisplayName))),Filter('Issue Status'.Value = Gallery2.Selected.Value) || Filter('IT Help Desk Tickets',(searchQuery in Description || searchQuery in User.DisplayName)) I am not sure where my context is going wrong. It is not liking the "else" comma in the middle of the statement. Can you help me troubleshoot my context? Great Video by the way. Thanks

[@jonathanlloyd8920]

Another great video. Question. Is there anyway to hide the gallery until a user enters a search in a filter text box input and then only show that particular result?

[@AprilDunnam]

Hey Jonathan - You should be able to do this using variables. So for example, in the OnVisible property of your Screen with the gallery you can set a variable like so : UpdateContext({showGallery:false}) so it's hidden on first start. Then in the search box you can have an icon you click to initiate the search. In that icon's OnSelect property you can set UpdateContext({showgallery:true}). Then in the Gallery's Visible property set it to showGallery Hope that helps

[@jonathanlloyd8920]

@@AprilDunnam Thank you!!! Love your content, its always fantastic

[@huntjonh6701]

Hi April! Thanks for the tips and tricks videos, they are very helpful!:) Need your help though on a project that I am making using power apps charts. Can I ask for your help? Thank you!:)

[@AprilDunnam]

Hey - I can try to answer some questions if you have them. But if you need some in-depth support, the Power Apps 911 guys offer 1:1 consulting

[@johndecastro6685]

Hi April, I tried the function in my Contacts (sharepoint List), I have "active,complete and All" in My Status Field. But its not accepting the = argument. Can you help?

[@AprilDunnam]

Hey John - What is the field type in SharePoint (choice or lookup)? Can you share your formula?

[@johndecastro6685]

@@AprilDunnam If( "GalaryName".selected.Value = "All", Filter( "Source", StartsWith( "Field", "tblSearchinput".Text ) ), Filter( "Source", StartsWith( "Field", "tblSearchinput".Text )&& Status = Gallery.selected.Value ) ) In This formula, I get an Equal error (=) I am not using Title for my field as Use a Single text Field, would that be a problem?

[@rubesandboogs6367]

Hi April I have a Blank Horizontal Gallery called FilterGallery that has Labels I have another Vertical Gallery called IncidentOwnerGallery with the layout, Title. Title36: Incident Owner My final Vertical Gallery called IncidentStatusGallery My data Source is Risk Incident Management Form What I am trying to do is in the labels of the FilterGallery, have the Function Names, column name (Function Name) in my sharepoint list, so when you click on any function, it filters the Incident Owner Gallery first, then the Incident Status Gallery of which can then navigate to a new screen that shows the entire record which can be viewed or edited. If you can assist that would be awesome....p.s. love your videso

[@AprilDunnam]

I think what you are needing is nested galleries. Unfortunately I don't have a video on this right now but the great Shane Young does. Hopefully this helps: kzbin.info/www/bejne/pJ3LiISdZZiHgpI

[@rubesandboogs6367]

Thanks April, I’ll give it a try

[@AMindGame]

This isn't Straightforward Queen.. I need to connect my filter to a choice column that have 4 choices. I'm strugling with the guidance.

[@pawanachettri]

Would be really nice to implement this, but in my new gallery9 i see many duplicate status eg. completed completed, pending pending and so on (scrollable) plz suggest 😭

[@AprilDunnam]

Hi Pawana, If you post the issue you are having in detail with screenshots on the power users community I'm sure someone can help provide some suggestions: powerusers.microsoft.com/

[@gokurukay1234]

Nice Video April, i have success make control filter gallery but i have problem can't sort by date value="all" can advice how to add sort?. thank you.

[@AprilDunnam]

You should be able to do something like this: SortByColumns(Your Data Source Here, "COlumn to Sort By", Ascending)

[@gokurukay1234]

@@AprilDunnam i using button filter for gallery and i want sort gallery base on "ID", this i share source in gallery but didn't work : Switch(glrRequestFilters.Selected.value,"All",Travel,"Pending",Filter(Travel,Status="Pending"),"Approved",Filter(Travel,Status="Approved"),"Declined",Filter(Travel,Status="Declined"),Sort(Travel,ID,Ascending)) . can help thank you.

[@ivarshum3501]

Why I cannot filter in pending or closed? I it related to the source ?

[@AprilDunnam]

Hi Ivar - It might be a source issue, possibly a data type mismatch. What is your data source and what type of field is it? What error are you getting?

[@ivarshum3501]

Thanks April, the error fixed 👍🏻👍🏻

[@ezraorina100]

Who stole the intro from the other.. You or @Shane Young

[@AprilDunnam]

I don't see the similarity?