InfoPath Dev

Hello. I am trying to query a Secondary List (8000+ items) using a people picker value from the Main Data Connection, however I am unable to figure out the correct syntax which results in the listview threshold error. I've noticed the Query field (text) for a people picker control is not the same as the Data field (Group) - screenshot attached. I've tried setting the secondary data connection query field to the AccountId of the main data connection people picker field, with no luck.

The end goal is to query for and return items from the secondary data connection related to the person in the people picker field. Any suggestions? Thanks in advance!

I did a quick experiment, and with a single select person picker in a list connection, the Display Name worked for me in a query. Give that a try. :)

Very strange. I ran the same test after confirming both lists used identical people picker column settings with no luck. Could you attach a copy of your form? I've attached mine. Thanks very much for your response, Hillary!

Mine isn't a list form - but it works in the browser.

Welp, I was able to produce a successful query using people picker fields on a list with under 5000 items, however the same query fails on my list with more than 5000 items. I double checked to ensure the column settings were the same across all lists used, but still no luck.

Very strange. I'm stumped as to why this would affect the query. Any thoughts? Thanks for your response!

I was able to resolve my issue with a workaround using a workflow to set a single line of text column in the Secondary Data Connection list to the login ID of the people picker column value. Then, I was able to successfully set the query value to the AccountID of the people picker value in my form. Not the cleanest, but it works!

Sorry I missed your other post - glad you found a work around. It could be that indexing on that field doesn't index the display name? Because I think the field we query on must be indexed once over the list threshold.