{"id":21009,"date":"2022-08-15T12:51:07","date_gmt":"2022-08-15T19:51:07","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-error-handling-graduates-to-preview\/"},"modified":"2025-06-11T07:48:41","modified_gmt":"2025-06-11T14:48:41","slug":"power-fx-error-handling-graduates-to-preview","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-error-handling-graduates-to-preview\/","title":{"rendered":"Power Fx: Error handling graduates to preview"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">We are thrilled to announce that the long-time experimental feature <strong>Formula-level error handling<\/strong> has moved forward to preview.  As a result, you and your end users will enjoy higher reliability and more transparency about what is happening in your apps.<\/p>\n\n\n<p class=\"wp-block-paragraph\">It&#8217;s a huge step.  Adding error handling to an existing language turned out to be a very tall order, touching almost everything, from data types, to functions, to the runtime.  Thank you for all of your support, feedback, and patience as we got this done.<\/p>\n\n\n<p class=\"wp-block-paragraph\">What does it mean for you?  <\/p>\n\n\n<ul class=\"wp-block-list\"><li>Your apps will more reliably detect and report errors.<\/li><li>You can write blank\/null values to a database.<\/li><li>You can detect and replace errors with the <strong>IsError<\/strong>, <strong>IsErrorOrBlank<\/strong>, and <strong>IfError<\/strong> functions.<\/li><li>You can control error reporting and logging at a central location with <strong>App.OnError<\/strong>.<\/li><li>You can create and throw your own custom errors with the <strong>Error<\/strong> function.<\/li><\/ul>\n\n\n<p class=\"wp-block-paragraph\">Error handling is a big change in behavior.  By entering preview, we are signaling that we believe we are done, that we anticipate no further significant changes from here.  Many of you already use error handling in production and this move to preview should only embolden more of you to do so.  If significant changes are needed from here, we will treat them as a separate feature.<\/p>\n\n\n<p class=\"wp-block-paragraph\">We are rolling this out slowly as it is such a big change.  All of you will soon see that the <strong>Formula-level error handling<\/strong> switch has moved from experimental to preview in the settings (as of version 3.22082).  It will still be default to off for most tenants.  Over the coming weeks we will slowly change the default for new apps only to on across the tenants.  Makers can still disable this feature and will be able to do so for a long time.<\/p>\n\n\n<p class=\"wp-block-paragraph\">I say again: we are changing the default for <strong>new apps only<\/strong>.  Existing apps will continue running as they always have.  We have no plans at this time to turn this on for existing apps, and as this is such a big change, we may never do this and make this a permanently available switch.  Your feedback will guide us.<\/p>\n\n\n<p class=\"wp-block-paragraph\">The documentation for <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-platform\/power-fx\/reference\/function-iferror\" rel=\"noreferrer noopener\" target=\"_blank\"><strong>Error, IfError, IsError, IsErrorOrBlank<\/strong> functions<\/a> and the <strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-platform\/power-fx\/reference\/object-app#onerror-property\" rel=\"noreferrer noopener\" target=\"_blank\">App.OnError<\/a><\/strong> property covers these changes.  <strong>IfError<\/strong> and <strong>IsError<\/strong> are very similar to their Excel counterparts.  We are also working on overview docs that will be released shortly.<\/p>\n\n\n<p class=\"wp-block-paragraph\">But before that, let&#8217;s take a brief tour.<\/p>\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s start with what Excel does, the inspiration for Power Fx.  For an error like division by zero, Excel is very clear that something has gone wrong with a # error message that shows right in the cell.  This error will propagate to other cell formulas if A1 is used in a formula: <\/p>\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" alt=\"#DIV\/0! error shown for cell A1 with the formula =1\/0\" class=\"wp-image-21026 webp-format\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_08h10_45.webp\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_08h10_45.webp\"><\/figure>\n\n\n<p class=\"wp-block-paragraph\">Today, without error handling, Power Apps won&#8217;t report anything in this scenario, instead treating the division by zero error as a blank value.  That&#8217;s not good, as the maker and the end user of the app have no idea something may have gone wrong:<\/p>\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" alt=\"No error is displayed for division by zero, instead we see a blank value in the formula bar's result view.\" class=\"wp-image-21049 webp-format\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_31-1024x208.webp\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_31-1024x208.webp 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_31-300x61.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_31-768x156.webp 768w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_31.webp 1135w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_31-1024x208.webp\"><\/figure>\n\n\n<p class=\"wp-block-paragraph\">Errors happen.  Unexpected data flows in, networks go down, storage fills up, to name just a few situations that an app may encounter in the real world.  Makers don&#8217;t often think through all the ways that things can go sideways which makes default error handling even more important.  <\/p>\n\n\n<p class=\"wp-block-paragraph\">Returning a blank for an error is also a problem because blank is a legitimate value in our type system and in many databases.  Without error handling, Power Apps won&#8217;t allow you to write a blank to a database instead thinking it is an error.<\/p>\n\n\n<p class=\"wp-block-paragraph\">So, instead of returning an easy to ignore or misinterpret blank value, with error handling turned on we now report an error to the end user (the error banner) and show the formula as having an error to the maker (the red filled in circle on the control):<\/p>\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" alt='An error banner shows \"division by zero\" and the control is shown to be in an error state.' class=\"wp-image-21050 webp-format\" alt=\"graphical user interface, application, Word\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_17-1024x208.webp\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_17-1024x208.webp 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_17-300x61.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_17-768x156.webp 768w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_17.webp 1135w\" data-orig-alt=\"graphical user interface, application, Word\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_17-1024x208.webp\"><\/figure>\n\n\n<p class=\"wp-block-paragraph\">Further, if you look at the value of the formula, it is not a blank but an error value.  Just as any formula can result in a blank, now any formula can also result in an error:<\/p>\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" alt=\"The return value of the formula 1\/0 returns an error instead of a blank value.\" class=\"wp-image-21051 webp-format\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_47-1024x208.webp\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_47-1024x208.webp 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_47-300x61.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_47-768x156.webp 768w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_47.webp 1135w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h33_47-1024x208.webp\"><\/figure>\n\n\n<p class=\"wp-block-paragraph\">Now, we still aren&#8217;t showing an error in the label control itself as Excel does.  We couldn&#8217;t do this generically because, unlike Excel, the error could be on a property of a control for which there is no way to display the error.  For example, where should an error on a slider control?  Where should an error be shown for an imperative operation in the middle of a button&#8217;s OnSelect formula?  We settled on showing the end user banner and flagging the control in the design experience.<\/p>\n\n\n<p class=\"wp-block-paragraph\">That&#8217;s not to say you can&#8217;t detect and display an error in that label control.  Error handling provides a wealth of mechanisms to control how errors are handled and reported.  For example in this case, we can wrap the division by zero with an <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-platform\/power-fx\/reference\/function-iferror\" rel=\"noreferrer noopener\" target=\"_blank\"><strong>IfError<\/strong> function<\/a> to return a custom message in the label:<\/p>\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" alt=\"Replacing an error with a text string.\" class=\"wp-image-21037 webp-format\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h13_34-1024x207.webp\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h13_34-1024x207.webp 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h13_34-300x61.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h13_34-768x155.webp 768w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h13_34.webp 1137w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h13_34-1024x207.webp\"><\/figure>\n\n\n<p class=\"wp-block-paragraph\">The Text function call is required for type compatibility.  Or we can use IfError to throw a different, more specific error with the <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-platform\/power-fx\/reference\/function-iferror\" rel=\"noreferrer noopener\" target=\"_blank\"><strong>Error<\/strong> function<\/a>:<\/p>\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" alt=\"Using the Error function to rethrow an error with a different kind and message.\" class=\"wp-image-21036 webp-format\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h11_17-1024x207.webp\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h11_17-1024x207.webp 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h11_17-300x61.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h11_17-768x155.webp 768w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h11_17.webp 1137w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_09h11_17-1024x207.webp\"><\/figure>\n\n\n<p class=\"wp-block-paragraph\">Or we can have a catchall for all errors in the app with <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-platform\/power-fx\/reference\/object-app#onerror-property\" rel=\"noreferrer noopener\" target=\"_blank\"><strong>App.OnError<\/strong><\/a>.  For example, we can log the error and present a different message to the end user:<\/p>\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" alt=\"graphical user interface, application, Word\" class=\"wp-image-21057 webp-format\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h40_14-1024x237.webp\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h40_14-1024x237.webp 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h40_14-300x70.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h40_14-768x178.webp 768w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h40_14.webp 1523w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h40_14-1024x237.webp\"><\/figure>\n\n\n<p class=\"wp-block-paragraph\">If we look at the log, we see the details of the captured error from <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-platform\/power-fx\/reference\/function-iferror#firsterror--allerrors\" rel=\"noreferrer noopener\" target=\"_blank\"><strong>FirstError<\/strong><\/a> (and there is also an <strong>AllErrors<\/strong>), including where it happened and when it was detected:<\/p>\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" alt=\"graphical user interface, text, application, email\" class=\"wp-image-21058 webp-format\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h37_58-1024x171.webp\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h37_58-1024x171.webp 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h37_58-300x50.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h37_58-768x128.webp 768w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h37_58.webp 1483w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_10h37_58-1024x171.webp\"><\/figure>\n\n\n<p class=\"wp-block-paragraph\">The possibilities are endless!  You now have all the tools you need to detect, replace, report, and log errors, including a good default behavior if you never take advantage of these tools.  And, bonus, you can also now write blank (or null) values to databases.<\/p>\n\n\n<p class=\"wp-block-paragraph\">Please let us know what you think in the Power Apps community forum.  There is a dedicated and active space for error handling discussions at <strong><a href=\"https:\/\/powerusers.microsoft.com\/t5\/Error-Handling\/bd-p\/PA_Error_Handling\" rel=\"noreferrer noopener\" target=\"_blank\">Error Handling &#8211; Power Platform Community (microsoft.com)<\/a><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Reliable error handling moves to preview for Power Fx and Power Apps.  You now have all the tools you need to detect, replace, report, and log errors, including a good default behavior if you never take advantage of these tools.  And, bonus, you can also now write blank (or null) values to databases.<\/p>\n","protected":false},"author":86,"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":[2104],"class_list":["post-21009","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.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Power Fx: Error handling graduates to 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\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Fx: Error handling graduates to preview - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Reliable error handling moves to preview for Power Fx and Power Apps. You now have all the tools you need to detect, replace, report, and log errors, including a good default behavior if you never take advantage of these tools. And, bonus, you can also now write blank (or null) values to databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-error-handling-graduates-to-preview\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-15T19:51:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T14:48:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_08h10_45.png\" \/>\n<meta name=\"author\" content=\"Greg Lindhorst\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greg Lindhorst\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/\"},\"author\":[{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/author\\\/greg-lindhorst\\\/\",\"@type\":\"Person\",\"@name\":\"Greg Lindhorst\"}],\"headline\":\"Power Fx: Error handling graduates to preview\",\"datePublished\":\"2022-08-15T19:51:07+00:00\",\"dateModified\":\"2025-06-11T14:48:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/\"},\"wordCount\":1004,\"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\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/2022-08-12_08h10_45.png\",\"keywords\":[\"Formulas\",\"Power Fx\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/\",\"name\":\"Power Fx: Error handling graduates to 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\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/2022-08-12_08h10_45.png\",\"datePublished\":\"2022-08-15T19:51:07+00:00\",\"dateModified\":\"2025-06-11T14:48:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/2022-08-12_08h10_45.webp\",\"contentUrl\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/2022-08-12_08h10_45.webp\",\"width\":610,\"height\":153,\"caption\":\"table\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/2022\\\/08\\\/15\\\/power-fx-error-handling-graduates-to-preview\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Fx: Error handling graduates to 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\\\/dbd4cb8af4503e696f240353831f05d4\",\"name\":\"Greg Lindhorst\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g0133d144d5ed416197bd3b29ccd9a59c\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g\",\"caption\":\"Greg Lindhorst\"},\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/power-platform\\\/blog\\\/author\\\/gregli\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power Fx: Error handling graduates to 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\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/","og_locale":"en_US","og_type":"article","og_title":"Power Fx: Error handling graduates to preview - Microsoft Power Platform Blog","og_description":"Reliable error handling moves to preview for Power Fx and Power Apps. You now have all the tools you need to detect, replace, report, and log errors, including a good default behavior if you never take advantage of these tools. And, bonus, you can also now write blank (or null) values to databases.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-error-handling-graduates-to-preview\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2022-08-15T19:51:07+00:00","article_modified_time":"2025-06-11T14:48:41+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_08h10_45.png","type":"","width":"","height":""}],"author":"Greg Lindhorst","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greg Lindhorst","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/greg-lindhorst\/","@type":"Person","@name":"Greg Lindhorst"}],"headline":"Power Fx: Error handling graduates to preview","datePublished":"2022-08-15T19:51:07+00:00","dateModified":"2025-06-11T14:48:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/"},"wordCount":1004,"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\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_08h10_45.png","keywords":["Formulas","Power Fx"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/","name":"Power Fx: Error handling graduates to 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\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_08h10_45.png","datePublished":"2022-08-15T19:51:07+00:00","dateModified":"2025-06-11T14:48:41+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_08h10_45.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/08\/2022-08-12_08h10_45.webp","width":610,"height":153,"caption":"table"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/08\/15\/power-fx-error-handling-graduates-to-preview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Fx: Error handling graduates to 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\/dbd4cb8af4503e696f240353831f05d4","name":"Greg Lindhorst","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g0133d144d5ed416197bd3b29ccd9a59c","url":"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g","caption":"Greg Lindhorst"},"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/gregli\/"}]}},"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\/21009","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\/86"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=21009"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/21009\/revisions"}],"predecessor-version":[{"id":130082,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/21009\/revisions\/130082"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=21009"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=21009"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=21009"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=21009"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=21009"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=21009"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=21009"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=21009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}