Skip to main content
Nintex Community Menu Bar

How to filter Lookup column based on Assign To Column in nintex forms Sharepoint

  • June 23, 2017
  • 4 replies
  • 12 views

Forum|alt.badge.img+5

Hi All,

I have one list, list has 2 column's. 

 1) "Engagement Name" Column

 2) "Assign To" Column

   Here Engagement Name column is lookup column, and it's looking up same list and same column for the value.

   and my question is Engagement Name column contains multiple engagement names. I want to filter Engagement            Names Based on Assign To Column in the list. 

 ex: if I open the Nintex forms i want to see only my Engagement Names in the lookup filed through filter options.

 

Give me some suggestions !!!

Thanks,

Santhosh.

4 replies

Forum|alt.badge.img+14
  • Scholar
  • June 25, 2017

what's datatype of 'Assign To' coulmn? people or group?

do you always want to filter by a user who opens the form? or can it different user?


Forum|alt.badge.img+5
  • Author
  • June 26, 2017

Hi Marian,

'Assign To ' column is people picker type. and only single people picker.

 I want to filter by a user who opens the form only.

Thanks,

Santhosh.


Forum|alt.badge.img+14
  • Scholar
  • June 26, 2017

then it should be quite easy and something like this should work

204948_pastedImage_1.png


Forum|alt.badge.img+5
  • Author
  • June 26, 2017

Hi Marian,

Thank you for your help. it's working fine now.

Regards,

Santhosh.