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
Dual Super User

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
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Kudoed Authors
Users online (11,100)