Hi all

I have a SharePoint 2010 List with an InfoPath form that customized using MS InfoPath 2010.  In this form there are no of data connections that linked to some SharePoint Lists. There is a list called SP User Permissions, It has Employee column entered using a Person/People picker and a SP User Group column i.e. a look up field from another list.

The employee column displays employees as a user name i.e. domain\username format. I want to get the SP User Group of each logged in user while comparing it with the logged in users user name.

In plain English Test is the user and mydomain\Test is the Account Name of the user's that retrieved from UserProfileService.asmx web service. I want the SP User Group of each logged users to a text box or any other control.

I tried many times to get the Sp User Group of every logged in user but it did not successful. When correctly retrieved the user group of each user I can hide a section within the InfoPath form.

The 2 lists are at the below.

SP User Permissions List

<input class="s4-selectAllCbx" title="Select or deselect all items" type="checkbox" />	Employee	User Group
<input _setup="true" class="s4-itm-cbx" title="1" type="checkbox" />	WATERBOARD\2020611	WB Help Desk Minor Staff
<input _setup="true" class="s4-itm-cbx" title="2" type="checkbox" />	WATERBOARD\2033224	WB Help Desk Minor Staff
<input _setup="true" class="s4-itm-cbx" title="3" type="checkbox" />	WATERBOARD\2056542	WB Help Desk Minor Staff
<input _setup="true" class="s4-itm-cbx" title="4" type="checkbox" />	WATERBOARD\2061899	WB Help Desk Minor Staff
<input _setup="true" class="s4-itm-cbx" title="5" type="checkbox" />	WATERBOARD\2036134	WB Help Desk Major Staff
<input _setup="true" class="s4-itm-cbx" title="6" type="checkbox" />	WATERBOARD\2027968	WB Help Desk Major Staff
<input _setup="true" class="s4-itm-cbx" title="7" type="checkbox" />	WATERBOARD\2033194	WB Help Desk Minor Staff
<input _setup="true" class="s4-itm-cbx" title="8" type="checkbox" />	WATERBOARD\trtech1	WB Help Desk Minor Staff
<input _setup="true" class="s4-itm-cbx" title="9" type="checkbox" />	WATERBOARD\test	WB Users
<input _setup="true" class="s4-itm-cbx" title="14" type="checkbox" />	WATERBOARD\test1	WB Help Desk Major Staff
<input _setup="true" class="s4-itm-cbx" title="15" type="checkbox" />	WATERBOARD\test2	WB Help Desk Minor Staff
<input _setup="true" class="s4-itm-cbx" title="16" type="checkbox" />	WATERBOARD\2045508	WB Higher Management
<input _setup="true" class="s4-itm-cbx" title="17" type="checkbox" />	WATERBOARD\2027941	WB Higher Management
<input _setup="true" class="s4-itm-cbx" title="19" type="checkbox" />	WATERBOARD\spadmin	WB Help Desk Minor Staff
<input _setup="true" class="s4-itm-cbx" title="20" type="checkbox" />	WATERBOARD\mstadmin	WB Higher Management
<input _setup="true" class="s4-itm-cbx" title="21" type="checkbox" />	WATERBOARD\testsp	WB Users
<input _setup="true" class="s4-itm-cbx" title="22" type="checkbox" />	WATERBOARD\testhigher	WB Higher Management
<input _setup="true" class="s4-itm-cbx" title="23" type="checkbox" />	WATERBOARD\testmajor	WB Help Desk Major Staff
<input _setup="true" class="s4-itm-cbx" title="24" type="checkbox" />	WATERBOARD\testminor	WB Help Desk Minor Staff
<input _setup="true" class="s4-itm-cbx" title="25" type="checkbox" />	WATERBOARD\tech01	WB Help Desk Minor Staff

SP User Groups List

<input class="s4-selectAllCbx" title="Select or deselect all items" type="checkbox" />	Title
<input _setup="true" class="s4-itm-cbx" title="WB Help Desk Major Staff " type="checkbox" />	WB Help Desk Major Staff
<input _setup="true" class="s4-itm-cbx" title="WB Help Desk Minor Staff " type="checkbox" />	WB Help Desk Minor Staff
<input _setup="true" class="s4-itm-cbx" title="WB Users " type="checkbox" />	WB Users
<input _setup="true" class="s4-itm-cbx" title="WB Higher Management " type="checkbox" />	WB Higher Management

Please could someone help me to solve this matter.

Thank You,

Chiranthaka