cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SylvieLet17
Responsive Resident
Responsive Resident

Flow Condition If Field is Blank

Hi all, 

 

Last week I created a Flow with a condition to check if a field is blank. 

The advanced syntax is as such:

 

@Empty(item()?['PublishedVersion'])

 

This was working for a second, but now it is returning always as True, no matter what. 

Can anyone help me? Has anyone built conditions on If Field is Blank??

 

Thanks

30 REPLIES 30

@brijendraydv you type null in the Expression tab in the dynamic content panel:

expressionTab.png

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Thanks a lot for the image example - it works now,any idea how to check also empty value - the issue is i had result set with 8 columns for example but now there are 6 columns as 2 columns dont have value so are not appearing in the result set.However i still have the condition with 8 columns that was before so i want to check if the value is blank for those 2 columns.Not sure if i made it clear.

Thank you Jose. 

For everyone else that might be searching this for the first time.  Here is my experience.

I am working with Forms and I get the Response Details.  I needed to check if a certain form entry was blank so a condition would determine the next step.  I attempted to use the NULL expression as indicated above.  Since I was not familiar with this expression I tried  Null() as the expression.  The correct syntax is Null without Parenthesis.  HOWEVER, this did not work as it kept giving me a FALSE condition regardless of the value in my form.  I used the Variable is equal to and left the right field BLANK and it worked.

So in short, the Null may be effective when working with certain conditions, but as far as checking a variable to see if it "is equal to" nothing, then a blank value appears to have worked.

 

edbellman
Advocate II
Advocate II

FWIW, for my SharePoint text field I had to use the null function to get it to work, leaving the right side blank and other options did not work.

 

flow_null_condition.png

Anonymous
Not applicable

Hi Everyone,

 

I'm a new user of Power App - Flows and I'm stuck with this scenario. My intention is if the Email Address field is empty (using Microsoft Forms) just ignore and not run into some errors. At the moment, with below condition, if the field is not blank then it proceeds to send an email to the intended recipient, which works fine. But what command can I put in if the field is indeed blank?

 

Thank you all in advance.

Mary

 

Capture.PNG

Hi Mary,

 

You have the condition like this (Mail - Is equal to - Null), have you tried not putting in the Null and just leaving it blank?

What I'm saying is instead of using (Mail - Is equal to - Null) you dont put anything (Mail - Is equal to - )

Anonymous
Not applicable

It worked! Thank you @Jose_Azevedo 😊

Spent hours looking for a solution and just leave it blank, my goodness it was there and it took me hours just to find the answer i am looking for. you my friend is great! i Thank you. + 1 like from me.

Anonymous
Not applicable

All of this didn't work for me. I got the empty string value from excel spreadsheet. Apparently it is not empty. So what i did: create a variable leave it empty and compare to that variable. 

The null solution didn't work for me. And the solution empty(body[]) I found too difficult to do. 

In my case it didn't work. I have been trying so many different solutions, and finally I could check if the value is null, and so far so good. This is what I did:

"field name" is equal to "" 

Note: I used double quote.  

Spent a couple of hours trying to figure out why

Field not equal to 'Null' 

wasn't working. 

Changed it to Field is equal to 'Null' and voila!

Thank you, Good Sir. 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,526)