Filtering Repeating table based on user login Create a new data

Filtering Repeating table based on user login
1. Create a new data connection that connect to web service GetUserProfileByName.
a. From manage connection add new connection
b. Select SOAP Web service, and navigate to : https://***/_vti_bin/UserProfileService.asmx
c. Select Operation: GetUserProfileByName and click next twice
2. Create a new hidden text box that populate AccountName for user that login to sharepoint
list
a. Add new field on main connection named LoginUser
b. Set default value for that field.
Click default value – Insert Field or group – show advance view
Select secondary data connection GetUserNameProfile – select value and click filter
data – add – select field or group – in the property data select name
Click OK – On the comparison select Type a text and type “AccountName”
Clik Ok until all dialog box closed
Test by click preview or press F5 and see if the text box populate with the User
Account that login
3. Create filter on Repeating table base on Created Field (or requestor field)
a. Right click on repeating table and select Repeating Table Properties
b. Click display – Filter Data – Add
c. Select field LoginUser (new field that created) and the comparison field field with
select field or value – click advance view - and select the accountID from the creator
field
d. Click OK until all opening dialog box is closed.
e. Test the filter by pressing F5.
f. Add new condition for Repeating table (Repeating table Filter By User that login =
creator AND Status = Submit.