Answered

Flow Condition "if field is blank" always returning false

(1) Share

Report

Posted on by Community Power Pla...

Hi all,

I'm trying to have a Flow check if a field is empty. I used the syntax: @not(empty(triggerBody()?['MyField'])) found in this thread:

https://powerusers.microsoft.com/t5/2017-Flow-Forum-Holiday-Haul/Check-if-sharepoint-field-is-not-blank/td-p/73519/page/2

But no matter what the condition returns false.

Same with this syntax: @Empty(body('Get_file_properites')['MyField']) found in this thread:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Check-if-a-field-is-blank-in-SharePoint/m-p/67141#M9592

My whole Flow is like this:

Where If Yes an approval process is started, and If No, an email is sent.

No matter what, the condition runs as false.

Any advice?

Sylvie

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Update:
I changed the field from a hyperlink to a single line of text field.
The Flow now runs both actions after the condition.

So it starts an approval process AND it sends an email. Which is bizarre.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Solved.

For whatever reason, those syntaxes weren't working.
This one did:

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Update: this condition is no longer working.

Now it is only returning as true.
With the syntax @Empty(item()?['PublishedVersion']) it is returning True whether PublishedVersion is empty or not.

Help?

Was this reply helpful? Yes No
JLam63 48 on at

Like (1)

Report

Any updates on this? I am currently having the same issue. Always True.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (10)

Report

Looks like @Pieter_Veenstra already answered this question for me ages ago and I blanked it all out. Probably trying to forget my traumatic experiences.
He answers it here: https://powerusers.microsoft.com/t5/Building-Flows/Flow-Condition-If-Field-is-Blank/m-p/136853#M13540
Solution is:

Using Basic Mode, set your field and then use Expression Null in the value field on the right.
Seems like advanced mode just doesn't work.

Thanks Pieter (again)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Amazingly I can't get "null" to work for me now. It even pops up in the suggester box but when I click it it says "invalid expression". I did get your initial suggestion (@Empty(item()?['MyField'])) to work though!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

For some reason, the null method does not work for me. I have an Assigned To (people/group column) that breaks my flow if no name is entered, so I am adding a condition to auto assign if null. Unfortunately, the condition always returns False.

Was this reply helpful? Yes No
asaris 6 on at

Like (0)

Report

Check for Null works fine for me (Release April 2020).

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I tested it on a new flow and it still did not work for me. There seems to be a decent variation of functionality between users on forums when it comes to the person/group columns. I wonder if there is something different with company profiles that causes this?

Fortunately, I am no longer relying on the person/group field. I chose to create an array variable with user emails, append my different scenarios, remove any duplicates and convert to a "claims" field format. So far, this has been working wonderfully for me.

Best regards,
Alex

Was this reply helpful? Yes No
vguddanti 6 on at

Like (2)

Report

Simply give an empty string means just the quotes ("") instead of null. Works for me though!!

Field equals to ""

Hope this helps!

Was this reply helpful? Yes No