cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

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

28 REPLIES 28
Highlighted

@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.

Highlighted

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.

Highlighted

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.

 

Highlighted
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

Highlighted

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

Highlighted

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 - )

Highlighted

It worked! Thank you @Jose_Azevedo 😊

Highlighted

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.

Highlighted

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. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (10,607)