Power Apps Search and Filter Functions on Large SharePoint Lists
ฝัง
- เผยแพร่เมื่อ 20 ก.ค. 2024
- In this video, you will learn how to use the PowerApps Search Function, Filter Function & combine both. These functions are useful to allow users to search through all items in your data source and/or filter your data. We will build a search box, look at delegation (working with large data sources e.g. SharePoint Lists) & understand why Search function may not return all items with SharePoint as a data source. We will explore delegable functions like StartsWith & look at a technique of performing search against a filtered (delegable) result set.
Video covers the following:
✅ What is Delegation? Key concept to understand
✅ Search Function
✅ Filter Function
✅ Search and Filter functions combined
✅ Search on multiple columns
✅ StartsWith & IN Functions
✅ Delegable Filter Query & Search (Non-Delegable) on filtered result set
My PowerApps Delegation Playlist:
• Power Apps Delegation ...
Power Apps Filter Gallery:
• PowerApps Multiple Fil...
• Power Apps Sort and Fi...
#PowerApps #Search #Filter #Delegation #SharePoint
Table of Contents:
00:00 - Intro
00:31 - Power Apps connected to SharePoint List
00:54 - PowerApps Delegation - Working with Large Data Sources
03:55 - Search box in Power Apps (Search function delegation challenge)
07:28 - Search function limitations with Large SharePoint Lists
07:51 - StartsWith function supports delegation
09:32 - StartsWith Search on multiple columns
10:24 - Search & filter on Power Apps Galleries
12:15 - Filter & Search SharePoint List in Power Apps with delegation
19:34 - Subscribe to Reza Dorrani channel
![[UNCUT] ฝันรักห้วงนิทรา | EP.11 (3/4)](http://i.ytimg.com/vi/4oyX6CnuonM/mqdefault.jpg)
The varDataCount with the slider control was my personal favorite. Well done Reza.
Thanks Dan 😊
@@RezaDorrani Yes me too. Totally agree with Daniel here :)
What minute can I see the slider?
@@danielgil9651 13:44, but u should watch the video from the beginning, to understand why he put the slider in
Whatever I need, find a solution from you.
Again thank you, amazing contribution!
Great to hear!
Wow! This helps a lot! I never knew I could combine multiple filters in on text input. Also, I always set the records from 500 to 2000. It looks like I have some fine tuning to do that will improve performance! Thank you!
It's exactly what I needed, had a problem with delegation on a large list and search with cascading filtering components. Thank you for the great lesson!!!!
You're most welcome!
Wow. This is just excellent. This resolves so many 'issues' with apps that work with large Sharepoint lists. Thanks for your patient, methodical teaching.
You are most welcome!
Love how you explain in such detail. This is one of the most helpful tutorials I've found.
Thanks Andrea
Thanks a lot, Reza. Been working on my project through the help of your videos but got stuck in the search part. It seems like the universe is telling to continue it now after seeing this video. Amazing work! Looking forward to your next uploads
Thank You so much. Keep going with your project.
Hi Reza, this is absolutely fantastic. I had been banging my head against a brick wall trying to achieve this but your tutorial was explained and covered in depth and has solved my issue. Keep up the good work.
Glad it helped!
That's interesting! I never thought about getting data with inner queries and then applying additional non delegable queries to get the results. Thanks Reza for such unique information.
You're so welcome!
Works great with combo boxes as well. Thanks Reza, you saved us again!
Great to hear!
Excellent - managed to adapt this to use one field to search one of 3 columns (rather than 2 drop downs and a text field) UPRN, PostCode and Address to narrow down and get below the power apps limits with a 139K row share point table. Surprisingly fast. Also put in a default value in the text field - so it started with only one record to pull.
Awesome!
Not sure I got to watch this when you released this a year ago. I'm about to embark on a project which will require that I provide filtering/Search capabilities to I decided to refresh from my no 1 go-to source and I certainly wasn't disappointed. Great insight and thanks for that. 🤣
Most welcome
Thank you so much Reza. You and Shane Young are my heroes for complicated Power Apps issues! :)
Thanks
Thanks Reza! This was EXACTLY what I needed. I appreciate your ability to explain in detail very quickly! I’m very new but expected to perform at the highest level. I hope you can help me do that. I will subscribe to your channel.
Thank You
Reza, you never fail to produce informative and beautifully explained concepts!
Thanks
Ingenious solution to a common and annoying share point problem. Thank you again Reza.
Thanks Simon
Amazing video !! You help the entire comunity bring this videos for us Reza, i just only to say THANK YOU !
My pleasure. Thank You so much for watching my videos.
You are a true gem for our community. Many thanks for this great video!
Wow, thank you!
@@RezaDorrani at the contrary, we should all be saying thank you
Great stuff Reza - Some amazing tips!
Loving the conditional use of In. I would say if there were metrics on what functions get used the most in apps, the In function is now trending sharply upwards! 😀
Thank You. I hope the trend is UP :)
Have been banging my head on this one for 3 days, THANK YOU
No more head banging please :)
Reza ur the best bro, understanding the pulse of the audience and knowing their needs is the next level u pushed to.
Thank You 🙏
Dear Reza, You are exceptional. You make very interesting videos on power apps and associated tools. Your explanations are extremely clear and well structured, I have never seen so good videos on the net than yours. You exactly explain what I am looking for without useless comments or parasites like most others do. You do a very good job and you are a very pleasant person. Congratulations, best regards. Greatings from Belgium ! All the best for the new year.
Thank you very much!
My focus has always been to cut out any fluff & get straight to the point :)
@@RezaDorrani You do it perfectly, congrats !
This is in all ways superb. Thank you ❣For the search reset button I had to use '+' instad of ',' - only then I was able to combine the reset functions. Now its working 😁
Glad it helped!
Great work Reza as usual. I didn't know the delegable part of your overall query will still work even if the overall query is not delegable. That is very helpful.
Glad it was helpful!
Dear Reza, Your chanel as well as Daniel's are so incredible in terms of knowledge. I'm so impressed and sooooo thankful for your work. Thanks a million times !🤗
Wow, thank you so much. We try our best to share what we learn.
Thank Reza for sharing videos with great tips. I found them brilliant, easy to understand and exactly what I'm after for my work. Well done 👍👏
Glad it was helpful!
Best explainers of delegation around. Excellent work Reza.
Much appreciated!
awesome video explaining a challenging concept. Good work Reza!! Appreciate the clarity and insight.
Glad you liked it!
Reza you done it again you're the best PowerApps guru I ever seen bottom of my heart as you make impossible possible thank you for you help and teaching us ♥, I hope one day you will show us a loan app calculation or sales ordering app please put it in dairy for future thanks
Wow, thank you so much.
I will add your requests to my backlog.
I got it again amazing lesson and enjoyed it during learning. Thank you so much Reza.
My pleasure!
Excellent content as always. You are my go to when i need help with PowerApps.
Thank You 😊
Exactly what I was looking for..thanks !
Glad I could help!
Best is entrance of every film ;) . But to the point. Thank You Reza for all movies. Very helpful
Glad you think so!
Thanks Reza. Really helpful video. Just what I was looking for.
Glad it was helpful!
Thank you so much Reza. I have always wondered on how to work on large dataset from SQL. Thanks for the insight
Glad to hear that!
Thanks Rezza, always something worthwhile learnt.
Glad to hear that. Thanks for watching.
It is extremely good session for filters. Thanks Reza Dorrani❤
Most welcome!
Reza, very well explained and got what we exactly want.
Glad to hear that! Thanks for watching.
What a clean explanation! Top notch
Thank You
Superb explanation! Thank you Rezza!!🍻
My pleasure!
Brilliant, thank you Rezza!
You are most welcome!
Thank you so much for this Reza. I learned a lot and was able to implement a similar functionality using dataverse table.
Awesome!
Awesome, I like the way you describe it. Thank you.
Thanks for watching Mohit.
Assalamu alikum.
You are the power man of the PowerApp and going this platform to next level 👍
Thank you ❤️
Wow, thank you for your kind words.
So well explained. Thanks Reza 💥👍
My pleasure!
Thanks a lot for the Reza, recently I was looking for this :) :)
Glad I could help!
You are the best, this video is useful!!!
Thank you! 😃
From Argentina, thanks!
You are most welcome Tomas
Awesome video! Thank you!
Glad you liked it!
Excellent! Thank you!
Glad you enjoyed it!
Simply amazing.. thanks a ton.😀
Most welcome 😊
excellent video, a sincere thanks Reza!
My pleasure!
Yes , good idea in powerapps filter and search with sharepoint list , now I will think about how to modify my code to meet my boss demand !!!
Great 👍
Awesome delegation handling video Reza👌👌👍
Thanks 👍
This is awsm ... following your videos bring 'VALUE ADD' to projects
Thanks a ton
Thank you very much! Helpful as always! My project is based on your videos😂
That's great!
Awesome Never gave a thought on combining it. 🙃
Me neither until I came across a requirement to get this to work :)
Excellent Coverage!
Thank You
Smart way ! Thanks reza !
An alteenative if they want to use search only is to ask them to use sharepoint :) the search support billion of entries as it is indexed
You are most welcome.
now this is great thank you so much for the work and effort
You're very welcome!
Excellent Video as always...
Thanks
feel hard to learn this logical operation but thanks a lot for your solution, so much helpful
You are most welcome
Brother you are teaching like you made this Power Apps. Superb
Wow that’s a big compliment. Thanks Niraj
Hi Reza, as always your videos are great content, easy to understand and very imporant! Thank you so much for your work! I currently try to do a full text search an a sharepoint document library. Do you have a way to search & filter in .txt .pdf .doc files etc.?
Thank You.
Not sure about searching in files. Something for me to investigate on.
This helped me big time. Thanks
You're welcome!
Thanks for sharing this Reza.
My pleasure!
Thank you Reza, very helpful. Do you have any tutorials for the count you have on this video which changes depending on the selected records?
At what time in the video do I show the count?
Hello Reza, thanks for sharing. I'll try to implement this solutions.
Awesome
Another great video. Is it possible to filter a gallery but only have the power app show 5 items.
Why would you want that? :)
You can use FirstN(filter( your condition), 5)
Bro your video is amazing and very helpful to me. Hope to see a lot of upcoming videos.
I will try my best
Very useful info thanks for sharing.
My pleasure
Thanks for your video... amazing
Most welcome
Great Reza ! Thanks a lot !
Welcome!
Thank you so much Teacher you are the best ❤
You are most welcome!
Very nice innovation Reza (up to your usual standards of course). I have bookmarked this and you should get some more views from forum responses on this subject. Warren Belz
Thank You Warren. Much appreciated!
Another superb video
Thanks
Hello Mr Dorrani,
Your videos are amazing, thank you to help the Power Apps community !
I'm new in Power Apps, and I want to create a research bar which can accept all values of my sharepoint columns (column 1 = material (steel, wood, stone, etc), column 2 = quantity (50, 600, 5, etc.) etc).
Writing steel, 750 or other value, I want to display the results.
I have big difficulties to do it, I tried by many ways, but I know I'm close...
Thanks for liking and watching my videos.
I do not have a video on your scenario and it is something I have not tried.
I would recommend to post your query on the forums at powerusers.microsoft.com in case someone has done something similar.
@@RezaDorrani Thank you for your quick answer, have a nice day !
Another excellent video. I learned more from you than the course I paid online. OK, I have a simple question, if I wanted the search box just to search for the ID and nothing else. Do I get rid of the rest and just leave the txtSearch.Text in ID? Thanks.
Thanks.
Yes, you could do that. But ID is not a delegable column. So it would only search based on the delegation limit.
Works well as long as you are okay with the default sorting which is oldest to newest. I want to display newest to oldest, so when I put in a sort function, the gallery will only show the oldest 500 rows.
That should not be the case. I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
This is so helpful. Thank you Reza - the like button just isn't enough. I used the Thanks button for the first time ever. Hope you enjoy a nice coffee on me.
Awesome, thank you!
Very helpful.. thank you
Glad it was helpful!
This one rocks amazing video
Thank You
Thank you! clearly, beautifully, visually.
I get ideas from you on application design)
1.If I set a limit of 2000 and know that I will not have more than 2000 lines, can I not do these manipulations with delegation, hiding the search string?
2. And the question is why is it not desirable to make a limit of 2000 lines?
3. do I understand correctly that if there is less than the entered limit, for example 2000, the filtering function will show all the values searched for through the search bar
1 - if less than 2000 items, then you can directly use Search function.
2 - Since all those 2000 records will be loaded in memory in your Power App.
3 - same as point 1. If you have less than 2000 records, you can avoid delegation.
Amazing! Thank you for this. Will definitely use this on my project.
I have one question, regarding a problem I’m facing. I have a 10k items sharepoint list. Each row is assigned for a particular individual (about 50 distinct individuals). When I put a dropdown control so I can filter the person, the dropdown itself dont load all the 50 people. Only a few, from the first 500 rows from the limit that was set. How can I overcome this? It’s an important filter so I can check each one’s work.
You can try the person type technique I showcased in this video. Distinct function is not delegable with SharePoint.
I do not have a video on your use case. I will recommend you check on the forums at powerusers.microsoft.com/
@@RezaDorrani thanks!
thank you very much!
You're welcome!
Top Reza, the combi of filter and search; did not think of this before. Still Microsoft should give us the delegable 'in' operator for SharePoint 😊 (missing that so much on >8K lists) ; must be easy as the SharePoint underlying database is SQL Server. Probably Microsoft wants to keep a distance to the SQL connector ... but that is under premium license 😒. Gr. Lex
Thanks for watching
your Good Man thank you Reza
Thanks Osaid
Love your videos, Looking for info on using text color in sorting/filtering. Do you have that in any videos of yours?
I do not
This is very valuable info
👍
Great content, thanks for sharing your knowledge. I would give it 2 thumbs up if I could.
Thank You so much 😊
Amazing video! It really helped me solve an issue I ran into with delegation :) I would like to implement the Search function when the dataset has been filtered to within the delegable limits but I am working with the Data Table control rather than the Gallery. I can't set up the varDataCount variable because the CountRows function does not seem to work on a table control. Is there a way to perform CountRows when using a Data Table control? Thanks!
I have not tried with data table hence not sure. I will recommend checking on forums at powerusers.microsoft.com/
Thanks!
Thanks
Awesome !!!!
Thanks
Thanks Reza, its very useful video for understanding about the sharepoint delegation.
I want some clarification on the following question.
In your video search function works within the filtered records, suppose
Priority(medium) and status(in progress) filtered results has more than 550 records then how can I get that 50 records using search function.
Is nessory to include 3rd dropdown for filter the records?
Yes. You would need to ensure better filters are provided.
You can also change delegable limit to 2000 in App.
Thanks Reza! This is a great video 👏
I have a question, what do you recommend if we have a Sharepoint List with more than 2000 items?
The only filter we have is that if the item is completed we don't need to use it again in the gallery.
Video explains the issue with searching (non-delegable function) in SharePoint.
If your query is delegable, then look at the videos here th-cam.com/play/PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD.html
@@RezaDorrani thank you again! It worked!!!
Hi Reza! Your videos are great! They help me to create my own app!. Can I ask you a question? It's possible to create an app that search text written inside a document? Thanks so much! Bye!
Thank You Fernando.
You could look into AI Builder for fetching text from documents and then running a search on it.
@@RezaDorrani Thank you so much!!!!! I will look that! *-*
This video was very helpful, One Question: Just like the way we filtered text columns, is there a way we can filter choice type columns using Starts with function? Meaning I don't want to create additional dropdown filters, I want the filtering to happen on the search box, and it has to filter text as well as value(dropdown values).
May be possible but not something I have tried or have a video reference for.
Dear , Reza, thank you your vidoes are so much a reference for me. I have a question, how can I customize or create a Gallery like on the video? Thanks
Search for a video on my channel on gallery design ideas.
Hey @reza.. this is an amazing video... A question from my end.. I have more than 500 records even after applying the priority and the status column filters and I want enable textinput to search for records.. will the search woks beyond 500 records?? Many thanks in advance
As described in video, provide good filters so results (after applying filter) is below 500. Once that is the case, Search can work on those records.
Nice video Reza 👍👍
Glad you enjoyed it