Use AND, OR expression in flow conditions

Usually in Microsoft flows you can add only one condition in basic mode. There are no options to add expression like AND, OR. To use these expressions go to advance mode and use the AND, OR . e.g.

I want to use a condition

if (contract value is < 100000 and standard term = 'Yes' )
then
      Do this
else
      Do else


1) To use it in the flows enter the first condition in basic mode, go to advance mode and  copy it in notepad
2) Delete the first condition
3) Apply the second condition, go to advance mode and  copy it in notepad

Create the condition yourself with @and

@and
(
     lessOrEquals(body('Get_item')?['Contractvalue'], 100000),
     equals(body('Get_item')?['standardterms']?['Value'], 'Yes')
)

NOTE: remove all other @ signs from conditions expect with @and

1) Paste the created condition in MS flows condition box in advance mode and you are done.
2) Save the flow and see it is not showing any errors


For more information please use the following URL

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 | 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 | Validate the SharePoint columns are having null values

Question:  How to check null values in MS Flows


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