It's been years since I've been able to develop InfoPath forms, and while I know there are more options out there nowadays, it's the only tool I have available to me at this time. I've forgotten how to do so much, though!
Here's my current issue...
I've added a secondary source to my form, which is connecting to a list that will maintain approval configuration structure. The list contains three columns - Title, User, and Email. (So for example: Manager, John Doe, john.doe@abc.com).
I want to add a calculated column on my form to show the name of the person that matches the Title. (Basically show User where Title = Manager).
How do I accomplish this?