Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 1 (6 items) Re: People Picker field query syntax (InfoPath 2013 for SPO list) 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! Posted to Data Connections (Forum) by zosburn on 02-11-2020 Re: People Picker field query syntax (InfoPath 2013 for SPO list) 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. ... Posted to Data Connections (Forum) by zosburn on 02-10-2020 Re: People Picker field query syntax (InfoPath 2013 for SPO list) 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! Posted to Data Connections (Forum) by zosburn on 02-09-2020 People Picker field query syntax (InfoPath 2013 for SPO list) 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 ... Posted to Data Connections (Forum) by zosburn on 02-07-2020 Re: Form load rules to set and appended multiple values in MSLB Hello Hillary! I've attached a copy of my form. The control in question (changeMangementImpacts_mch) is at the bottom of view 2.11. The form load rules I have are the very last rules under Form Load. This is for an SPO List, just FYI. Essentially, these form load rules are checking if columns in a separate list are marked for a specific ... Posted to Controls (Forum) by zosburn on 02-07-2020 Form load rules to set and appended multiple values in MSLB This if for InfoPath 2013. Came across a previous thread for writing values from a MLSB to another control which was very helpful for understanding the double eval formula. I am attempting to do something similar, but append the selection values within the MSLB control. Currently, I have 5 conditional form load rules which trigger and set a ... Posted to Controls (Forum) by zosburn on 02-07-2020 Page 1 of 1 (6 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.