In sharepoint I'm trying to use power automate to create a flow. I need to set a condition to check if a field is empty. I checked if it's null but it gives non empty field too. I have set it as: ExpryDate is equal to null But it just doesn't work. It doesn't filter out the non empty. Any ideas why?

Hi @user7878 , Please check if you set "null" in the condition via Add dynamic content > Expression > Type null in the fx text box > OK. The condition in UI should be like: If an Answer is helpful, please click " Accept Answer " and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

check if field is blank - Microsoft Q&A

Accepted answer

Allen Xu_MSFT 13,806 Reputation points

2021-09-15T02:00:22.927+00:00

Hi @user7878 ,

Please check if you set "null" in the condition via Add dynamic content > Expression > Type null in the fx text box > OK.

The condition in UI should be like:

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
user7878 61 Reputation points

2021-09-15T14:43:06.207+00:00

Hi AllenXU-MSFT,

That's what I did but the records still appear. I even re-checked if I'm looking at the right column.

Allen Xu_MSFT 13,806 Reputation points

2021-09-16T01:24:13.633+00:00

@user7878 ,

What is the column type of "ExpryDate"? A date and time column or anything else?

user7878 61 Reputation points

2021-09-16T01:32:22.08+00:00

It's a date and time type. When I click on it it gives me a calendar to choose the date.

Allen Xu_MSFT 13,806 Reputation points

2021-09-16T02:01:39.837+00:00

@user7878 ,

So, in your case, the flow can run successfully but the condition always returns true even if the field is not empty, right?

user7878 61 Reputation points

2021-09-16T14:52:57.473+00:00

Yes, I don't know why but it gives me empty and non empty records

Allen Xu_MSFT 13,806 Reputation points

2021-09-20T01:21:05.797+00:00

@user7878 ,

Can you please check the following:

There are no default values in the column.

Can you add a compose action prior to the condition and verify it is in fact empty/null.

Allen Xu_MSFT 13,806 Reputation points

2021-09-23T02:29:27.02+00:00

@user7878 ,

Is there any update?

user7878 61 Reputation points

2021-10-03T02:30:08.26+00:00

I was able to fix the problem. Get Items didn't gather all the items, I had to manually add in a limit to get all the items. Then I was able to filter the value for null and that seems to work.
Sign in to comment

Share via

check if field is blank

0 additional answers