Re: Query list items from 1 SHP list and Submit to other

JenniferLindsay — Sat, 06 Sep 2014 01:06:34 GMT

Hi there, sorry for the delay in response.

In order to submit to your LIST2 from your InfoPath form, you will need to use CAML. Here is a link to a tutorial that explains how to use CAML: http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Add-SharePoint-List-Items-with-InfoPath.aspx

In order to generate the list of available training programs from LIST1, you will need to query LIST1. First create a data connection to LIST1, then on the Department Code field add an action rule that will query LIST1 for items matching the value of that field:

(1) Set a field: DepartmentCodeQueryFieldInLIST1 = DepartmentCodeFieldInMainDataSource

(2) Query LIST1

(3) Display whatever data fields you want from LIST1 on your form

Hope that helps!

Query list items from 1 SHP list and Submit to other

info12 — Tue, 19 Aug 2014 06:07:35 GMT

Hello everyone, request urgent support.

I am from the HR field and I want to use InfoPath with SharePoint for tracking execution of identified Trainings.

I have a SHP list that comprises of all the trainings from various departments (LIST 1). Some of the columns are Sr. No., Training Topic, Department Code.

I have another SHP list that will receive entries of identified trainings for various employees (LIST 2). Each line item will be spread across the following columns: Employee Name, Training Topic, Department Code. This list, will initiate a workflow that assigns task to each trainer and so on...this workflow thing is working.

What am I looking for?

When I enter Department Code of the employee on InfoPath Form, it should generate the list of available training programs from LIST1 matching that department code. This list should give me a check box to select which all training programs are applicable. Once selected, I want to submit applicable training programs of this employee in LIST2; such that each training program is a separate line item so that the tasks can be assigned to respective trainers.

Hope there is a solution available to this....looking forward for support from the experts.

Thanks

Newbie Questions

Re: Query list items from 1 SHP list and Submit to other

Query list items from 1 SHP list and Submit to other