Skip to main content

I have one list, called as "Approvers"-It has around 20 names in it.


Logged in user might also be one of the approvers in the above list.


I want to populate above names to be populated in list lookup control eliminating logged in user. That is "Created By" cannot select themselves as approver.


Is it possible ?

Maybe this thread helps you achieve your filtering, but instead a drop down, you can use a calculated field that is populated with the current username. https://community.nintex.com/t5/Nintex-for-SharePoint/Cascading-drop-downs-and-Nintex-Forms-for-SharePoint/td-p/86140

Furthermore, instead of using a filter on the drop down list, you could use a rule that shows a banner/disables a button when the selected user equals the current user.

Hi Michael, Thanks for the reply. I dont think calculated will help, because i need list of approvers to select from, not just one single value. Neither can i disable the control, because if i do that how will approver be selected then.


I meant that the calculated value shows the username of the current user. I am not entirely sure, but you can use that calculated value to filter the Approvers in the List Lookup Control to show every approver without the current user.

Hi Michel,


I got you.. I already have the current user in calculated column, but my concern is how do i apply filter in list lookup control to eliminate current user form list of approvers.


 


 


I've tried some variations, and I bet you can make it work with the use of a bit JavaScript. To keep the form simple, I would suggest to use a rule that disables the user to continue (and maybe show a notification) when he/she selects himself/herself in the list of approvers.

You only have to make sure there is something you could validate on (e.g. username or email).

Reply