Introduction:
Nate Halliwell from Pragmatic Works is back with another insightful YouTube tutorial. This time, he delves into the world of Power Apps, demonstrating how to efficiently filter galleries in a canvas app using multiple selected items from a combo box. The key highlight? Achieving this without encountering delegation issues, particularly when working with dataverse tables.
Setting the Scene: Canvas App Overview
Nate starts by showcasing a simple canvas app, emphasizing its relevance to Pragmatic Works' Asset Management tool. This tool, designed for tracking and assigning assets within an organization, serves as the backdrop for the tutorial. The goal is to create a multi-select combo box that allows users to filter assets based on type and quantity.
Building the Foundation
1. Adding a New Screen:
- Nate introduces a new blank screen to maintain an element of suspense.
- Inserts a vertical gallery and connects it to the assets dataset for demonstration purposes.
2. Configuring Gallery Fields:
- Enhances gallery readability by adding labels for asset type and total quantity.
- Demonstrates how these labels pull data from a lookup table called "asset types."
Multi-Select Combo Box Magic
3. Inserting a Combo Box:
- Nate adds a combo box, emphasizing the flexibility of both modern and classic styles.
- Sets the data source for the combo box as the "asset types" lookup table.
4. Enabling Multiple Selections:
- Highlights the crucial step of toggling the combo box property to allow multiple selections.
5. Crafting the Filter Logic:
- Shifts focus to the gallery's items property and discards the default connection to assets.
- Introduces a filter statement to dynamically display selected items in the gallery.
6. Handling Lookup Fields:
- Navigates through the intricacies of referencing lookup fields, particularly when dealing with dataverse data.
7. Overcoming Intellisense Challenges:
- Addresses potential stumbling blocks in intellisense by manually inputting necessary columns.
- Demonstrates the flawless execution of the multi-select filter, even accounting for blank selections.
8. Live Testing:
- Engages in live testing, selecting various items in the combo box and witnessing real-time updates in the gallery.
Adding a Slider Filter
9. Introducing a Slider Control:
- Raises the stakes by incorporating a slider control for an additional layer of filtering based on quantity.
10. Dynamic Maximum Value:
- Configures the slider's maximum value dynamically by using the max function on the total quantity column of the assets table.
11. Logical Tests Expansion:
- Extends the filter statement to include a logical test based on the slider's value, ensuring assets with quantities above the selected threshold are displayed.
12. Dual Filter Validation:
- Conducts a thorough test to verify the seamless integration of both the multi-select combo box and the slider.
Conclusion
In this tutorial, Nate Halliwell provides a comprehensive guide to empower Power Apps users in mastering multi-select filtering without the delegation pitfalls often associated with dataverse tables. By combining the flexibility of combo boxes and the precision of sliders, users can create dynamic, user-friendly interfaces for effective data navigation.
Nate's step-by-step approach and live testing assurance make this tutorial a valuable resource for anyone looking to enhance their canvas app development skills.
Want More?
Subscribe to the Pragmatic Works YouTube channel and sign up for the Pragmatic Works' on-demand learning platform for additional courses covering a variety of Microsoft applications, including Azure, Power BI, Power Automate, Excel, etc.