Using null expression in condition

(0) Share

Report

Posted on by michalparal

Hi to all,

I have a question about using expression "null" in condition.

I am checking for empty sharepoint column.
When I use the condition like this, everything works fine and when the field in the sharepoint list is empty, the condition goes true, when there is any value the it goes false.

But when I try to use the condition like this, it always goes false. Am I geeting it wrong and it could not be used like this?

I'm checking for multiple columns and I need to find the first one which is empty and put some value in it. I had no problems from the start, but as the number of columns started to grow, I needed to add some condotions and when I tried to use six in row inside IF condotion the Flow stops giving me the options as you can see bellow. So I needed to devide the conditions and that is why I need to use "is not equal to NULL"

Thank you for your advice.
Michal

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!
I usually have null related problems abd am afraid I have no answer to your question... that's the reason I then to use coalesce() in such circumstances
https://docs.microsoft.com/bs-latn-ba/azure/logic-apps/workflow-definition-language-functions-reference#coalesce
Hope this helps

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!

Hi @michalparal ,

I have made a similar test on my side and I don’t encounter the same situation.

Have you used other fields to do a similar test?

Besides, you could use empty() function to check if the field is empty.

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
michalparal 29 on at

Like (0)

Report
Copy link

Link copied!

Hi,

thanks a lot, I have been trying to find out what was the problem for 2 days. After you write your answer, I have done some testing and I found out, that in the middle of the flow I had a mistake. So thank you for your response. And also thank for empty function becasuse with it, it works even better.
Thank you,
Michal

Was this reply helpful? Yes No