check if field is blank

user7878 61 Reputation points
2021-09-14T19:30:07.363+00:00

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 Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,761 questions
0 comments No comments
{count} votes

Accepted answer
  1. Allen Xu_MSFT 13,791 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.
    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.


0 additional answers

Sort by: Most helpful