Data Connections

Re: Compare logged in user with users from SharePoint list

Hilary Stoupa — Wed, 22 Feb 2017 17:06:32 GMT

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

Re: Compare logged in user with users from SharePoint list

sdnmjn — Wed, 22 Feb 2017 16:07:22 GMT

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.

Re: Compare logged in user with users from SharePoint list

Hilary Stoupa — Wed, 22 Feb 2017 15:25:40 GMT

Can you clarify your question a bit for me? Sorry, I'm not understanding where you need help. :)

Re: Compare logged in user with users from SharePoint list

sdnmjn — Tue, 21 Feb 2017 16:16:39 GMT

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?

Re: Compare logged in user with users from SharePoint list

Hilary Stoupa — Thu, 30 Jul 2015 15:12:34 GMT

My screenshot is from the first drop down in the condition builder.

Re: Compare logged in user with users from SharePoint list

louidam — Thu, 30 Jul 2015 07:23:48 GMT

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.

Re: Compare logged in user with users from SharePoint list

louidam — Thu, 30 Jul 2015 06:34:07 GMT

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?

Re: Compare logged in user with users from SharePoint list

Hilary Stoupa — Wed, 29 Jul 2015 22:23:19 GMT

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.

Compare logged in user with users from SharePoint list

louidam — Tue, 28 Jul 2015 09:36:05 GMT

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