cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

If field is blank fun. Or not fun.

Hi - I am having supreme frustration with the if field is blank trick. It's not working 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 would also like this trick to work within a Do Until. I presume it's the same trick.

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.

6 REPLIES 6
Super User
Super User

Re: If field is blank fun. Or not fun.

In the condition use Assessor_OutlineSubmitDate is equal to null where null is set from the Expression tab over on the right (that is, you don't type it). It works for me.

Rob
Los Gallardos

Re: If field is blank fun. Or not fun.

It won't work with is not equal to though?
My problem is not a simple if condition where I can choose which direction to go, False or Positive. It's a Do Until where the field by default HAS to be blank. So I have to make the Do Until check to see if the field is blank.

I'm sure there is an expression out there that could help....

v-zhos-msft
Level 10

Re: If field is blank fun. Or not fun.

Hi @cardinalpipkin ,

As the error message said, the expression can't reference the 'Filed'.

It's because the 'Field' is come from the 'Get item' action, and the action is inside the Do Until.

So the expression can't get the value of the Field.

You can put the 'Get item' outside the Do Until for a try.

By the way, I was confuesd about that why you need use the Do Until here.

Usually, the Do Until deal with a varying value, here the Field from a list is a Fixed value.

Why don't you just use a condition to check if the Field is blank.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Re: If field is blank fun. Or not fun.

Hi,

I need a Do Until because I have a reminder email that needs to be sent out every 2 weeks. I don't think an If can loop.

 

Does the 'Get item' have to be used with the Do Until? And therefore does it become available as a dynamic item?
Where do I put it? It's as if the Do Until behaves differently to a simple If. A Do Until does NOT accept
Do Until [Field] is not equal to 'Null'.

 

Excuse all the babbling - here's the simple version: How do you use a Do Until with a blank field?

Massive thank you so far for your help and interest in solving this excruciating problem I'm having.

C

Super User
Super User

Re: If field is blank fun. Or not fun.

If you have a reminder email that goes out every 2 weeks then my view is that you should be using a recurrence schedule as your trigger and set it to 2 weeks, not using a do until. That way every 2 weeks it will check if the column is blank.

Rob
Los Gallardos

recurrence2weeks.jpg

Highlighted

Re: If field is blank fun. Or not fun.

Hi Rob, Sorry I haven't been clear - I can't use a recurrence because my trigger has to be when item modified or created. Modify or creation can happen anytime so don't want it waiting for 2 weeks to start.

What are your thoughts on the Do until? Do they work with field is not equal to null?

I know that Field is equal to null works but why doesn't the double negative and what way around it?

Help much appreaciated.

 

C

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 516 members 5,227 guests
Please welcome our newest community members: