Repeating section with secondary list lookup - InfoPath Dev
in

InfoPath Dev

Repeating section with secondary list lookup

Last post 10-17-2018 10:44 AM by bsod77. 8 replies.
Page 1 of 1 (9 items)
Sort Posts: Previous Next
  • 10-17-2018 08:15 AM

    Repeating section with secondary list lookup

    I've seen several posts on here, but nothing really describing HOW to complete this. Drag your secondary into the table doesn't make any sense, so boiling it down with a simple case, hoping for a simple solution: So very simply, let's say I have two controls. A drop down to pick the name of the fruit, which is populated by a list lookup. Then there is a text box for the color which is to be populated once the drop down list selection has been made. One again, referencing the same list. If I make these outside a repeating section, it works beautifully. Once it is in a repeating section, it doesn't do anything. I have tried applying the rule to the repeating section, and also the drop down control, and neither work. Thoughts?
  • 10-17-2018 08:42 AM In reply to

    Re: Repeating section with secondary list lookup

    See attached sample - save the file locally, right click and select design, then preview. The formula to set the field's value uses the current() function, which may be what is missing in your attempt.
    Hilary Stoupa

  • 10-17-2018 08:56 AM In reply to

    Re: Repeating section with secondary list lookup

    Thank you for the quick response. That example uses an xml instead of a SharePoint list. Please see attached.
  • 10-17-2018 09:07 AM In reply to

    Re: Repeating section with secondary list lookup

    Sure - I used XML because I want you to be able to preview. Can you attach your actual template instead of a screenshot? If so, I'd be happy to take a look.
    Hilary Stoupa

  • 10-17-2018 09:20 AM In reply to

    Re: Repeating section with secondary list lookup

    Attached. I have tried using ID as the qualifier as well as the unit name. Both return blank.
  • 10-17-2018 09:27 AM In reply to

    Re: Repeating section with secondary list lookup

    The value of your dropdown is the Title field in your list. Then for your XPath filter, you are comparing on ID. Try this one.
    Hilary Stoupa

  • 10-17-2018 09:46 AM In reply to

    Re: Repeating section with secondary list lookup

    That works perfectly, thank you. Why does it require different filters and looksups on a repeating section than it does just as a line item?
  • 10-17-2018 09:59 AM In reply to

    Re: Repeating section with secondary list lookup

    In our XPath filter in the repeating table, we have to use current() to indicate the comparison - if your rule were on the section itself, you might use current()/my:FieldName or some other path, but you need to indicate the comparison occurs with the node the rule is on when dealing with repeating data. The filter depends on the value setting in your dropdown. For example, if your dropdown displayed the title, but stored the ID, your original XPath filter would have worked correctly.
    Hilary Stoupa

  • 10-17-2018 10:44 AM In reply to

    Re: Repeating section with secondary list lookup

    Thank you!
Page 1 of 1 (9 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.