InfoPath Dev

Hi All, I have a sharepoint list with around 2000 records( lets say list A), I have to check whether the data entered in the new item for LIST A already exists in the same list (List A). the normal data connection to the list takes a lot of time to load. So I wrote a simple REST call just to get the specific item. https://(Site name here )/_api/web/lists/GetByTitle('LISTA')/Items?$select=ID&$filter=hidden_bAi eq '02-12' This query works in the browser, even in the infopath form I am modifying this rest call to update the query and the querying it . I am also printing it in a variable tp check if the REST call is correct and it is, it works in browser. But when I publish the fomr, it doesnt work. An error occurred querying a data source. Can someone please help me. Thanks.

Is this SharePoint online or on-prem? If online, the REST query will probably not work. If on-prem, you should have your SharePoint admin take a look at the logs to determine the issue. However, since this is a simple equivalence query you would not need to use REST at all. Add a list data connection to your list, but on the final dialog, deselect the checkbox to query for data on form open. Then, in your form, at the same point you were executing your REST query, set the list query field to the value you need, and then run the list query. The list query will only return data that matches on the query field.

Hi Hilary, thanks for your response. But setting the query field doesn't work. I even tried a simple field like ID, but even that did not work. Step 1) set the field -? field ID = 114 ( query field of the secondary source) Step2) Query data connection step 3) set a field with the data field of that connection. The field is empty. Please help and let me know if I am doing something wrong.

It is hard to guess without looking at your form, but usually what I do is drag the whole list data connection onto the form (query and data fields) and add a button that just runs the query. Then I can test the form in preview or in the browser. Set a query field, run the query, verify that there are data rows returned. From there, you may be able to figure out why your field is blank.

Hi Hilary, Thanks for your response. I tried it this way and it worked. Thanks Snehal