Hi I have built a time sheet system in Sharepoint 2013 and I am getting some unexpected results for some users (not all).

Basically I have one list which is a basic sharepoint list which lists Project names and has a field "Assigned to" which is a people picker which can accept multiple people onto one project.

Secondly I have a timesheet entry list where individuals assign time against their projects. This list uses an infopath (2013) form and has a drop down which uses a data connection to the first list. This drop down is being filtered by so that the current user will only see the projects that have been assigned to them.

In the infopath form I am using rules on form load to set the query field of the GetUserProfileByName AccountName to the AccountID of the creator of the form. So that I get hold of the person currently logged in. Then in the dropdown field for the projects, I am filtering on where the AccountID in the Project list lookup is equal to the value of the Account field for the person logged on.

The odd behaviour I am experiencing is that this works for some staff but not all. Some people seem to be returning their projects and the projects of their managers!

Does anyone have any ideas at all? Thanks

  • Are you certain the users have a User Profile? Commented Feb 1, 2018 at 13:03

1 Answer 1


Sorted this one myself. The GetUserProfileByName service returns all the properties from AD for that user and this includes their manager. So what was happening was that my filter was using both AccountId's of the user and their manager. Resolved by setting a field to just be the accountId of the user and then filtering on that.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.