{"id":95,"date":"2024-09-06T12:40:11","date_gmt":"2024-09-06T19:40:11","guid":{"rendered":"https:\/\/gilosoftblogcom.wordpress.com\/?p=95"},"modified":"2024-09-06T12:40:11","modified_gmt":"2024-09-06T19:40:11","slug":"using-concat-function-in-power-automate","status":"publish","type":"post","link":"https:\/\/blog.gilosoft.com\/index.php\/2024\/09\/06\/using-concat-function-in-power-automate\/","title":{"rendered":"Using Concat Function in Power Automate"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Power Automate is a tool that is invaluable to SharePoint developers because it allows you to streamline workflows and tasks. In this blog, we&#8217;ll explore the concat function and how utilize it in a flow.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>What is the Concat Function?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The concat function in Power Automate is used to join two or more strings into a single string. This is especially useful when you need to join multiple pieces of text, for example creating a full name by joining first and last names, generating a custom messages, or building dynamic file names.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Syntax of the Concat Function<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nconcat(string1, string2, ..., stringN)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>Step-by-Step Guide to Using the concat Function in Power Automate<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step1 : <\/strong>Create a New Flow<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Go to Power Automate (flow.microsoft.com) and sign in. Create an &#8220;Instant cloud flow&#8221; and Choose a &#8220;Manually trigger a flow&#8221; selection as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/gilosoft.com\/wp-content\/uploads\/2024\/07\/Screenshot-2024-07-15-at-7.14.35%E2%80%AFPM-1024x651.png\" alt=\"\" class=\"wp-image-2254\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step2:<\/strong> Initialize Variables<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Add 2 new &#8220;Initialize variable&#8221; to store the first and second part of the string. Use the below image to understand the configurations.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/gilosoft.com\/wp-content\/uploads\/2024\/07\/Screenshot-2024-07-15-at-8.43.03%E2%80%AFPM.png\" alt=\"\" class=\"wp-image-2255\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 3:<\/strong> Add a &#8220;Compose&#8221; action to use the concat function. Set the input to the following expression:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nconcat(variables('firstName'), ' ', variables('lastName'))\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">This will combine the &#8216;firstName&#8217; and &#8216;lastName&#8217; variables with a space in between.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 4:<\/strong> Test the Flow<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Save and test your flow by running it manually. Check the output of the &#8220;Compose&#8221; action to see the concatenated result.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/gilosoft.com\/wp-content\/uploads\/2024\/07\/Screenshot-2024-07-15-at-8.09.20%E2%80%AFPM.png\" alt=\"\" class=\"wp-image-2257\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Use this below image as reference of what your flow should look like:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/gilosoft.com\/wp-content\/uploads\/2024\/07\/Screenshot-2024-07-15-at-8.11.02%E2%80%AFPM.png\" alt=\"\" class=\"wp-image-2256\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Feel free to leave comments or questions below if you need further assistance with implementing the&nbsp;<code>concat<\/code>&nbsp;function in Power Automate!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power Automate is a tool that is invaluable to SharePoint developers because it allows you to streamline workflows and tasks. In this blog, we&#8217;ll explore the concat function and how utilize it in a flow. What is the Concat Function? The concat function in Power Automate is used to join two or more strings into [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":97,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-95","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-automate-text-functions"],"_links":{"self":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/posts\/95","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/comments?post=95"}],"version-history":[{"count":0,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/media\/97"}],"wp:attachment":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/tags?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}