Power Apps Search and Filter Function with SharePoint + Workarounds

Learn how to use the Power Apps Search function. We first focus on SharePoint because it is the most popular and the most broken search experience. Then we focus on three ways to get Search like ability without search. We use nested queries, Startswith in Filter, and finally how Search might be the thing that drives you to switch data sources to SQL and Dataverse.

[jonathancopin]

The most important comment : "Power apps is always right when it says it's wrong, but it's not always right when it says it's right". I never thought of taking the Data row limit to 1 to test delegation issues it's a really clever solution 👍👍 Thanks Shane

[aravindenterprises]

Was breaking my head with the formula, then found out the field from sharepoint as mentioned, ur a life saver thank you very much

[anapmds]

Shaned, I am from Brasil and your video help me a lot ! Obrigada! Thanks!

[Nola_Travel]

10:00 finally someone solved this for me. Thank you!!!

[vasylsalyk]

I'm using another workaround - 2 galleries.
Gallery1 - pure data source w/o filters or search.
Gallery2 uses Gallery1.AllItems as data source. And here I can apply all the necessary filtering.
Furthermore, if pagination is required, then I use Gallery3 (data source Gallery2) in combination with FirstN and LastN.

[josuecontreras]

I didn't know the importance of delegations until you show me the dataverse. From now on I will recommend to not work with SharePoint if you have a lot of data.

[matthewv]

You could put a department drop-down on the filter using a distinct or group by department type for items in the dropdown

[CarlosSolisNow]

Great review Shane. My students will benefit from this mightily

[oluwatobiyusuf]

Thanks for this video. I learnt more on the search function

[golfnutt]

Hi Shane, thnks for everything you do to help us navigate the Power Apps complexity.
I am not using a gallery for and not using SP Integration.
I can connect to my list my my form properies does not have "Items" it has "Item".
Right the edit form shows "Item" and uses First('Office Supply Products') to show the data.
Your gallery shows "Items" so I must be missing something. Can you provide any direction?
Thanks again!

[thelegand]

I found this video super helpful but it didn't help me fix my problem,

I have a Table with 6 columns and a considerable amount of rows, I have three drop downs, first one to filter category, second to filter sub category from that category, then 3rd to filter the item description from the sub category, the other 3 remaining rows are price, lead time and item code. my problem is with distinct, it removes duplicates which is great, but some of the entries have duplicated item descriptions, blocking out some of my items, the only way I can figure out having them all show is by doing this distinct(all the junk inbetween), description & price) but then the problem with this is that it breaks my price and code box which references another drop down but just to pick up those figures to add into the gallery, sorry if this makes zero sense but it's 4am and i've been messing with this for 6 hours lol. help!

[rochellenicholson]

Thanks for the video. Is there a way to only show 5 items of a gallery, regardless of how many items are returned when filtered or sorted?

[glaringmind-rqxu]

I am trying to achieve similar things except my selected employee from the lookup will return a pinned location on a site map( showing office location, floorplan, cubicle#.
The requirement is after searching the employee in the drop down will show the employee details ( title, location, phone number etc) also it would show on the map as a pinned location pointing out the employee’s office location and cubicle#. Is there anything like this that you have worked on. If not would you be interested to show how this can be done. I am continuously learning from your videos and trainings. It would be awesome. Thanks in advance!

[edbeardsley]

Great Video, thanks for the pointers. I have used your process successfully before, but form some reason I am not getting just the fields to populate. It is giving me the "fieldname"_datacard. Any suggestions?

[franknielsen]

Nice video. I realy need my company to buy into use dataverse

[jasongregory]

Here is the question I have... How did you make the contact list. I have tried several ways to create a contact list to connect to the app? All I have now is a contact "List" that is sorted by my building location and people assigned to work in that building. I cannot seem to get that to import to the app correctly.

[kathrynspader]

Have you ever used Text color as a variable to do searching or sorting?

[julianschmittgall]

Thanks so much for the great video! I have a list with a column that allows multiple values with checkboxes (characteristics like SEO, SEA, FBAds, ...). I tried to use your search logic with adding a column for those values but can't get it to work. I suppose it only works for columns with one value? Is there any way I can filter or search for one or more matching characteristics that are in this column (eg. SEO or FBAds)? Thanks so much again! - Julian

[andyhernandez]

Please let me know if you can create Folder in Windows desktop using PowerApps or Power Automate? I’m also interested in creating Folder Shortcuts. Can this be done at all?

[wennysoh]

Hi Shane, thanks for the guidance. If the data more than 2000, can we still use tgis seach /filter function?