In this blogpost, we will learn to leverage Copilot to seamlessly search, filter, and sort the gallery within a Canvas App. Before we begin, ensure you subscribe to CRM Crate to remain informed about the latest developments in the Power Platform field.

The Copilot control is an advanced AI assistant that can be integrated into your canvas app. It offers a chat experience powered by AI, enabling end users to gain insights about their app’s data & aids in building application components through natural language conversations. App makers can easily add this control to any canvas app and specify the data it will provide answers for, enhancing user interaction and data accessibility.
Use Copilot to quickly filter, sort, and search in canvas app galleries
Power Apps users can now use Copilot to quickly filter, sort, and search items in canvas app galleries. Copilot uses natural language to generate queries, allowing you to easily find the records you need in a gallery. This feature is available only for Power Apps canvas web apps and can be used at runtime for all applications republished after version 7.4, which will be available starting July 29, 2024.
To use Copilot for automatically searching, sorting, and filtering tables with Power FX formulas, follow these steps:
- Open your Canvas App in Power App Maker Portal.
- Add a new gallery control.
- Select the gallery control in the component bar.
- Click on “More Options.”
- Choose “Copilot” and then select “Sort, Filter, and More” as shown below.

- You can input data into Copilot, allowing it to collect human inputs and automatically create Power FX formulas using the Search, Filter, and Sort functions. For demonstration purposes, we used the input “Search project where ISV Cost is 1500 and Inventory Cost % is 80”. In this example, ‘ISV Cost’ and ‘Inventory Cost %’ are two attributes in the Project table of Dataverse.
- As shown below, Copilot generates the Power FX formula using the ‘Search’ function.
Filter(Projects, 'ISV Cost' = 1500 && 'Inventory Cost Share (%)' = 80)

In conclusion, utilizing Copilot to search, filter, and sort the gallery in a Canvas App significantly enhances the efficiency and accuracy of data management within your application. By leveraging advanced Power FX formulas, Copilot can intuitively process human inputs to streamline data retrieval and organization. This not only simplifies the development process but also ensures that users can quickly and effortlessly access the most relevant information. Ultimately, integrating Copilot in this manner optimizes the overall user experience, making data interaction within Canvas Apps more intuitive and effective.