Learn how to create a Canvas App gallery that can filter by multiple column types—text, dates, lookups, and multi-selects. This step-by-step guide shows you how to handle blank filters and combine everything into one clean PowerFX formula.

Need to filter dropdowns in your Canvas App based on a prior selection? In this post, we walk through creating cascading dropdowns using SharePoint data, with a real-world example of a travel request form. Learn how to filter cities by state, configure lookup fields correctly, and ensure your form saves and displays the right data — all with easy-to-follow Power Fx formulas and practical tips.