none
Query Sharepoint list with infopath form RRS feed

  • Question

  • Hi

    How can I query SharePoint list using a number to auto fill the rest of the form?

    I have this field where users will type in their number and next to that is a search button to query the list and populate the rest of the fields in this form.

    I have created a data source pointing to this list. I created a rule saying if field 1 is not blank, query data source and set these other fields with information from the list.

    If I type the number and click search button nothing comes up.

    Please help

     


    nchiliza

    Saturday, August 15, 2020 11:48 AM

Answers

  • I FIXED IT!!!!

    I went back to check my rules and I realized that I made a mistake.

    My form is now querying and populating data nicely.

    The formula is value= secondary source output field + filter + secondary source input field = main source input field

    There you have it!!!!


    nchiliza

    • Marked as answer by Nozipho Saturday, August 15, 2020 5:33 PM
    Saturday, August 15, 2020 5:33 PM