I have a form that captures an employee's name and I need to validate that name against a SharePoint list of users ineligible to submit a request. I can't seem to find a way to make this rule even though I've tried numerous ways. Does anyone know how I would do this?
What do you want to achieve here? I'm not sure how your form would help you there. A user that has no access to the list will never be able to create new forms... Maybe its better to capture that in a workflow?
I'm creating a form to allow employees to recognize each other for achievements in the workplace but the form must exclude senior management from being able to be selected for recognition. So I have a people picker box that needs to validate that the person enter doesn't reside in a list of ineligible senior management. Hopefully that makes sense.
I've tried using a lookup function but haven't been able to get it work. I've also tried putting the users into a group and then using the IsMemberOfGroup function and that doesn't seem to work either. I would have assumed one of those function would have been what I'm looking for to get this working.
You can create a Sharepoint Group and the check your user against this Group. Take a look at >>> Nintex: Check if a user is a member of a SharePoint group
how do you ' captures an employee's name' (free hand text, lookup field, people picker ...) in a form and how do you store equivalent employee's name in a validation list? do you compare relevant things?
could you post a short example?