{"id":125334,"date":"2024-10-02T06:29:48","date_gmt":"2024-10-02T13:29:48","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?post_type=power-apps&#038;p=125334"},"modified":"2025-06-11T07:40:22","modified_gmt":"2025-06-11T14:40:22","slug":"use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/","title":{"rendered":"Use Copilot to quickly filter, sort, and search canvas app galleries with SQL Server"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">We are excited to announce that Power Apps application runtime users can now use <em>Copilot <\/em>to<em> <\/em>quickly filter, sort, and search the items in canvas app galleries with SQL Server. This feature is in addition to the previously released capability to filter SharePoint canvas galleries. <em>Copilot <\/em>uses your natural language to generate a query to the database that scopes the current view of records in a gallery so you can quickly find the records you need. This feature is available only for Power Apps canvas web apps and only at runtime for all applications that have been republished after version 3.24092.17. This premium feature is on by default and authors may disable if required. It is currently rolling out and is expected in all regions by October 14th.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Like with SharePoint, this feature operates with any natively bound gallery where the gallery is directly populated by SharePoint and not by a collection or variable.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"using-copilot-with-filter\">Using Copilot with filter<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Open a running app that uses a gallery against SQL Server.&nbsp; If you have a premium license (which is required for the SQL Server connector), then you will see an adorner on your gallery.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.webp\" alt=\"Image of adorner on gallery\" class=\"wp-image-125336 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Copilot<\/em> supports three kinds of queries &#8211; filter, sort, and search.&nbsp; While you can type any query you might like, it suggests possible questions based on your data in your app at the time. Note that Copilot over SQL supports an additional verb &#8220;in&#8221; that SharePoint does not support. It will search for an occurrence of your search text inside of a record value.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-suggestions1.webp\" alt=\"\" class=\"wp-image-125338 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-suggestions1.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Copilot <\/em>then scopes the records to satisfy the query. It displays a &#8220;Filtered&#8221; badge in the upper right corner of the gallery.&nbsp; The exact query that was executed is displayed as a tag. And you can continue to refine your query with additional details by adding more query commands.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Filter, sort, and search galleries with <em>Copilot to filter<\/em> provides five key benefits:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><em>Copilot <\/em>makes end users more productive and saves time. If an author has not built in search and sort capabilities, <em>Copilot <\/em>enables this scenario and makes them more productive. End users save time with the ability to directly express their query in natural language.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><em>Copilot <\/em>saves author&#8217;s development time. Authors save time developing apps because they don&#8217;t need to develop all the UI controls necessary for the app. Instead, they can rely on <em>Copilot <\/em>for this functionality.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><em>Copilot <\/em>enables queries over the full query result &#8211; not just what you can see in the gallery. Users can filter, sort, and search on fields even if the application doesn&#8217;t provide UI controls for these tasks. For example, you can search for records even if the application doesn&#8217;t have a search bar.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><em>Copilot <\/em>is query safe. It only generates queries that can be run on the server. Authors don&#8217;t need to worry about whether or not their queries can be delegated.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><em>Copilot <\/em>keeps private data private. It only works with the data that is normally returned to the application. It doesn&#8217;t access fields that aren&#8217;t returned to the app in a gallery\/grid or form.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Create a new app with Studio version on or after 3.24092.17 or re-publish an existing app with this version. Then access your app while it is running. (<em>Copilot with filter<\/em> only appears at runtime, it does not appear inside of Studio.) Select an item in the gallery to start using <em>Copilot with filter<\/em>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">See the documentation for this feature for more details. <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-apps\/user\/smartgrid\">https:\/\/learn.microsoft.com\/en-us\/power-apps\/user\/smartgrid<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to announce that Power Apps application runtime users can now use Copilot to quickly filter, sort, and search the items in canvas app galleries with SQL Server. This feature is in addition to the previously released capability to filter SharePoint canvas galleries.<\/p>\n","protected":false},"author":105,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[],"job-role":[],"product":[3473],"property":[],"topic":[3421,3422],"coauthors":[2340,2431],"class_list":["post-125334","post","type-post","status-publish","format-standard","hentry","audience-it-professional","product-power-apps","topic-application-modernization","topic-hyperautomation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Use Copilot to quickly filter, sort, and search canvas app galleries with SQL Server - Microsoft Power Platform Blog<\/title>\n<meta name=\"description\" content=\"SQL Server, Copilot, Power apps, Canvas Apps, Filtering and searching\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use Copilot to quickly filter, sort, and search canvas app galleries with SQL Server - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"SQL Server, Copilot, Power apps, Canvas Apps, Filtering and searching\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-02T13:29:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T14:40:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.png\" \/>\n<meta name=\"author\" content=\"Lance Delano, Jordan Chodak\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Lance Delano, Jordan Chodak\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lance-delano\/\",\"@type\":\"Person\",\"@name\":\"Lance Delano\"},{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/jordan-chodak\/\",\"@type\":\"Person\",\"@name\":\"Jordan Chodak\"}],\"headline\":\"Use Copilot to quickly filter, sort, and search canvas app galleries with SQL Server\",\"datePublished\":\"2024-10-02T13:29:48+00:00\",\"dateModified\":\"2025-06-11T14:40:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/\"},\"wordCount\":603,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.png\",\"keywords\":[\"Canvas Apps\",\"Maker\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/\",\"name\":\"Use Copilot to quickly filter, sort, and search canvas app galleries with SQL Server - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.png\",\"datePublished\":\"2024-10-02T13:29:48+00:00\",\"dateModified\":\"2025-06-11T14:40:22+00:00\",\"description\":\"SQL Server, Copilot, Power apps, Canvas Apps, Filtering and searching\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.webp\",\"width\":699,\"height\":163,\"caption\":\"Image of adorner on gallery\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Use Copilot to quickly filter, sort, and search canvas app galleries with SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/3190911147b72493d0668bd37a01e9e7\",\"name\":\"Lance Delano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=gb821537d0bc9cf865938c8648693fa53\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g\",\"caption\":\"Lance Delano\"},\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lanced\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Use Copilot to quickly filter, sort, and search canvas app galleries with SQL Server - Microsoft Power Platform Blog","description":"SQL Server, Copilot, Power apps, Canvas Apps, Filtering and searching","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Use Copilot to quickly filter, sort, and search canvas app galleries with SQL Server - Microsoft Power Platform Blog","og_description":"SQL Server, Copilot, Power apps, Canvas Apps, Filtering and searching","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2024-10-02T13:29:48+00:00","article_modified_time":"2025-06-11T14:40:22+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.png","type":"","width":"","height":""}],"author":"Lance Delano, Jordan Chodak","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Lance Delano, Jordan Chodak","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lance-delano\/","@type":"Person","@name":"Lance Delano"},{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/jordan-chodak\/","@type":"Person","@name":"Jordan Chodak"}],"headline":"Use Copilot to quickly filter, sort, and search canvas app galleries with SQL Server","datePublished":"2024-10-02T13:29:48+00:00","dateModified":"2025-06-11T14:40:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/"},"wordCount":603,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.png","keywords":["Canvas Apps","Maker"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/","name":"Use Copilot to quickly filter, sort, and search canvas app galleries with SQL Server - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.png","datePublished":"2024-10-02T13:29:48+00:00","dateModified":"2025-06-11T14:40:22+00:00","description":"SQL Server, Copilot, Power apps, Canvas Apps, Filtering and searching","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/09\/Copilot-adorner1-1.webp","width":699,"height":163,"caption":"Image of adorner on gallery"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/10\/02\/use-copilot-to-quickly-filter-sort-and-search-canvas-app-galleries-with-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Use Copilot to quickly filter, sort, and search canvas app galleries with SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/3190911147b72493d0668bd37a01e9e7","name":"Lance Delano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=gb821537d0bc9cf865938c8648693fa53","url":"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g","caption":"Lance Delano"},"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lanced\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/125334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/105"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=125334"}],"version-history":[{"count":16,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/125334\/revisions"}],"predecessor-version":[{"id":127176,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/125334\/revisions\/127176"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=125334"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=125334"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=125334"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=125334"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=125334"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=125334"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=125334"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=125334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}