I could have just added the Account field to the Custom List data source (and I did that, from Tools > Data Connections ) and used that instead of the Name field, but people usually don't know their managers' account names. I did a little digging and found an MSDN forum post that gave me a great way to let users pick friendly display names, which InfoPath would then use to populate a hidden form field with the corresponding account name Add a Text Box field to the InfoPath form ( Insert > Text Box ). Right-click the text box and choose Text Box Properties . On the Data tab , click the Function ( fx ) button in the Default Value section. Click the Insert Field or Group ... button. In the Data source drop-down list, select Your Custom List . Expand the folders until you see the fields in the User Information List. Click the : Account field (you did add it from Tools > Data Connections > Modify , right?), and then click Filter Data . In the Filter...
Enterprise AI & Cloud Architecture is a thought-leadership platform focused on AI-driven, cloud-based enterprise systems. It examines advanced architectures leveraging SharePoint, Microsoft 365, Azure, Power Platform, RAG, and Agentic AI to modernize mission-critical environments in healthcare, research, government, and enterprise organizations.