{"id":19510,"date":"2022-04-25T07:34:06","date_gmt":"2022-04-25T14:34:06","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-string-interpolation-index-function-and-randbetween-function\/"},"modified":"2025-06-11T07:50:10","modified_gmt":"2025-06-11T14:50:10","slug":"power-fx-string-interpolation-index-function-and-randbetween-function","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-string-interpolation-index-function-and-randbetween-function\/","title":{"rendered":"Power Fx: String interpolation, Index function, and RandBetween function"},"content":{"rendered":"<p>We are pleased to announce three great new features in Power Fx!\u00a0 These features are available in version 3.22041 and later of Power Apps Studio.<\/p>\n<h1>String interpolation<\/h1>\n<p><em>Note: There is a known issue with this feature when used in some apps that also use service functions through a connector.\u00a0 On save of the app, $&#8221; will be replaced with Concatenate.\u00a0 The problem has been fixed in 3.22051 which will begin deployment shortly.<\/em><\/p>\n<p>Have you ever spliced together a long string with the &amp; operator or Concatenate function?<\/p>\n<pre>\"Welcome \" &amp; FirstName &amp; \" \" &amp; LastName &amp; \", it is great to meet you!\"<\/pre>\n<p>What if instead, you could embed those references to FirstName and LastName directly into the string?<\/p>\n<pre>$\"Welcome {FirstName} {LastName}, it is great to meet you!\"<\/pre>\n<p>The second form is a lot cleaner and easier to read.\u00a0 Most modern programming languages have the ability to embed expressions within a string and now Power Fx does too.\u00a0 \u00a0Like C#, we call this feature string interpolation and it follows the same syntax as C#.\u00a0 You can <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-apps\/maker\/canvas-apps\/functions\/data-types#string-interpolation\">read all about the details in the docs<\/a>.\u00a0 \u00a0You can of course continue to use Excel compatible standard strings and the concatenate operator and function; string interpolation only adds a new option.<\/p>\n<p>The basic rules are:<\/p>\n<ul>\n<li>String interpolation strings begin with a <strong>$&#8221;<\/strong> instead of just\u00a0 <strong>&#8220;<\/strong>.<\/li>\n<li>Curly braces delineate the embedded expression.<\/li>\n<li>To include a curly brace in the string, double it such as <strong>{{<\/strong> or <strong>}}<\/strong>, just as we do to escape double quotes in a standard string.<\/li>\n<li>Expressions can include standard strings or string interpolated strings.<\/li>\n<\/ul>\n<p>Here are a few more interesting examples:<\/p>\n<pre>$\"2+3 = {2+3}\"\u00a0\n\/\/ result: 2+3 = 5\n\n$\"{{this is inside curly braces}}\"\n\/\/ result: {this is inside curly braces}\n\nWith( {x:5, y:7},\n      $\"Point ({x},{y}) is {Text( Sqrt( x^2+y^2 ), \"#.###\" )} from the origin\" )\n\/\/ result: Point (5,7) is 8.602 from the origin\n\/\/ shows a standard string nested within string interpolation\n\nWith( {FirstName: \"John\", MiddleName: \"Q.\", LastName: \"Doe\"},\n      $\"{Trim( $\"Welcome {FirstName} {MiddleName} {LastName}\" )}, we're glad you are here!\" )\n\/\/ result: Welcome John Q. Doe, we're glad you are here!\n\/\/ spacing is correct with 0, 1, 2, or 3 name parts that are non-blank\n\/\/ shows nested string interpolation<\/pre>\n<p>Why add this now?\u00a0 As we expand Power Fx to other products in the Power Platform, we have found that many of them use string interpolation by default.\u00a0 For example, consider the below action in Power Virtual Agents.\u00a0 The maker enters a string for the Message and can embed dynamic expressions within the string, in this case for the variables UserName and AgentName.\u00a0 This is a form of string interpolation with the leading $&#8221; provided by the system.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone size-full wp-image-19518\" height=\"205\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.png\" width=\"402\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.webp 402w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1-300x153.webp 300w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/p>\n<h1>Index function<\/h1>\n<p>Have you run across <strong>Last( FirstN( Table, N ) )<\/strong> in your Power Fx travels?\u00a0 Yes, that is a rather roundabout way to get to the N<sup>th<\/sup> record of Table.<\/p>\n<p>No longer!\u00a0 Excel has an Index function for, among other things, returning a row out of a range and so we adopted the same function.\u00a0 <strong>Index( Table, N )<\/strong> is equivalent to the above.\u00a0 You can <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-apps\/maker\/canvas-apps\/functions\/function-first-last\">read all about it in the docs<\/a>.<\/p>\n<p>Why add this now?\u00a0 \u00a0General goodness and because we are working on JSON parsing and we needed a more convenient way to index into a JSON array.\u00a0 Oops, general JSON parsing, did I say that out loud?!\u00a0 Stay tuned&#8230;<\/p>\n<h1>RandBetween function<\/h1>\n<p>And finally another Excel function, <strong>RandBetween( Low, High )\u00a0<\/strong>that returns an integer between Low and High inclusive.\u00a0 Much easier to use than multiplying a range by Rand() and making sure you have the lower and upper bounds handled correctly.\u00a0 <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-apps\/maker\/canvas-apps\/functions\/function-rand\">Docs tell the tale<\/a>.<\/p>\n<p>Why add this now?\u00a0 General goodness and I think the team was tired of me using this as my example of a <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/blog\/enhanced-component-properties\/\">pure function I could create with enhanced component properties<\/a>.\u00a0 Now I need to find another example.<\/p>\n<h1>Feedback welcome<\/h1>\n<p>As always, your feedback is most welcome here and in the <a href=\"https:\/\/powerusers.microsoft.com\/t5\/Power-Apps-Community\/ct-p\/PowerApps1\">Power Apps Community forum.<\/a>\u00a0 Your input is very helpful to us in prioritizing what we do next.<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power Fx has added three great new features.  String interpolation enables expressions to be embedded within strings, making it easier to combine parts of a string into a whole.  The Index function does away with Last of FirstN patterns.  The RandBetween function makes it easier to work with integer random numbers.<\/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-19510","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>Power Fx: String interpolation, Index function, and RandBetween function - 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\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Fx: String interpolation, Index function, and RandBetween function - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Power Fx has added three great new features. String interpolation enables expressions to be embedded within strings, making it easier to combine parts of a string into a whole. The Index function does away with Last of FirstN patterns. The RandBetween function makes it easier to work with integer random numbers.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-string-interpolation-index-function-and-randbetween-function\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-25T14:34:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T14:50:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"402\" \/>\n\t<meta property=\"og:image:height\" content=\"205\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/greg-lindhorst\/\",\"@type\":\"Person\",\"@name\":\"Greg Lindhorst\"}],\"headline\":\"Power Fx: String interpolation, Index function, and RandBetween function\",\"datePublished\":\"2022-04-25T14:34:06+00:00\",\"dateModified\":\"2025-06-11T14:50:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/\"},\"wordCount\":550,\"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\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.png\",\"keywords\":[\"Power Fx\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/\",\"name\":\"Power Fx: String interpolation, Index function, and RandBetween function - 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\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.png\",\"datePublished\":\"2022-04-25T14:34:06+00:00\",\"dateModified\":\"2025-06-11T14:50:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.webp\",\"width\":402,\"height\":205,\"caption\":\"graphical user interface, text, application, chat or text message\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#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: String interpolation, Index function, and RandBetween function\"}]},{\"@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: String interpolation, Index function, and RandBetween function - 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\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/","og_locale":"en_US","og_type":"article","og_title":"Power Fx: String interpolation, Index function, and RandBetween function - Microsoft Power Platform Blog","og_description":"Power Fx has added three great new features. String interpolation enables expressions to be embedded within strings, making it easier to combine parts of a string into a whole. The Index function does away with Last of FirstN patterns. The RandBetween function makes it easier to work with integer random numbers.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-string-interpolation-index-function-and-randbetween-function\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2022-04-25T14:34:06+00:00","article_modified_time":"2025-06-11T14:50:10+00:00","og_image":[{"width":402,"height":205,"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.png","type":"image\/png"}],"author":"Greg Lindhorst","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greg Lindhorst","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/greg-lindhorst\/","@type":"Person","@name":"Greg Lindhorst"}],"headline":"Power Fx: String interpolation, Index function, and RandBetween function","datePublished":"2022-04-25T14:34:06+00:00","dateModified":"2025-06-11T14:50:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/"},"wordCount":550,"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\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.png","keywords":["Power Fx"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/","name":"Power Fx: String interpolation, Index function, and RandBetween function - 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\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.png","datePublished":"2022-04-25T14:34:06+00:00","dateModified":"2025-06-11T14:50:10+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/2022-04-18_22h35_08-1.webp","width":402,"height":205,"caption":"graphical user interface, text, application, chat or text message"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/25\/power-fx-string-interpolation-index-function-and-randbetween-function\/#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: String interpolation, Index function, and RandBetween function"}]},{"@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\/19510","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=19510"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/19510\/revisions"}],"predecessor-version":[{"id":130160,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/19510\/revisions\/130160"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=19510"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=19510"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=19510"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=19510"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=19510"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=19510"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=19510"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=19510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}