Master lightning‑fast search and filter experiences in Microsoft Power Apps! In this hands‑on tutorial, Pragmatic Works’ Matthew Peterson walks you through building a Canvas App that combines Search(), Filter(), Distinct(), IsBlank(), and Sort() for clean, responsive data exploration. You’ll learn to wire up text‑box searches, single‑select dropdowns, date pickers, and range filters—plus pro tips for resetting controls and handling blank values with Power FX. Perfect for beginners and makers ready to level‑up their apps and deliver intuitive user experiences.
👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt
🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/
00:00 - What You’ll Learn
00:29 - App Overview & Data Galleries
00:55 - Adding a Search Box
01:48 - Writing the Search() Formula
03:13 - Testing Search & Clear Button
04:21 - Creating a City Dropdown Filter
05:21 - Distinct() for Unique Cities
06:43 - Building the Filter() Formula
07:50 - Allow Empty Selection & Reset
08:46 - Handling Blank Filters with IsBlank()
09:46 - Combining Search and Filter
10:45 - Adding a Date Picker Filter
11:55 - Building a Date Range Filter
13:35 - Linking Inspections to Selected Park
14:28 - Resetting Date Picker Defaults
14:59 - Handling Blank Dates in Filter
16:30 - Sorting Results by Date
17:01 - Next Steps & Learning Resources
Let's connect:
✔️Discord: https://prag.works/yt-discord
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks