Power Automate Condition If Blank

In this Power Automate tutorial, we will discuss Power Automate Condition If Blank. And also we will discuss the below headings with examples:

  • Power Automate condition if blank
  • Power Automate condition if not blank

Power Automate condition if blank

Here we will check the Power Automate condition if blank using Power Automate or Microsoft Flow.

Assume that, we have a SharePoint Online list called TaskList, which consists of different columns as highlighted below:

Power Automate condition if blank
Power Automate condition if blank

Here, we will check if the number of days to complete the column which is of integer data type is blank or not. And the flow will trigger when a new item is created or the existing item is modified on the SharePoint list.

To achieve this follow the below steps:

  • On Power Automate, create an automated flow by selecting +New flow. In the Automated flow popup window, enter the flow name.
  • Choose the trigger when an item is created or modified and click on the create option as highlighted below:
Power Automate condition if blank example
Power Automate condition if blank example

To configure the trigger, we have to enter two required fields called Site Address and List Name here I have selected my SharePoint site and the SharePoint list Name (TaskList).

Example of Power Automate condition if blank
Example of Power Automate condition if blank
  • Now, Once the Trigger is ready we will implement the action flow logic by selecting plus sign (+New Step)-> Add an action as below:
Power Automate condition if not blank
Power Automate condition if not blank

From the list of actions, Now we will check if the field is blank or not using condition action. So click on the Next step and select condition control action.

Power Automate condition if not blank example
Power Automate condition if not blank example

Then we will add the condition if the number of days to complete is equal to null or not

number of days to complete value is equal to null
  1. value: number of days to complete dynamic content
  2. Operator: is equal to
  3. value: null ()
Example of Power Automate condition if not blank
Example of Power Automate condition if not blank
  • Click the flow checker as well to see if there are any problems.
  • If so, fix it. If not, move on to testing the flow. Select Test-> Manually-> Save & Test.
Test Power Automate flow example
Test Power Automate flow example

Create a new item or modify the existing item in the SharePoint list. Here I am going to add the new item with a blank value for the number of days to complete. And Save the SharePoint list item.

condition if blank in Power Automate
condition if blank in Power Automate

In my case the number of days to complete the field is blank, so it returns a true value.

condition if blank in Power Automate example
condition if blank in the Power Automate example

This is how to check if the field is blank using the condition action in Power Automate or Microsoft Flow.

See also  Power Apps Navigate Function + 16 Examples

Power Automate condition if not blank

Let us see how we can check the Power Automate condition if not blank using Power Automate or Microsoft Flow.

We will use the same SharePoint Task list to check the if not blank value in Power Automate.

Here, we will check if the number of days to complete the column which is of integer data type is not blank. And the flow will trigger when a new item is created or the existing item is modified on the SharePoint list.

To achieve this follow the below steps:

  • On Power Automate, create an automated flow by selecting +New flow. In the Automated flow popup window, enter the flow name.
  • Enter two required fields called Site Address and List Name to configure the trigger and here I have selected my SharePoint site and the SharePoint list Name (TaskList).
Example of Power Automate condition if blank
Example of Power Automate condition if blank
  • Once the Trigger is ready we will implement the action flow logic by selecting plus sign (+New Step)-> Add an action.
  • From the list of actions, select condition control action and apply the below formula.
number of days to complete value is not equal to null
  1. Operator: is not equal to
  2. value: null ()
  3. value: number of days to complete dynamic content
Power Automate condition if not blank
Power Automate condition if not blank
  • Select flow checker to fix the errors and warnings and then Select Test-> Manually-> Save & Test.
Test Power Automate flow example
Test Power Automate flow example

Here we will modify the existing item which does not contain a blank value and we will see the result once the flow runs.

Example of condition if blank in Power Automate
Example of a condition if blank in Power Automate

In the below screenshot, you can see that the number of days to complete the field is not blank, so it returns a true value based on the condition applied.

Example of Power Automate condition if not blank
Example of Power Automate condition if not blank

This is how to check the Power Automate condition if not blank using Power Automate Flow.

See also  Send an Email When an Item is Deleted in SharePoint via Power Automate

In this Power Automate tutorial, we have discussed Power Automate Condition If Blank. And also we have discussed the below headings with examples:

  • Power Automate condition if blank
  • Power Automate condition if not blank

You may also like:

>