{"id":35,"date":"2024-09-06T10:06:41","date_gmt":"2024-09-06T17:06:41","guid":{"rendered":"https:\/\/gilosoftblogcom.wordpress.com\/?p=35"},"modified":"2024-09-06T10:06:41","modified_gmt":"2024-09-06T17:06:41","slug":"using-substring-function-in-power-automate","status":"publish","type":"post","link":"https:\/\/blog.gilosoft.com\/index.php\/2024\/09\/06\/using-substring-function-in-power-automate\/","title":{"rendered":"Using Substring Function in Power Automate"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">One of the key features of Power Automate is the ability to manipulate text using built-in functions and expressions. In this blog post, we will explore the&nbsp;<code>substring<\/code>&nbsp;function, which is used to extract a specific part of a string. This function is particularly useful for handling and processing text data efficiently.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>What is the Substring Function?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The&nbsp;<code>substring<\/code>&nbsp;function in Power Automate extracts a portion of a string based on specified starting index and length parameters. This can be extremely helpful when you need to isolate specific sections of text from larger strings, such as extracting part numbers, date segments, or other formatted data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step-by-Step Guide to using the Substring Function<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 1:<\/strong> Create a new instant cloud flow with a manual trigger<\/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-25-at-11.15.09%E2%80%AFAM-1024x653.png\" alt=\"\" class=\"wp-image-2382\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 2:<\/strong> Add a text input to the manual trigger<\/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-25-at-11.23.03%E2%80%AFAM-1024x310.png\" alt=\"\" class=\"wp-image-2383\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 3:<\/strong> Add an initialize variable action card with the following details<\/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-25-at-11.23.43%E2%80%AFAM-1024x548.png\" alt=\"\" class=\"wp-image-2384\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 4:<\/strong> Add a new compose action card with the following details:<\/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-25-at-11.34.12%E2%80%AFAM-1024x361.png\" alt=\"\" class=\"wp-image-2385\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 5: <\/strong>Add a substring action card with the following details:<\/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-25-at-11.35.45%E2%80%AFAM-1024x334.png\" alt=\"\" class=\"wp-image-2386\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 6:<\/strong> Save and Test the flow. Use &#8220;Friday&#8221; as the input.<\/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-25-at-11.37.11%E2%80%AFAM.png\" alt=\"\" class=\"wp-image-2387\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Your results should be as followed:<\/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-25-at-11.39.17%E2%80%AFAM-1024x674.png\" alt=\"\" class=\"wp-image-2388\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>One of the key features of Power Automate is the ability to manipulate text using built-in functions and expressions. In this blog post, we will explore the&nbsp;substring&nbsp;function, which is used to extract a specific part of a string. This function is particularly useful for handling and processing text data efficiently. What is the Substring Function? [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":66,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-35","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\/35","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=35"}],"version-history":[{"count":0,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/posts\/35\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/media\/66"}],"wp:attachment":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/media?parent=35"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/categories?post=35"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/tags?post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}