Calculated field to show a secondary data source with a specific value - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

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

Last post 09-27-2019 08:51 AM by clawrence. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 09-27-2019 08:18 AM

    • clawrence
    • Top 500 Contributor
    • Joined on 11-07-2008
    • Birmingham, AL
    • Posts 36

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

    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?
  • 09-27-2019 08:28 AM In reply to

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

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

  • 09-27-2019 08:37 AM In reply to

    • clawrence
    • Top 500 Contributor
    • Joined on 11-07-2008
    • Birmingham, AL
    • Posts 36

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

    Sure, there's a calculated field at the bottom of the Approvals view that I'm working with.
  • 09-27-2019 08:45 AM In reply to

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

     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. 

    Hilary Stoupa

  • 09-27-2019 08:51 AM In reply to

    • clawrence
    • Top 500 Contributor
    • Joined on 11-07-2008
    • Birmingham, AL
    • Posts 36

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

    Thank you so much, that worked! You never cease to amaze me!
Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.