question

user7878-0682 avatar image
0 Votes"
user7878-0682 asked AllenXu-MSFT commented

check if field is blank

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?

sharepoint-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AllenXu-MSFT avatar image
0 Votes"
AllenXu-MSFT answered AllenXu-MSFT commented

Hi @user7878-0682 ,

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

The condition in UI should be like:
132201-image.png


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.


image.png (20.4 KiB)
image.png (7.2 KiB)
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·
AllenXu-MSFT avatar image AllenXu-MSFT user7878-0682 ·

@user7878-0682 ,

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

0 Votes 0 ·
user7878-0682 avatar image user7878-0682 AllenXu-MSFT ·

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

0 Votes 0 ·
Show more comments