Flow Condition If Field is Blank

(5) Share

Report

Posted on by Community Power Pla...

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

Categories:

Building flows

I have the same question (0)

All responses (33)

Answers (1)

Verified answer

PieterVeenstra 13 on at

Like (13)

Report

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.

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

Like (5)

Report

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

Thank you!!

Was this reply helpful? Yes No
matthewnolan 12 on at

Like (2)

Report

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

Thanks,
Matt

Was this reply helpful? Yes No
KSL 6 on at

Like (2)

Report

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?

Was this reply helpful? Yes No
PieterVeenstra 13 on at

Like (2)

Report

what kind of field are you checking?

Was this reply helpful? Yes No
-KSL 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Eric666 4 on at

Like (1)

Report

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.

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

Like (2)

Report

Thank you. It works for me.
"field name" is equal "null" (as expression)

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

Like (40)

Report

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

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (11)

Report

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

Was this reply helpful? Yes No