More on Advanced Filtering with Dynamic Dropdowns in Power Apps
Hi all and welcome to My SharePoint Questions! Today's video is based on filtering galleries using dynamic dropdowns which are populated by the users input in a single line text! We populate a collection and run a distinct formula on our selection to weave out duplication. We even create a blank value in our dropdown so we can remove the filter and see all results.
We go over: Distinct, Collect, ClearCollect, Filter, ForAll, and more!
Come check it out and I'm sure you'll learn something new!
Chapters:
0:00 Introduction
1:14 Create Dropdown for Filter
2:22 Create a Collection
3:55 Demonstrate ForAll ClearCollect
4:22 Distinct Collection Statement
6:12 Demonstrate Distinct Function
7:12 Filtering the Gallery
8:11 Create a New Task
8:58 Move Collection Statements to OnVisible
9:35 Demonstrate OnVisible
10:37 Create a Blank in the Collection
11:18 If Blank Value Show All
11:15 Sort so Blank Value is First
13:20 If Then on the Colors of the Labe;
14:27 Conclusion