Itqualityassurance
If you are using Microsoft Power Automate with Microsoft SharePoint Online list or library data and need to check if a field is empty or null, you can use the @empty function in an expression.
- Is Empty function in Power Automate?
- How do you check if an array variable is empty Power Automate?
- How do you add a null condition in Power Automate?
Is Empty function in Power Automate?
In Power Automate, Empty Function can be used quickly to find out whether empty value is present or not. Login to the required Power Apps environment using URL make.powerapps.com by providing username and password and click on Flows on the left-hand side as shown in the below figure.
How do you check if an array variable is empty Power Automate?
Check for an Empty Array with the EMPTY Function
You can then use the empty expression to test if the array is empty or not. The expression empty(outputs('myArray')) will return true when the myArray is empty and false when the myArray is non-empty.
How do you add a null condition in Power Automate?
For the right hand box, click in it and go over to the right, select the Expression tab and type null and then select it to put it in the box.
