Nintex 2016 on premises Form Drop-down filtration

[adnanmuscat]

I have following list setup

1. List Name "category" having three column all (Single Line Text)

CATID	CATNAME	MAINCAT
A	ANAME	E
B	BNAME	E
C	CNAME	R
D	DNAME	R
E	ENAME	R

1. List Name "UsersCategory" having two column

Username (People and Group)	MAINCAT
User1	E
User2	R
User3	E
User3	R

1. List Transaction

Column1	Column3	MAINCAT
abcd	efgh	R
dfsf	sddf	E

Based on List Transaction I have created a Nintex Form, and I want to achieve following

• Show a dropdown based on List#1, which display CATNAME filtered by “CurrentUser” MAINCAT mentioned in List #2 ("UsersCategory") List.

If the Current User is “User1” then the dropdown will show only CATNAME (ANAME and BNAME) and if “User3” is a current user then all category will be display.

• I need to save selected value of dropdown in List #3 MAINCAT column.

Any Idea how can I achieve this ?

[SimonMuntz]

Hi,

The key to getting cacading lookups to work is the setup of the lists.
The following blog has the basics which you can expand off.
https://community.nintex.com/t5/Nintex-for-SharePoint/Cascading-drop-downs-and-Nintex-Forms-for-Shar...