Data Connections

Re: Calculated field to show a secondary data source with a specific value

clawrence — Fri, 27 Sep 2019 15:51:27 GMT

Thank you so much, that worked! You never cease to amaze me!

Re: Calculated field to show a secondary data source with a specific value

Hilary Stoupa — Fri, 27 Sep 2019 15:45:24 GMT

Try replacing your current calculated value with this: xdXDocument:GetDOM("Change Control Approvals")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:User[../d:Title = "SVP, Collections"]/pc:Person/pc:DisplayName

I don't know why, but when you added the filter, InfoPath added the full path to the "Title" field - so that was probably not going to work.

Re: Calculated field to show a secondary data source with a specific value

clawrence — Fri, 27 Sep 2019 15:37:14 GMT

Sure, there's a calculated field at the bottom of the Approvals view that I'm working with.

Re: Calculated field to show a secondary data source with a specific value

Hilary Stoupa — Fri, 27 Sep 2019 15:28:06 GMT

Any chance I can see a copy of your form? You can attach it under the options tab in a reply.

Calculated field to show a secondary data source with a specific value

clawrence — Fri, 27 Sep 2019 15:18:04 GMT

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?