I am trying a concept to control the workflow of a form.
I am reading in a sharepoint list of emails along with the role of the users.
A list might look like:
[email protected];
[email protected];
[email protected] || Admin
[email protected];
[email protected] || Super Admin
I save these entries on the form in an appropriate field for email and role.
When a form is opened, I read the user's email field and save it to a form field.
I am now trying to do a comparison event.
If Admin contains User Email - then....
If Super Admin contains User Email - then...
So if a user came in with email
[email protected] - they would be true for both events above.
I have a view on my form where I have the Admin and Super Admin emails as well as the user's email displayed.
I have ensured both areas are lowercase (using translate)....
But the contains condition does not report true when a user's email IS listed inside of one or more of the saved roles.
So I am curious, how does contains actually operate as an InfoPath condition?
Is it similar to:
Select * from Users where Email Like '%b$b.com%'
Thanks in advance