Tuesday, October 20, 2020

Split the String values with a special character in MS Flow to convert this into Array

 Many times we have a requirement to prepare the Mailing address for some of the documents, suppose there are Address Line1, Address Line2, Address Line3, City, Country and Zip code. your requirement to put this address like below.

Address Line1

Address Line2

Address Line3

City, Country

Zip Code

Now suppose Address Line2 is empty in that case it will show the 2 line space between Address Line1 and Address Line3.

To remove this space inside the flow we will use the split function, suppose your string variable having the value like- AddVar = Address Line1,Address Line2,Address Line3,City, Country,Zip Code

Now you use an "Apply for each" for this variable and traverse the values and finally append into another string variable "VarActualAddress".

To Split values use the expression split(Addvar,','), then check the Current value empty condition and finally append the current value into another variable "VarActualAddress"

For your reference follow the below image.




Split the String values with a special character in MS Flow to convert this into Array

 Many times we have a requirement to prepare the Mailing address for some of the documents, suppose there are Address Line1, Address Line2, ...