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.

Retrieving All Records owned by other Team Members

 Many times there is a requirement to retrieve all the records of team members where you are a member in those teams. To get them setup the filter as given in image.

Insert New Line in to a String in Power Automate or Flow

 Many times we have gone through with the requirement like to enter address in word document but if the address present into a multipline textbox in CRM then it will be visible as is. To solve this problem we required to insert the address in Multiline textbox in CRM using New Line character, but it is bit dificult to enter it through the Microsoft flow.

Below is the text and the image which need to be inserted in place of "\n".

Text is : json('{"NL":"\n"}')?['NL']

you can utilize it like the image given below.