Power Apps: Filtering and Delegation Warnings (Advanced) ⚡

In this Power Apps video, I demonstrate how to filter your gallery based not just on one dropdown, but two drop-down controls. Also, I had some viewers email me asking if it was possible to not have the drop downs filled out with a default value to begin, but instead be a blank selection.
There is a way to access a specific property on the drop-down control to fix this issue. Finally, towards the end of this video, I showcase how to limit users of your app only to see records that they have either created or been assigned to. While a fairly simple process to accomplish, a delegation warning may appear in your solution.
What is a delegation warning you ask? A delegation warning means that your data source cannot execute the command you have programmed into the Power App and your Power App has to do all the heavy lifting. There do come limitations with how much heavy lifting your Power App will do, specifically, it will only do the work on the first 2000 records.
I conclude this video by giving you a “work around” for this exact delegation warning. To see basic filtering see my last video • Power Apps: Filtering ...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
On-Demand Learning Courses FREE Trial: www.pragmaticw...
Pragmatic Works Blog: blog.pragmaticw...
Let's connect:
Twitter: / pragmaticworks
Facebook: / pragmaticworks
Instagram: / pragmatic.works
LinkedIn: / pragmatic-works
RUclips: / pragmaticworks
Pragmatic Works
Phone: [phone]
Email: [e-mail]

[@samanthavalentine671]

Thank you so much for your videos! You explain things in such an easy to understand manner. I appreciate your work!

[@newmbz9585]

Great video with useful tips, thank you!

[@PragmaticWorks]

Glad it was helpful!

[@MoTheSeeker]

Nice explanation for Delegation warning :)

[@xbennY0]

clear explanation.

[@PositivityStudio]

thank you very much for the video, for these kind multiple dropdown filter gallery, how to have the gallery show everything when no filter is selected? I have blank selection for my drop downs. thank much for your help !

[@EpicBizHero]

Thanks Matt... Much Appreciated! Temporarily unable to make it work when Choice columns are used in the dropdowns (from SharePoint). Any suggestions? Thanks in Advance!!!

[@hasan7806]

thank you

[@kmuralikrishna1582]

Really appreciate for this video..
But here how admins can see all the records

[@TheAlgebraTeacherPOWERStoBI]

Hey kmurali. You could code an If statement before the filter statement that would check the user's email address. If the user's email address was equal to the admins email address you would have the items not filtered, then if it wasn't you would use the filter statement. I'm going to be doing another video this weekend that goes into more delegation warnings and I'll try to add this request in the video as well.

[@kmuralikrishna1582]

@@TheAlgebraTeacherPOWERStoBI appreciate.
Think about security DL users not only direct users.
How can we check DL users in this ?

[@richaparwani]

will this work name column from sharepoint document library

[@TheAlgebraTeacherPOWERStoBI]

Hi Richa. I have not tested that before so I don't have your exact answer. Here is some documentation on bringing in document libraries though docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-online

[@danieladroguett5511]

Hey! Thank you so much for your video. With Selected.Result did not work for me (I have a single text column in my SP list). This worked: Dropdown.Selected.Value. I don't know why though...