How do I hide a empty list lookup control when not needed?

[dan123]

Hello,

Here is my Problem I have a Cascading lookup in my Nintex Form that works.  The problem is that for some of the selections when filtered there are no results.  I want to hide those lookup controls when empty but because of the default return value of a lookup (null) I can't get the rule to work.  If I use the Rule isnullorempty(Affiliation) or not(Affiliation) it will hide but will not unhide when required to enter more Choices. What am I doing wrong?

[xMikeX]

Hi Daniel,

What you'll have to do is write a rule that targets the prior selected value of the prior lookup ---- so if you select a value in List Lookup A that dictates List lookup B should be shown, then you're rule should account for this.   Depending on the number of permutations/values, your rule may become complex or long so you will have to figure out how to optimize it best for your situation.

Thanks

Mike

[emha · Accepted solution]

have a look on this similar case here -   

you will need to use formula like shown in there in formatting rule to hide empty control

[xMikeX]

Funny,  I was also going to suggest using a calculation control in combination with my suggestion, but I like to sometimes leave things to the imagination. 

[dan123]

The final solution was to use the calculated value from the filtering lists and columns and use that to create a total number of values when filtered.  That way if their was any results the final formula in the calculated control was        length(lookup('Affiliation','Title',Affiliation,'Parent1'true)) I had to use it for all the cascading fields.  Then it was a simple hide if Filtervalue(calculatedcontrol)==0 rule to hide. Cascading lookup validation control  goes in to more detail if anyone has questions.

Thanks for the help!

[emha]

I'm sorry I have broken your imaginations

[xMikeX]

Not mine, but the dreams of others

(jk)

[SPWonder81]

Hi emha, 

Would you repost the URL to the article to which you were referring? Thanks!

[burak_yildirim]

One comma is missing in this post but it worked for me 🙂
In addition, "length" function return 1 if lookup empty but "count" function return 0 if lookup empty. So I use with count function in my case. Thank you,

count(lookup('Affiliation','Title',Affiliation,'Parent1',true))