How to handle Apostrophe in Ms Flows

Question: How to handle Apostrophe in Ms Flows?

Answer : Use the replace function to handle it 

replace(['Registered_x0020_Business_x0020_'],'''',' ')

It will replace the Apostrophe with a blank space.

MS Flows | SharePoint Choice Field with multiple selections or pick list, not supported. Workaround

Question: MS Flows | SharePoint Choice Field with multiple selections or pick list, not supported. Workaround

Answer:

1) Take a string or array variable, I am taking a string variable

2) Then use apply each and append to string function to collate the value in one string, I have placed a "," to separate the values

Then use this string in your flows.

MS Flows | How to remove last few character in MS Flows from a string

Question: How to remove last few characters from a string in MS Flows?

Answer:

substring(variables('LicenseTypes'),0,sub(length(variables('LicenseTypes')),2))

1) I took example of a string variable

2) Make sure change the variable with your values

3) Make sure you Change the number value at end, I am removing last 2

characters from the string

MS Flows | How to add days function works

Question: How to use add days function in MS flows

OR

Question: How to play with Date and time in MS Flows


Answer:

This answer shows you to add 7 days in SharePoint Date field


formatDateTime(addDays(formatDateTime(string(['License_x0020_Expiry_x0020_Date'])), 7))

1) Convert that date field to string
2) Convert into ISO 8601 format
3) Add 7 days
4) Return the ISO 8610 format date

MS Flows | Validate the SharePoint columns are having null values

Question:  How to check null values in MS Flows


Answer : @equals(coalesce(['Change columns value here'], ''), '')