{"id":93158,"date":"2023-02-21T07:09:52","date_gmt":"2023-02-21T12:09:52","guid":{"rendered":"https:\/\/www.beringer.net\/?p=93158"},"modified":"2023-02-21T07:09:52","modified_gmt":"2023-02-21T12:09:52","slug":"what-is-power-fx","status":"publish","type":"post","link":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/","title":{"rendered":"What is Power Fx?"},"content":{"rendered":"

If you’ve been keeping up with the sweeping changes happening around the Microsoft Power Platform, you’re probably familiar with the term Power Fx.\u00a0 It’s mentioned throughout Microsoft’s more modern documentation, and you’ve likely seen some areas in your configuration components that accept custom Power Fx scripts.<\/p>\n

What is Power Fx?<\/h2>\n

Put simply, Power Fx is a coding language.\u00a0 Don’t worry, this language is not nearly as complicated as JavaScript, C# or the like.\u00a0 Power Fx is more like Excel formulas; in fact, excel formulas are exactly what Microsoft based this new language off of!\u00a0 Power Fx is considered a “low-code” language, which means there is less you need to learn to get started with it, albeit with less capability for complex functions.<\/p>\n

An Approachable Language<\/h2>\n

In typical programming languages, there are a lot of steps to performing a piece of logic.\u00a0 Let’s say you want to add two numbers together to update a 3rd number, like this:<\/p>\n

A + B = C<\/pre>\n
With other languages, you would need to:<\/p>\n
    \n
  1. Define the 3 variables above<\/li>\n
  2. Pass values to these variables, typically using an API (an entirely different set of code)<\/li>\n
  3. Add “A” and “B” together, set the value of “C”<\/li>\n
  4. Use an API call to Update a record with the value of “C”<\/li>\n<\/ol>\n
    Power Fx reduces this down to a single step!\u00a0 Editors within your app understand what values are being defined, because they are based on your table’s schema.\u00a0 This eliminates steps 1 and 2.\u00a0 Power Fx also knows what column and row you want to update, again using your table’s schema.\u00a0 This eliminates step 4.\u00a0 This low-code approach takes out most of the overhead in using a typical programming language.\u00a0 What’s left is a powerful, functional coding language that you can learn, especially if you already know your way around excel formulas.<\/p>\n
    Where can I learn Power Fx?<\/h2>\n
    I highly recommend checking out Microsoft’s documentation<\/a> covering everything you need to know about Power Fx.\u00a0 Check back here for updates and examples, which we’ll cover in future blogs.<\/p>\n
    Contact Beringer Today!<\/a><\/h2>\n
    We love to implement the Power Platform and Microsoft Dynamics 365 here at Beringer.\u00a0 We\u2019ve been working with\u00a0Microsoft Dynamics<\/a>\u00a0since its inception, and we\u2019re always finding innovative ways to implement the latest tools and help automate business processes.<\/p>\n
    Beringer Technology Group, a leading Microsoft Gold Certified Partner specializing in\u00a0Microsoft Dynamics 365<\/a>\u00a0and\u00a0CRM for Distribution<\/a>\u00a0also provides expert\u00a0Managed IT Services<\/a>,\u00a0Backup and Disaster Recovery<\/a>,\u00a0Cloud Based Computing<\/a>,\u00a0Email Security Implementation and Training<\/a>,\u00a0Unified Communication Solutions<\/a>, and\u00a0Cybersecurity Risk Assessment.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
    If you’ve been keeping up with the sweeping changes happening around the Microsoft Power Platform, you’re probably familiar with the term Power Fx.\u00a0 It’s mentioned throughout Microsoft’s more modern documentation, and you’ve likely seen some areas in your configuration components that accept custom Power Fx scripts. What is Power Fx? Put simply, Power Fx is…<\/p>\n","protected":false},"author":20,"featured_media":94735,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[79,70],"tags":[75,1508,1451,77,1804,1806],"acf":[],"yoast_head":"\nWhat is Power Fx? | | Beringer Technology Group<\/title>\n<meta name=\"description\" content=\"What is Power Fx?Put simply, Power Fx is a coding language.\u00a0 It's is not nearly as complicated as JavaScript, C# or the like.\" \/>\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.beringer.net\/beringerblog\/what-is-power-fx\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Power Fx? | | Beringer Technology Group\" \/>\n<meta property=\"og:description\" content=\"What is Power Fx?Put simply, Power Fx is a coding language.\u00a0 It's is not nearly as complicated as JavaScript, C# or the like.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/\" \/>\n<meta property=\"og:site_name\" content=\"Beringer Technology Group\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-21T12:09:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/07\/shutterstock_2152489403-scaled-e1688658067255.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"978\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"theProfessor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"theProfessor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/\"},\"author\":{\"name\":\"theProfessor\",\"@id\":\"https:\/\/www.beringer.net\/#\/schema\/person\/29d47ebf924d67cef0c83ee7e73da1c5\"},\"headline\":\"What is Power Fx?\",\"datePublished\":\"2023-02-21T12:09:52+00:00\",\"dateModified\":\"2023-02-21T12:09:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/\"},\"wordCount\":418,\"publisher\":{\"@id\":\"https:\/\/www.beringer.net\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/07\/shutterstock_2152489403-scaled-e1688658067255.jpg\",\"keywords\":[\"BTG Rocks\",\"low code\",\"Microsoft Power Platform\",\"model driven app\",\"power fx\",\"powerfx\"],\"articleSection\":[\"Power Platform\",\"Web & Cloud\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/\",\"url\":\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/\",\"name\":\"What is Power Fx? | | Beringer Technology Group\",\"isPartOf\":{\"@id\":\"https:\/\/www.beringer.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/07\/shutterstock_2152489403-scaled-e1688658067255.jpg\",\"datePublished\":\"2023-02-21T12:09:52+00:00\",\"dateModified\":\"2023-02-21T12:09:52+00:00\",\"description\":\"What is Power Fx?Put simply, Power Fx is a coding language.\u00a0 It's is not nearly as complicated as JavaScript, C# or the like.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#primaryimage\",\"url\":\"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/07\/shutterstock_2152489403-scaled-e1688658067255.jpg\",\"contentUrl\":\"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/07\/shutterstock_2152489403-scaled-e1688658067255.jpg\",\"width\":978,\"height\":600,\"caption\":\"Working with in-app notifications\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.beringer.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is Power Fx?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.beringer.net\/#website\",\"url\":\"https:\/\/www.beringer.net\/\",\"name\":\"Beringer Technology Group\",\"description\":\"Performance. Integrity. Trust.\",\"publisher\":{\"@id\":\"https:\/\/www.beringer.net\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.beringer.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.beringer.net\/#organization\",\"name\":\"Beringer Technology Group\",\"url\":\"https:\/\/www.beringer.net\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.beringer.net\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/12\/beringer-technology-group.jpeg\",\"contentUrl\":\"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/12\/beringer-technology-group.jpeg\",\"width\":200,\"height\":200,\"caption\":\"Beringer Technology Group\"},\"image\":{\"@id\":\"https:\/\/www.beringer.net\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.beringer.net\/#\/schema\/person\/29d47ebf924d67cef0c83ee7e73da1c5\",\"name\":\"theProfessor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.beringer.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d7484aed60e44ac6010e4b4752e468fc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d7484aed60e44ac6010e4b4752e468fc?s=96&d=mm&r=g\",\"caption\":\"theProfessor\"},\"description\":\"Rob is the CTO of Beringer Technology Group, and focuses his efforts on software development, cloud engineering, team mentoring and strategic technical direction. Rob has worked with Beringer since 2005, and has influenced every department from Development, Security, Implementation, Support and Sales. Rob graduated with his MBA from Rowan University in 2012, earned his Bachelors of Computer Science in 1997, and is current with several Microsoft technical certifications. Rob is very active, and loves to mountain bike, weight train, cook and hike with his dog pack.\",\"url\":\"https:\/\/www.beringer.net\/beringerblog\/author\/theprofessor\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Power Fx? | | Beringer Technology Group","description":"What is Power Fx?Put simply, Power Fx is a coding language.\u00a0 It's is not nearly as complicated as JavaScript, C# or the like.","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.beringer.net\/beringerblog\/what-is-power-fx\/","og_locale":"en_US","og_type":"article","og_title":"What is Power Fx? | | Beringer Technology Group","og_description":"What is Power Fx?Put simply, Power Fx is a coding language.\u00a0 It's is not nearly as complicated as JavaScript, C# or the like.","og_url":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/","og_site_name":"Beringer Technology Group","article_published_time":"2023-02-21T12:09:52+00:00","og_image":[{"width":978,"height":600,"url":"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/07\/shutterstock_2152489403-scaled-e1688658067255.jpg","type":"image\/jpeg"}],"author":"theProfessor","twitter_card":"summary_large_image","twitter_misc":{"Written by":"theProfessor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#article","isPartOf":{"@id":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/"},"author":{"name":"theProfessor","@id":"https:\/\/www.beringer.net\/#\/schema\/person\/29d47ebf924d67cef0c83ee7e73da1c5"},"headline":"What is Power Fx?","datePublished":"2023-02-21T12:09:52+00:00","dateModified":"2023-02-21T12:09:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/"},"wordCount":418,"publisher":{"@id":"https:\/\/www.beringer.net\/#organization"},"image":{"@id":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#primaryimage"},"thumbnailUrl":"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/07\/shutterstock_2152489403-scaled-e1688658067255.jpg","keywords":["BTG Rocks","low code","Microsoft Power Platform","model driven app","power fx","powerfx"],"articleSection":["Power Platform","Web & Cloud"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/","url":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/","name":"What is Power Fx? | | Beringer Technology Group","isPartOf":{"@id":"https:\/\/www.beringer.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#primaryimage"},"image":{"@id":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#primaryimage"},"thumbnailUrl":"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/07\/shutterstock_2152489403-scaled-e1688658067255.jpg","datePublished":"2023-02-21T12:09:52+00:00","dateModified":"2023-02-21T12:09:52+00:00","description":"What is Power Fx?Put simply, Power Fx is a coding language.\u00a0 It's is not nearly as complicated as JavaScript, C# or the like.","breadcrumb":{"@id":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#primaryimage","url":"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/07\/shutterstock_2152489403-scaled-e1688658067255.jpg","contentUrl":"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/07\/shutterstock_2152489403-scaled-e1688658067255.jpg","width":978,"height":600,"caption":"Working with in-app notifications"},{"@type":"BreadcrumbList","@id":"https:\/\/www.beringer.net\/beringerblog\/what-is-power-fx\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.beringer.net\/"},{"@type":"ListItem","position":2,"name":"What is Power Fx?"}]},{"@type":"WebSite","@id":"https:\/\/www.beringer.net\/#website","url":"https:\/\/www.beringer.net\/","name":"Beringer Technology Group","description":"Performance. Integrity. Trust.","publisher":{"@id":"https:\/\/www.beringer.net\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.beringer.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.beringer.net\/#organization","name":"Beringer Technology Group","url":"https:\/\/www.beringer.net\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.beringer.net\/#\/schema\/logo\/image\/","url":"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/12\/beringer-technology-group.jpeg","contentUrl":"https:\/\/www.beringer.net\/wp-content\/uploads\/2023\/12\/beringer-technology-group.jpeg","width":200,"height":200,"caption":"Beringer Technology Group"},"image":{"@id":"https:\/\/www.beringer.net\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.beringer.net\/#\/schema\/person\/29d47ebf924d67cef0c83ee7e73da1c5","name":"theProfessor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.beringer.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d7484aed60e44ac6010e4b4752e468fc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d7484aed60e44ac6010e4b4752e468fc?s=96&d=mm&r=g","caption":"theProfessor"},"description":"Rob is the CTO of Beringer Technology Group, and focuses his efforts on software development, cloud engineering, team mentoring and strategic technical direction. Rob has worked with Beringer since 2005, and has influenced every department from Development, Security, Implementation, Support and Sales. Rob graduated with his MBA from Rowan University in 2012, earned his Bachelors of Computer Science in 1997, and is current with several Microsoft technical certifications. Rob is very active, and loves to mountain bike, weight train, cook and hike with his dog pack.","url":"https:\/\/www.beringer.net\/beringerblog\/author\/theprofessor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.beringer.net\/wp-json\/wp\/v2\/posts\/93158"}],"collection":[{"href":"https:\/\/www.beringer.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beringer.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.beringer.net\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beringer.net\/wp-json\/wp\/v2\/comments?post=93158"}],"version-history":[{"count":0,"href":"https:\/\/www.beringer.net\/wp-json\/wp\/v2\/posts\/93158\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.beringer.net\/wp-json\/wp\/v2\/media\/94735"}],"wp:attachment":[{"href":"https:\/\/www.beringer.net\/wp-json\/wp\/v2\/media?parent=93158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beringer.net\/wp-json\/wp\/v2\/categories?post=93158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beringer.net\/wp-json\/wp\/v2\/tags?post=93158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}