Power Apps Search And Filter Galleries [Power Platform Series - Ep. 5]

In this video, Matt continues his series on the Power Platform. He showcases how to search over records in a gallery located in a canvas application. Some pitfalls can arise from searching which Matt discusses how to avoid like default text.

Matt also discusses how to filter your galleries using a drop-down control and selecting what items you want in the drop-down to drive your filtering. A common ask is what if I don’t want the gallery to be filtered from the beginning, but show all the records. Matt troubleshoots this issue and shows how to use collections to populate your items in the drop-down and have one of those items be all records to show. To put one last added feature he shows how to reset your drop-down selection with a simple click of a button.

Finally, Matt demonstrates how you can have records from one gallery filtered by a selection in a separate gallery. This is useful when you have multiple tables in your application that have a relationship.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:



Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

#PragmaticWorks #MattPeterson

-~-~~-~~~-~~-~-
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
-~-~~-~~~-~~-~-

[AdiCristea]

Thanks for the video, Matt, great introduction to Search/Filter. If I may, three things to add:
1. Search is delegable ONLY for SQL, so I'd suggest either warn your viewers about it or let them know it is going to be discussed later on another video.
2. OnStart is becoming obsolete in the near future, so my suggestion is to have in OnVisible property of a screen
3. The filter based on All can be done also by adding >> || Dropdown1.Selected.Result = "All" << which is a good trick to have when you need multiple other controls filtering the gallery.

Again, great intro to Filter and I'm sure you already know this above things, but hopefully your viewers will be careful on the first two.

[seapony]

Thank you for this very informative video! It helped me solve a filtering issue I was running into with showing data based on a choice column in a sharepoint list :)

[dmitrikogan]

Hi! Your tutorial is brilliant! Thank You very much!!!

[escaphini]

How about have the Search field and dropdown filter functions on the same gallery and same screen?

[ruvdan]

Is there any way to combine the two methods you showed in your video? I want my users to be able to manually search over the entire gallery using the search bar. But I also want them to be able to use the search bar to browse the gallery based on the filter they select from the drop down (i.e. if they select "A" from the drop down, I want them to be able to use the search bar to look up data in the gallery that is associated with "A" from the drop down). I hope that makes sense.

[ManwinderKaur-jh]

Great session, thank you.
Is there a way to load a gallery that has already been filtered? Without using drop-down control? My dataverse table has image and when I load a custom view, it does not load the image.

[asifattar]

Thanks for this helpful video. Could you please share some tips if we need to search the Park ID in the textinput box. How that can be done.

[kathrynspader]

Have you ever done any sorting/searching/filtering by text color?

[KiyoshiNagata-rdhv]

I have a question, u made in items a search, then a filter*
But I didn't see both in action, how can combine both to make filter a data source and then search in the filtered table (?)

[natalyaoliveira]

Hello ... how do you use the Search with SortbyColumns and Filter when you have an And function
Thank you

[smbasha]

In Outlook we searching the person name once we select the mail those person name will render in search field is that possible in powerapps