{"id":27565,"date":"2024-02-29T10:30:45","date_gmt":"2024-02-29T18:30:45","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/"},"modified":"2025-06-11T07:42:30","modified_gmt":"2025-06-11T14:42:30","slug":"call-sql-server-stored-procedures-directly-in-power-fx-preview","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/","title":{"rendered":"Call SQL Server stored procedures directly in Power Fx (Preview)"},"content":{"rendered":"<p>We are excited to announce that you can now directly call SQL Server stored procedures in Power Fx.\u00a0 You no longer need to call a Power Automate Flow to use a stored procedure. This feature is in preview and currently in all regions.\u00a0 This makes development of Power Apps for SQL much easier. And your apps will be faster.\u00a0 The ability to call stored procedures for the SQL connector directly is an extension to the existing tabular model and gives users access to tables, views, and stored procedures. This feature extends our ongoing support of SQL Server as a primary development target for Power Apps.<\/p>\n<div class=\"wp-block-image\">\n<img loading=\"lazy\" decoding=\"async\" alt=\"SQL table selector with tables \/ views and also stored procedures. \" class=\"aligncenter wp-image-27566 size-full\" height=\"467\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.png\" width=\"386\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.webp 386w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList-248x300.webp 248w\" sizes=\"auto, (max-width: 386px) 100vw, 386px\" \/>\n<\/div>\n<h3>Getting started<\/h3>\n<p>To use this feature, open a Power App and enable the preview switch in &#8216;Settings \/ Upcoming features \/ Preview&#8217;.\u00a0 Then, create a new SQL connection to your app. You can add to the existing connector already present in the app. In the table selector, choose the &#8216;Stored Procedure&#8217; tab and select all of the stored procedures you want to access in your app. Then you can directly access the stored procedure in your app.<\/p>\n<div class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" alt=\"Formula calling a stored procedure directly. Prefix the stored procedure with the name of the connector. \" class=\"aligncenter wp-image-27567 size-full\" height=\"241\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/calling-sp-directly-markup.png\" width=\"782\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/calling-sp-directly-markup.webp 782w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/calling-sp-directly-markup-300x92.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/calling-sp-directly-markup-768x237.webp 768w\" sizes=\"auto, (max-width: 782px) 100vw, 782px\" \/><\/div>\n<p>This feature is an extension to the tabular model. We allow the ability to execute stored procedures, but we do not allow the ability to run arbitrary SQL. This helps provides an additional level of security. Additionally, you can bind a stored procedure directly to a gallery or table by choose the &#8216;Safe to use for galleries and tables&#8217; checkbox.\u00a0 \u00a0See the article <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-apps\/maker\/canvas-apps\/connections\/connection-azure-sqldatabase\">Connect to SQL Server from Power Apps<\/a> for a discussion of how and when to select this option and other details on how to use this feature.<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Calling stored procedures directly in Power Fx.  Speed up app development.  Speeds up Power App performance.<\/p>\n","protected":false},"author":105,"featured_media":0,"comment_status":"open","ping_status":"open","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":[3424],"job-role":[],"product":[3473],"property":[],"topic":[3421],"coauthors":[2056],"class_list":["post-27565","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-news","product-power-apps","topic-application-modernization"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Call SQL Server stored procedures directly in Power Fx (Preview) - Microsoft Power Platform Blog<\/title>\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\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Call SQL Server stored procedures directly in Power Fx (Preview) - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Calling stored procedures directly in Power Fx. Speed up app development. Speeds up Power App performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-29T18:30:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T14:42:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.png\" \/>\n\t<meta property=\"og:image:width\" content=\"386\" \/>\n\t<meta property=\"og:image:height\" content=\"467\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Lance Delano\" \/>\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\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\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\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lance-delano\/\",\"@type\":\"Person\",\"@name\":\"Lance Delano\"}],\"headline\":\"Call SQL Server stored procedures directly in Power Fx (Preview)\",\"datePublished\":\"2024-02-29T18:30:45+00:00\",\"dateModified\":\"2025-06-11T14:42:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/\"},\"wordCount\":280,\"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\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.png\",\"keywords\":[\"Building Power Apps\",\"Power Fx\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/\",\"name\":\"Call SQL Server stored procedures directly in Power Fx (Preview) - 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\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.png\",\"datePublished\":\"2024-02-29T18:30:45+00:00\",\"dateModified\":\"2025-06-11T14:42:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.webp\",\"width\":386,\"height\":467,\"caption\":\"graphical user interface, application, Teams\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Call SQL Server stored procedures directly in Power Fx (Preview)\"}]},{\"@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":"Call SQL Server stored procedures directly in Power Fx (Preview) - Microsoft Power Platform Blog","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\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/","og_locale":"en_US","og_type":"article","og_title":"Call SQL Server stored procedures directly in Power Fx (Preview) - Microsoft Power Platform Blog","og_description":"Calling stored procedures directly in Power Fx. Speed up app development. Speeds up Power App performance.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2024-02-29T18:30:45+00:00","article_modified_time":"2025-06-11T14:42:30+00:00","og_image":[{"width":386,"height":467,"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.png","type":"image\/png"}],"author":"Lance Delano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Lance Delano","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lance-delano\/","@type":"Person","@name":"Lance Delano"}],"headline":"Call SQL Server stored procedures directly in Power Fx (Preview)","datePublished":"2024-02-29T18:30:45+00:00","dateModified":"2025-06-11T14:42:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/"},"wordCount":280,"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\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.png","keywords":["Building Power Apps","Power Fx"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/","name":"Call SQL Server stored procedures directly in Power Fx (Preview) - 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\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.png","datePublished":"2024-02-29T18:30:45+00:00","dateModified":"2025-06-11T14:42:30+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/02\/call-sp-PowerFx-SPList.webp","width":386,"height":467,"caption":"graphical user interface, application, Teams"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2024\/02\/29\/call-sql-server-stored-procedures-directly-in-power-fx-preview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Call SQL Server stored procedures directly in Power Fx (Preview)"}]},{"@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\/27565","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=27565"}],"version-history":[{"count":2,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/27565\/revisions"}],"predecessor-version":[{"id":129795,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/27565\/revisions\/129795"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=27565"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=27565"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=27565"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=27565"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=27565"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=27565"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=27565"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=27565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}