Data Connections

Re: Query people column from Sharepoint list

thevikk — Tue, 10 Nov 2020 13:02:12 GMT

Hello, I know this thread is old but I found a solution to this problem. Maybe it will help someone :) The part that Hilary Stoupa didn't mention is that you have to go in your list with the people or group column and go to it's settings and set: Show field - account. That way when you are querying form InfoPath it will match the id.

Re: Query people column from Sharepoint list

rvallecillo — Fri, 11 Jul 2014 14:42:45 GMT

It's odd that you were able to query the Person or Group field from a SharePoint list within InfoPath 2010/2013. Maybe I'm missing something. When I try to set a query fields value all of the fields show up except Person and Group fields.

Is there something extra I need to do to set a fields value and it query the SharePoint list for Person and Group?

Thank you.

Re: Query people column from Sharepoint list

Hilary Stoupa — Fri, 20 Sep 2013 23:42:31 GMT

Hi - my domain account is DOMAIN\HilaryS. I created a data connection to a list with a person or group column - column named "User". I set the "User" query field to DOMAIN\HilaryS and executed the data connection - I only had returned the rows that had my account ID. So, I'm not sure what you are doing differently? Are you querying for DOMAIN\UserName?

Re: Query people column from Sharepoint list

Dekstar — Fri, 20 Sep 2013 07:53:46 GMT

It's me again still having the problem. Can nobody help me out? Maybe I did not explain the problem clearly enough?

Query people column from Sharepoint list

Dekstar — Wed, 11 Sep 2013 10:50:03 GMT

Hello everyone, I am currently trying to filter my list datasource. It works great but when it comes to a people-column (author) there is a strange behaviour. First of all the author-column is a simple text-field in queryFields. When I try to filter this field with userName() there is no return (but actually the list is full of items with current author). What can I do to filter for a specific user? Next, when I look at the dataFields, I see what I also expected in queryFields: (pc:Person with DisplayName, AccountId, AccountType). When I output DisplayName it shows up like this: Surname,, GivenName. Why two commata? Hope you can help me out. Infopath 2010, Sharepoint 2010 Std.