Skip to main content
Nintex Community Menu Bar

Nintex form lookup to return multiple against multi-select choice column

  • September 17, 2019
  • 2 replies
  • 60 views

thesturl
Forum|alt.badge.img+1

Hi forum users!

 

I am looking for some guidance to help me configure a Nintex form. Here is my scenario:

 

- I have a choice column named Control ID

- I have a calculated column named Control Description, which utilises the lookup formula against a separate list to return the Description of the Control selected within the Control ID column above

 

This works fine when a single selection is chosen in the Control ID column. However, I require the user to be able to select multiple Control IDs and the Description for each to be returned via the lookup function.

 

I hope I have explained this adequately and any suggestions on the approach to take would be very welcome. If further detail is needed please let me know.

 

Thanks in advance!

2 replies

Forum|alt.badge.img+11
  • Scholar
  • September 17, 2019

Are you looking for Cascade dropdowns? Can you add some screenshots? I have a form that works with Cascade dropdowns, may be able to help.


Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • September 17, 2019
Hi,
Unfortunatley you cannot configure a Lookup function with multiple filters.
One thing you could do is to have a Label with the description appear if an option is selected.
If the description changes you could still use a calculated value control but it would lookup only for the specific option chosen.

The following community posts explains how to show specific controls based on a multi select check box. https://community.nintex.com/t5/Nintex-for-SharePoint/Need-help/m-p/101491/highlight/true#M70279