cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION

Accepted Solutions
Pieter_Veenstra
Community Champion
Community Champion

Can you try by adding the field i the left hand side of the condition and use the expression null on the right hand side.

View solution in original post

33 REPLIES 33
Pieter_Veenstra
Community Champion
Community Champion

Can you try by adding the field i the left hand side of the condition and use the expression null on the right hand side.

That was so simple. Why are you the FIRST person to mention this option on the entire internet?!

 

Thank you!!

Can you explain more of the solution? What exactly was the final solution?

 

Thanks,

Matt

This is what I'm trying to find too but cant seem to get it right. Can you publish the condition so we can see how you put it together please?

what kind of field are you checking?

I am runinng a bit of a SQL sync. A custom SQL table gets the SharePoint List ID value to that we can quickly update the matching rows between the tables periodically. In this flow, I am checking for a value in the SQL List results (SPO ID field (datatype int)) if it's null then I haven't create the row in the SharePoint list yet, so I I will go create it and then update the SQL value with the new row ID. If it has a value, then it already exists and I want to update that row in the SPO list.  So the condition works when it's empty, but when it's not it fails because "The template language function empty expects its parameter to be and object, an array, or a string. The provided value is of type integer. Please see blah blah blah." So I need to change the data type or make it a string, that seems pretty hokey...I must be missing something.

Like proper grammar, double negatives are bad in Flow.  Do a check for null and if the answer is false then build your decisions down the No path in the condition.  This isn't an approval, saying No is not a bad thing.

Thank you. It works for me. 

"field name" is equal "null" (as expression)  

Anonymous
Not applicable

For visual learners, I believe this is what the recommendation is. 

Condition Check if Null.png

 

 

AlanPs1
Resident Rockstar
Resident Rockstar

Please check here or here for a solution.

"Enter your expression on the left side of the row. Then, select Equals to and enter true."

 

So what used to be:

 

Has now become:

If helpful, please mark with thumbs up.

Thanks, Alan

Anonymous
Not applicable

Have things changed since this last post because this doesn't work for me.

Here's my flow:

ASD.PNGasdf.PNG

I'm essentially trying to do the if field is blank trick. And it ain't working no matter how many tutorials and guides I've read.

 

Scenario:

My field is in a list in SP. It is blank. I want the flow to send an email if the field is blank and not to if it has something in it.

I have tried the dynamic content way and am now trying the expression way. I first tried:

(a) 'Field' is equal to 'Null' - didn't work

Then I tried the above pictures provided - it won't accept it as you can see from the second picture.

 

Please help. Hair pulling happening.

Anonymous
Not applicable

Did you try it the way I have it pictured with the List field in the left hand condition (not a formula) and the condition "null" on the right side?  

Anonymous
Not applicable

Hi Brendan,

 

Yes have tried that but it's not working, as in it's giving me the 'I don't like 'null' error.

It's a Do Until with the left hand value populated by the list field (not a formula) a condition of 'is not equal to' and the right hand value with the expression 'null'

I've heard that a double negative doesn't work. I have no choice! I cannot put anything into the field by default.

Is there a way to create an expression which gives out a true or false or a yes or no which Flow can valuate on? IF so how?

Thanks

C

thank you

 

works for me

javierz
Advocate II
Advocate II

the answer of


Brendan Murphy


It works well

Jose_Azevedo
Frequent Visitor

I´m trying to make a flow that creates an item on a sharepoint list after a Form from Forms is submited, and on that form if a field is empty I wanted the flow to make onething but if it had something it had to do something else.

I tried using the Null expression on the condition (Field > Equal to > Null) and it only worked when the condition was false, in other words only when the field wasn't empty.

So I just didn't put the Null expression and left it empty (Field > Equal to > ) just to try, I never really thought it would work but to my surprise it worked like a charm.

Anonymous
Not applicable

Welcome back to preview mode 😀

@Pieter_Veenstra Do you know if checking for a people field can be used with null?  Source is a sharepoint list but it is failing every time when I try to use the People on the left and the null expression on the right?  Thanks! 

Anonymous
Not applicable

Hi @Anonymous @Anonymous @Jose_Azevedo @Jose_Azevedo ,i dont see any function like null in flow?how did you checked empty or null value in msflow?im trying to compare null and empty values  both after using powequery transofrm from sql.

Thanks in advance.

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Summer of Solutions | Week 3 Results | Win free tickets to the Power Platform Conference

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22  

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (4,285)