Unanswered

Looking for null value in condition

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a simple flow that is supposed to update a row in SQL if a field is null. I am only pulling back the ID from SQL and then looking to update records identified if one of the fields is NULL. However, it is always throwing true at the condition and updating records even if the field is NULL. I have tried using the null function and typing the word null or NULL but none of it works.

nullMicrosoft Flow.png

I found a post with this format but I don't know how to get a one line condition like this (I am always seeing the three fields like the snapshot above) AND I am not sure what the part in the [] is referencing (is that the field to check for null?)

How can I only update records if this field is null?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Basically, if we want to determine if the field is empty, it is valid to use null.

The situation you are experiencing is because you set Select Query to the specified field, so Get rows will only return the value of the specified field.

Although you can apply Dynamic content of other fields, they are all null values, so the result is true.

Best Regards,

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

Like (0)

Report
Copy link

Link copied!

So how do I determine if that one field in my select query is null or not? I need to do the following:

If myfield is null, update the field, if not just skip it.

If I understand what you are saying, the null is looking at the whole row? I guess I don't understand that as the query is returning rows.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

You do not need to configure Select Query, use Condition to determine whether the specified field is empty, and if it is empty, update the current row.

Best Regards,

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

Like (0)

Report
Copy link

Link copied!

I am not at all understanding how what you are suggesting is different than what I have already done. The following is always returning false regardless of whether the field is null or not.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Only one difference-not configure Select Query:

Best Regards,

Was this reply helpful? Yes No