I really hope you can help out! I'm so close to completing my project! I've learned so much just by trial and error, but I'm at a road block.

I've established a main data connection to connect my form to a SP List that displays employee ID, Title, Last Name, Department, and Workcenter.

I created a drop down and connected it to the workcenter data field.

At this point I would like to have all entries that are in that specific workcenter display. How do I do that?

Bonus question: The entire point of this is to create a daily attendance report of all employees. Not a timecard, just a "Who is physically here and who is not." So, how would you go about creating fields that can mark someone as present or absent and then submit that list back to a SharePoint list?

1 Answer 1


Create a secondary data connection to your list...while creating data connection select get data from SharePoint list, then select all your required columns whichever you want to display in the form. Once data connection creation is done, go to the secondary data connection, and drag and drop the items nodes to form.

We can filter the list items data by applying the filter on the secondary data connection.

See my other answer here on how to filter the SharePoint list items and display them in the form.

How to save the data in SharePoint list?

If you are customizing the SharePoint list using InfoPath form... we don't need to create a secondary data connection to submit the form data back to SharePoint list, the inbuilt main data connection will take care... however, if you want to submit the data to a different list, you need to create another secondary data connection with Submit data (while creating the data connection you will get this option), then on the submit button rule as action select this data connection to submit the data.

How to create a secondary data connection to submit the data in the SharePoint list?

  • Click on the Manage Data Connection from the right side Fields panel.
  • Click on the “Add” button in the “Data Connections” wizard. In the next screen, you will get the below:

Create a new connection to:

  • Submit data – This is used to submit the InfoPath form data to the SharePoint list.

  • Receive data – This is used to read the data from a SharePoint list (by default, this will be selected).

  • Select the "Submit data" radio button

  • In the next screen, you will see “Select the source of your data”, select as SharePoint library or list.

  • Enter your SharePoint site URL in the “Enter the location of the SharePoint site” box.

  • From the available lists or libraries, select your list.

  • Click on the Next button and continue...

For details refer to the below article:

How to auto populate field in InfoPath based on another field

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.