cancel
Showing results for 
Search instead for 
Did you mean: 
Automation Master
Automation Master

Re: List Lookup from Multiple Lists and Multiple Filters (Cannot Cascade)

Jump to solution

Well... I mean, I don't know how you are generating the Time Bank list, but so long as you have a column that is populated with *some* data, you should be able to generate a Lookup Control on a Nintex Form that not only points to that Time Bank List, but also filters on whatever column you'd like, using whatever data you'd like no matter where you're getting it from on the Form. 

If you have a list @ Root Site/Sub Site 1/Employee List 

with the contents of: 

Employee Name
John Doe
Jane Doe

and a second list @ Root Site/Sub Site 2/Time Bank List

with the contents of: 

Data TypeEmployee Name
Data A

John Doe

Data BJohn Doe
Data CJohn Doe
Data DJane Doe
Data EJane Doe

Even though the two lists are not linked in any particular way, you should be able to set up two List Lookup Controls on a form (pointing to either list respectively), and use the value from the first control (pointing to the Employee List) to filter the second one (pointing to the Time Bank List)... 

If I were to make Two List Lookup Controls on a Form (no matter where it is on SharePoint), if I set the controls up accordingly: 

LLU EmployeeList:

LLU DataList:

It will filter regardless of whether or not there are actual Lookup Columns on the sites:

Does that help? 

Reply
kelliganp
Nintex Newbie

Re: List Lookup from Multiple Lists and Multiple Filters (Cannot Cascade)

Jump to solution

Hmm... If that works o your site, it does not work on mine. I created a dummy site and made the a 3 list setup with list 1 (L1) populating the first llu control, L2 populating the second llu control and L3 hosing the form with the lookup controls.

Here in L2, I had to make the llu_FullName column a lookup column in order to get it working. I fought with this thing a while until a colleague noticed the difference between mine and the YouTube video creator's setup.

L3 has the following form...

This works but only with the lookup column. If yours works without, I am not sure why mine is different.

I have a 6PM call with the support team and will run them through the setup an perhaps they can see where I have gone off the rails.

I will add one update to this. I created a TimeBank version on the site with the tbl_Werterners list and I made the control work. It is not an optimal solution but it does work.

0 Kudos
Reply
Automation Master
Automation Master

Re: List Lookup from Multiple Lists and Multiple Filters (Cannot Cascade)

Jump to solution

What are you actually filtering by on your second control though...? 

Can you show us your options / properties for both of the List Lookup Controls on your form? 

Reply
kelliganp
Nintex Newbie

Re: List Lookup from Multiple Lists and Multiple Filters (Cannot Cascade)

Jump to solution

Here are two test scenarios. The first one does not work and the second one does.

Scenario One:

L1 layout...

L2 layout...

L3 form layout...

LLU control 1 configuration...

LLU control 2 configuration...

LLU control 2B configuration...

Outcome is LLU control 2 shows all items unfiltered with multiple repeating values and LLU control 2B is blank...

Here is scenario 2... I added a lookup field to L2 pointing to L1 and pointed LLU control 2 to that field.

and...

Now it works and not only does LLU control 2 work but LLU control 2B works as well when pointed at the text field. It seems that as long as one control is pointed to a lookup field/column in the form, any LLU control point to any field on the same list will work.

Sorry for so many images but it is most clear that way.

0 Kudos
Reply
Automation Master
Automation Master

Re: List Lookup from Multiple Lists and Multiple Filters (Cannot Cascade)

Jump to solution

Don't be sorry for including information. The more the better, always and forever. 

So my last idea would be instead of using the value of the control in question, use a formula to produce a lookup value that returns the EmpID number which seems to be a unique identifier which you could use to filter on your second list. 

I'm not sitting at a place with access to nintex, but on your Second Control where it says "Filter available selection" and you have chosen "By Control's Value", you should be able to select "By Value" or something along those lines, and you will have the option to use a formula. 

You should be able to use the Runtime Functions of parseLookup and lookup to grab the value of that EmpID from your first list. 

Again... I'm not at my desk so I can't tell you if this is exactly right but it should look something along the lines of:

parseLookup(lookup(sites/MainCollection/SubSite|L1, FullName, parseLookup({llu_L1}), EmpID)‍‍‍)

the inner lookup function is pointing to a List called L1 that is at the path sites/MainCollection/SubSite

It's the Column it's filtering ON is called FullName

The value that it's filtering BY is the result of whatever you have selected for the control called llu_L1

The value it will RETURN will be the EmpID

That returned value (of EmpID) is then parsed by the outer function and used as the filtering value in the secondary List Lookup Control. 

Again, this is from the top of my head. I'll try to give an example tomorrow, but my biggest guess for why something isn't working comes down to the nature of using Strings as values. If there is an extra space somewhere or a return character that is hidden (because not all characters even show up to you as a human), filtering off of a string can be incredibly difficult and deceiving. 

Using something like Numbers, unique or otherwise, typically leads to better results (unless you're using Lookup Columns in SharePoint which you can't in this case unless you feel like moving your lists to exist on the same site). 


Reply
Automation Master
Automation Master

Re: List Lookup from Multiple Lists and Multiple Filters (Cannot Cascade)

Jump to solution

maybe this one could help https://community.nintex.com/message/64506-re-how-a-copy-list-item-attachments-to-a-folder?commentID... 

it's example for O365, but on on-prem the configuration will be just the same.

Reply
kelliganp
Nintex Newbie

Re: List Lookup from Multiple Lists and Multiple Filters (Cannot Cascade)

Jump to solution

Hi nmarples‌,

I will try to dig into this. Just a quick check shows that the ParseLookup nor the Lookup functions are not options in the InlineFunction tab on of the Filter By Value box. Should it still work? Also, there is no option to dynamically insert named controls into that location.

Regards,

Patrick

0 Kudos
Reply
kelliganp
Nintex Newbie

Re: List Lookup from Multiple Lists and Multiple Filters (Cannot Cascade)

Jump to solution

I will check it out. Thanks!

Reply
Highlighted
kelliganp
Nintex Newbie

Re: List Lookup from Multiple Lists and Multiple Filters (Cannot Cascade)

Jump to solution

Hi nmarples‌ and Marian Hatala,

I spent some time with Nintex Support and they concluded that my issue was in fact hierarchical. I needed to have TimeBank in the same site "branch" as the employee info (tbl_Westerners). I had moved the TimeBank over to that site so it was a direct sibling with tbl_Westerners and the list lookup worked. It is not optimal but for now, I will keep it there so I can move forward on some other issues I need to resolve.

Thanks for struggling with this!

View solution in original post

Reply
Automation Master
Automation Master

Re: List Lookup from Multiple Lists and Multiple Filters (Cannot Cascade)

Jump to solution

Are you sorted now Patrick Kelligan‌?  Sorry I have been on holiday!

Reply