I am working on an infopath form for a sharepoint list where there are defect details to be added to the list. There is a field to input defect id if it is an existing defect. So I want that when a user enters the defect id and presses enter, it should search the list and autopopulate rest of the fields with that defect details.

Can anyone please advice me how do I do this. Any assistance would be really appreciated. Thank you!

1 Answer 1


Create a secondary data connection to your defects list and while creating the data connection select Get data from SharePoint list. Then select your all your relevant column like Defect ID, Defect Details, and so on. Now the secondary data connection is ready.

Create two textbox columns, one to pass the input another one to display the result based on the input pass in the first text box (Defect ID).

Step 1:

Select the defect details text box in the form.


Click on the Default value Fx button.


Click on the insert field or Group


Select your secondary data connection from the data connection list.


Select the Defect Details from the Data Fields section


Click on the filter button


In the filter add selectDefectID (from list secondary data connection) -eq "DefectID(from the form textbox - where you will enter that textbox). Click 5 times OK, one after another.

Finally, filter should look like below:

Defect_x0020_Details[DefectID = SearchDefectByID]

Display InfoPath filed based on the other field


Based on dropdown selection set textbox value in Infopath form2

  • This is amazing.. Thank you very much, Habibur. Appreciate all your help! :)
    – HRY
    Apr 23, 2020 at 14:40
  • Hello, This works on all the controls like text field or drop down list but somehow doesn't work on people picker. Is there any way to populate people picker field as well?
    – HRY
    Jun 21, 2020 at 12:41

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.