InfoPath Dev

Hi,

I want to compare the user that are filling out the InfoPath form with users in a SharePoint list, to check if the logged in user are the same as in the list. I can get it to work if I only want to look in the column in the list. However, I want to set a filter and therefore only look at one single field in the list. I can also do that in InfoPath, but my problem is if there is more than one user in the field in the list. Then it only look at the first and not all three users.

Example:

The list contains people that have certain permissions. For each department there can be for example three users with this special permission. I want to see if the user that are logged in are any of the three users in that specific department.

Can anyone point me in the right direction? 

Thanks in advance,

Louise 

 So, in your list data connection, the field with the user information is repeating? When you add the filter, you can select the field, then in the bottom of the field picker dialog you should see a drop down (see screenshot) that allows you to select "any occurrence" of the field. That should help you create a filter that checks against all instances for the row.

 Hi Hillary,

Thanks for your reply. Unfortunately I don't have that dropdown you have in the bottom. Do you know why that can be?

 My list in SharePoint looks like this. The first column is the department and the next colums are the users, where there are multiple users in one field.

 Hillary I know it has been awhile since you original response to this question, but I am wondering how the rest of the rule be written?

 OK. So I have a site and because of security concerns css is turned of so I cannot use SOAP or REST services. I read somewhere, that I didn't bookmark, that you can create a permissions list and make a data connection to that list. It seems to me that is what the original poster did.

I saw that in your explanation to him that you filtered the AccountId to all occurrences but what did the rest of the view look like?

My end goal is to be able to "disable this control" on fields based on three different user groups. I know how to create a data connection to a SharePoint list but I am not sure on how to setup that list. Is a list with the SP group permissions or a list with "user, group, permissions" as column headers?

 Hope that helps to clarify things. 

 Thanks.

 I think you are basically asking about that in your other thread, right? I'll follow up there. :) http://www.infopathdev.com/forums/p/38177/115669.aspx#115669