{"id":143,"date":"2017-11-21T08:20:56","date_gmt":"2017-11-21T16:20:56","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/formulaninjas\/"},"modified":"2025-06-11T08:10:52","modified_gmt":"2025-06-11T15:10:52","slug":"formulaninjas","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/formulaninjas\/","title":{"rendered":"New! &#8220;Friday Functions&#8221; series helps you to master formulas!"},"content":{"rendered":"<p>Have you been craving a better understanding of formulas and functions? Have you reached out to me for help on Twitter, and asked for tutorials too? Well, ask and you will receive! The new Friday Functions Video Series is for serious PowerAppers like myself that want to become ninjas at using functions and formulas!<\/p>\n<p>This is a direct response to your demand. (Special thanks to community members Sue P. and Dave V. who suggested a video series!) I&#8217;ve seen how much you love learning new ways to do more in your apps. So, I know you&#8217;ll enjoy this new series on YouTube which started on November 17th. Since we&#8217;ll be off several Fridays during the holiday season, I pre-recorded and uploaded a batch of them to get you started! For instance,<a href=\"https:\/\/www.youtube.com\/watch?v=Y291QrXgfVE&amp;t=5s&amp;list=PLnFZgEkUYL03vyWro12HGW6xRtNToIQIc&amp;index=1\" target=\"_blank\" rel=\"noopener\"> this Friday&#8217;s demo<\/a> leverages the Left(), StartsWith(), ColorFade(), and Today() functions, and creates a dynamic left navigation for filtering a gallery.\u00a0<\/p>\n<p><iframe loading=\"lazy\" allowfullscreen=\"\" frameborder=\"0\" height=\"315\" src=\"https:\/\/www.youtube-nocookie.com\/embed\/Y291QrXgfVE?rel=0\" width=\"560\"><\/iframe><\/p>\n<p>\u00a0<\/p>\n<p>Maybe you are already an expert with functions and formulas? If so, let&#8217;s get you involved in this series too! Just tag your YouTube videos about formulas and functions with the hashtags <strong>#FridayFunctions <\/strong>and <strong>#PowerApps<\/strong>. Or perhaps you prefer to have functions and formulas pre-built for you? Don&#8217;t worry, the PowerApps team is working on lots of new surprises where you won&#8217;t need to be a master at functions or formulas. On the other hand, I would suggest that you check out the video series anyway. These are usually very short videos (&lt;7 minutes), and I try to stuff in several general tips and tricks around many other PowerApps canvas feastures too! Plus, you&#8217;ll notice that some of these Friday Functions videos will be scheduled as 1-hour <strong>live webinars online<\/strong>! Those will usually go a bit deeper than the short videos I post on Friday afternoons. Bring your laptop, and your questions for us, and enjoy the deep dive webinars from the comfort of your own office space!<\/p>\n<p><strong>Moving forward, here is the Friday Functions playlist (check it often for new videos): <a href=\"https:\/\/www.youtube.com\/playlist?list=PLnFZgEkUYL03vyWro12HGW6xRtNToIQIc\" onclick=\"window.open(this.href, '', 'resizable=yes,status=no,location=no,toolbar=no,menubar=no,fullscreen=no,scrollbars=no,dependent=no'); return false;\">click here<\/a><\/strong><\/p>\n<p>Note: Each YouTube description area has references pointing you back to our community articles for any function mentioned in the video. This will help you to learn more on your own, and to try new things as an app-maker as well. Feel free to subscribe, comment, and like videos, this way I will know what you appreciated there!\u00a0<\/p>\n<p>If you have a function that you&#8217;d like me to cover, please post it in the comments below. I&#8217;m committing to a new video for each Friday of every month until spring (then it&#8217;s totally up to you if I continue the series)! We&#8217;re thrilled to be able to help you to use functions and formulas more efficiently! Thank you for your continued feedback and support, and as always,<\/p>\n<p>Happy PowerApping!<\/p>\n<p>Audrie<\/p>\n<p>(ArtsyPowerApper on Twitter and YouTube)<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you been craving a better understanding of formulas and functions? Have you reached out to me for help and asked for tutorials too? Well, ask and you will receive! The new Friday Functions Video Series is for serious PowerAppers like myself that want to become ninjas at using functions and formulas! <\/p>\n","protected":false},"author":106,"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":[],"job-role":[],"product":[3473],"property":[],"topic":[],"coauthors":[2058],"class_list":["post-143","post","type-post","status-publish","format-standard","hentry","audience-it-professional","product-power-apps"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>New! &quot;Friday Functions&quot; series helps you to master formulas! - 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\/2017\/11\/21\/formulaninjas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New! &quot;Friday Functions&quot; series helps you to master formulas! - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Have you been craving a better understanding of formulas and functions? Have you reached out to me for help and asked for tutorials too? Well, ask and you will receive! The new Friday Functions Video Series is for serious PowerAppers like myself that want to become ninjas at using functions and formulas!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/formulaninjas\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-21T16:20:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:10:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2023\/12\/Microsoft-logo_rgb_c-gray_950-1.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"950\" \/>\n\t<meta property=\"og:image:height\" content=\"413\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Audrie Gordon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Audrie Gordon\" \/>\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.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/audrie-gordon\/\",\"@type\":\"Person\",\"@name\":\"Audrie Gordon\"}],\"headline\":\"New! &#8220;Friday Functions&#8221; series helps you to master formulas!\",\"datePublished\":\"2017-11-21T16:20:56+00:00\",\"dateModified\":\"2025-06-11T15:10:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/\"},\"wordCount\":492,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"keywords\":[\"Formulas\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/\",\"name\":\"New! \\\"Friday Functions\\\" series helps you to master formulas! - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"datePublished\":\"2017-11-21T16:20:56+00:00\",\"dateModified\":\"2025-06-11T15:10:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New! &#8220;Friday Functions&#8221; series helps you to master formulas!\"}]},{\"@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\/5622f11b1629eeff57465c794c80c936\",\"name\":\"Audrie Gordon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g84a7fd97215038815e0a810e606188f3\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g\",\"caption\":\"Audrie Gordon\"},\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/audrie\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New! \"Friday Functions\" series helps you to master formulas! - 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\/2017\/11\/21\/formulaninjas\/","og_locale":"en_US","og_type":"article","og_title":"New! \"Friday Functions\" series helps you to master formulas! - Microsoft Power Platform Blog","og_description":"Have you been craving a better understanding of formulas and functions? Have you reached out to me for help and asked for tutorials too? Well, ask and you will receive! The new Friday Functions Video Series is for serious PowerAppers like myself that want to become ninjas at using functions and formulas!","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/formulaninjas\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2017-11-21T16:20:56+00:00","article_modified_time":"2025-06-11T15:10:52+00:00","og_image":[{"width":950,"height":413,"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2023\/12\/Microsoft-logo_rgb_c-gray_950-1.webp","type":"image\/png"}],"author":"Audrie Gordon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Audrie Gordon","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/audrie-gordon\/","@type":"Person","@name":"Audrie Gordon"}],"headline":"New! &#8220;Friday Functions&#8221; series helps you to master formulas!","datePublished":"2017-11-21T16:20:56+00:00","dateModified":"2025-06-11T15:10:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/"},"wordCount":492,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"keywords":["Formulas"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/","name":"New! \"Friday Functions\" series helps you to master formulas! - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"datePublished":"2017-11-21T16:20:56+00:00","dateModified":"2025-06-11T15:10:52+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/11\/21\/formulaninjas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"New! &#8220;Friday Functions&#8221; series helps you to master formulas!"}]},{"@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\/5622f11b1629eeff57465c794c80c936","name":"Audrie Gordon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g84a7fd97215038815e0a810e606188f3","url":"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g","caption":"Audrie Gordon"},"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/audrie\/"}]}},"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\/143","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\/106"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=143"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/143\/revisions"}],"predecessor-version":[{"id":131155,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/143\/revisions\/131155"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=143"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=143"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=143"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=143"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=143"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=143"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=143"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}