Introduction Filtering and searching data in a Power Apps gallery is a common requirement for building user-friendly business apps. This post shows how to combine a dropdown filter (with an ‘All’ option) and a search box to create a flexible, responsive gallery experience. Scenario Suppose you have a collection called colFolderMapping with a field named Database and a gallery displaying items. You want users to: Select a database from a dropdown (or ‘All’ to show everything) Search for items by title using a search box See results update instantly in the gallery PowerFx Formula Here’s the formula for the gallery’s Items property:

Introduction Listing members of Microsoft 365 Groups directly in Power Apps is a powerful way to build dynamic, user-aware business apps. This post shows how to use the Office365Groups connector and PowerFx to retrieve group members and display them in your app. Scenario Suppose you want to: Find a specific M365 Group by name (e.g., “Legal Team”) List all members of that group in Power Apps Use the results for permissions, notifications, or reporting PowerFx Formula Here’s how to get the group ID and list its members:

Introduction Listing owners of Microsoft 365 Groups in Power Apps is a powerful way to build dynamic, admin-aware business apps. This post shows how to use the Office365Groups connector and MS Graph API to retrieve group owners and display them in your app. Scenario Suppose you want to: Find a specific M365 Group by name (e.g., “Legal Team”) List all owners of that group in Power Apps Use the results for permissions, notifications, or reporting PowerFx Formula Here’s how to get the group ID, list its members, and extract owners: