Re: Filter data from Secondary source

Hilary Stoupa — Thu, 17 Dec 2020 16:05:15 GMT

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.

Filter data from Secondary source

hainh1984 — Thu, 17 Dec 2020 07:31:25 GMT

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.

General

Re: Filter data from Secondary source

Filter data from Secondary source