cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Using null expression in condition

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. 

condotion2.PNG

 

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? 

condotion.PNG

 

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"

condotion3.PNG

Thank you for your advice. 
Michal

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Using null expression in condition

 

Hi @michalparal ,

 

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

45.PNG46.PNG

Have you used other fields to do a similar test?

 

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

47.PNG

Hope this helps.

 

Best Regards,

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

View solution in original post

3 REPLIES 3
Highlighted
Dual Super User III
Dual Super User III

Re: Using null expression in condition

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-refere...
Hope this helps


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Community Support
Community Support

Re: Using null expression in condition

 

Hi @michalparal ,

 

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

45.PNG46.PNG

Have you used other fields to do a similar test?

 

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

47.PNG

Hope this helps.

 

Best Regards,

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

View solution in original post

Highlighted
Frequent Visitor

Re: Using null expression in condition

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

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (8,720)