Skip to main content
Community site session details

Community site session details

Session Id : zlXrhhDH+ezXFcdO/1giND
Power Automate - Building Flows
Unanswered

Condition to check if a field is empty on a sharepoint list - trouble setting it up?

Like (0) ShareShare
ReportReport
Posted on 29 Apr 2024 09:56:39 by 6

I've read in a few posts on the net about how I can trigger a flow to start if a Sharepoint list item is added, but it's row is empty.  I want to do this for a list of new staff, and if the 'email' column is empty, I want to kick off a mail to our IT guys to get them to create an email for them.

 

I've set up the 'condition' to look like this:

zzyzxuk_0-1714384353838.png

 

And in the 'condition' logic, I've included this:

zzyzxuk_1-1714384424839.png

 

When I test this though, it always assumes that this field isn't empty.    Any ideas where i'm going wrong here?

 

(i'm also thrown off by the fact that the dialog is structured so I always see the 'is equal to' dropdown, which doesn't feel appropriate in this case, but it seems to always be there?)

 

  • David_MA Profile Picture
    11,873 Super User 2025 Season 2 on 29 Apr 2024 at 12:22:16
    Re: Condition to check if a field is empty on a sharepoint list - trouble setting it up?

    The checkboxes are used when you have multiple conditions, and you want to group the conditions to make AND/OR evaluations. Since you only have one condition, you don't need to worry about it.

  • zzyzxuk Profile Picture
    6 on 29 Apr 2024 at 12:18:34
    Re: Condition to check if a field is empty on a sharepoint list - trouble setting it up?

    Ah - like this?  (And is that tickbox important at all?)

    zzyzxuk_0-1714393096613.png

     

  • David_MA Profile Picture
    11,873 Super User 2025 Season 2 on 29 Apr 2024 at 12:16:21
    Re: Condition to check if a field is empty on a sharepoint list - trouble setting it up?

    No. You manually typed the word "true." You need to use the expression builder to choose the true expression. When done correctly, true will be pink indicating it is an expression:

    David_MA_0-1714392968132.png

    The checkboxes are used when you have multiple conditions, and you want to group the conditions to make AND/OR evaluations. Since you only have one condition, you don't need to worry about it.

  • zzyzxuk Profile Picture
    6 on 29 Apr 2024 at 12:12:49
    Re: Condition to check if a field is empty on a sharepoint list - trouble setting it up?

    Do you mean like this?:

     

    zzyzxuk_0-1714392717873.png

    (And can anyone tell me what that tickbox is for to the left of the magenta rectangle?  Does it need to be 'ticked' for it to be evaluated?)

  • David_MA Profile Picture
    11,873 Super User 2025 Season 2 on 29 Apr 2024 at 12:01:09
    Re: Condition to check if a field is empty on a sharepoint list - trouble setting it up?

    You don't have any value entered on the right side of your condition. If you want to check if the field is empty using the expression you show, you need to use the expression builder and enter true on the right side of the condition. Alternatively, if you want to check that it is not empty, you will enter false on the right side of the condition.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete