Filter data from Secondary source - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Filter data from Secondary source

Last post 12-17-2020 08:05 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 12-16-2020 11:31 PM

    Filter data from Secondary source

    Dear All,

    I designed Leave Application form with Infopath 2013, data keep on SharePoint List

    I have 1 Repeating Section ( Leave Application Tracking), I will show all leave history that user submitted.

    My Question:
    How can I filter second data to show in Repeating Section?

    Ex: Employee 1- Submitted 2 Leave application
          Employee 2 - Submit 1 application

    When Employee 1 create another Leave Request, in this form, they will show 2 History Leave app that they submiited before.

    I attached my form in this post.

    Appreciate for your support.

  • 12-17-2020 08:05 AM In reply to

    Maybe try this one. I added a form load rule so that if the employee name is not blank, the query field in your secondary data source is set and the query is executed. I added the same rules on the employee name field. I changed the display area for the prior leave requests to a repeating table. I think the one thing that may need to be modified is if you open an existing leave request that data will also show in this table - you could add another query to the library that only returns data "for this item" and use the ID to filter that out, but hopefully this will get you at least part of the way to your goal.
    Hilary Stoupa

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