topic Re: search() and pulldata() from feature service returning empty list and attributes in ArcGIS Survey123 Questions

search() and pulldata() from feature service returning empty list and attributes

MollyMoore — Tue, 10 Sep 2024 17:17:50 GMT

I am setting up a survey to use the search() function to query a feature service layer to auto-populate values in a drop down for users to select. I then want other fields to auto-fill attributes in the Survey123 from the feature service layer with the pulldata() calculation. When I set up these functions, the list is empty and the pulldata() function (when tried separately) is also empty. The feature layer is in a referenced feature service hosted on our enterprise portal and the Survey123 form is being built in the same same portal. What am I doing wrong?

My search() expression in the appearance option:

w2 autocomplete search("site_name_picker?url= https://<enterprise_url>/server/rest/services/PNHP/NHA_EDIT/FeatureServer/0")

My pulldata() expression in the calculate option:

pulldata("@layer", "getValue", "attributes.nha_join_id", "https://<enterprise_url>/server/rest/services/PNHP/NHA_EDIT/FeatureServer/0",concat("site_name='", ${site_name}, "'"))

I've attached photos that show the .xlsx file and the blank drop down list.

Re: search() and pulldata() from feature service returning empty list and attributes

Jim-Moore — Wed, 11 Sep 2024 04:53:19 GMT

Hi @MollyMoore

The syntax in your expressions looks good. A couple of things to check:

Is "site_name" the exact name of the field in the feature layer with which you want to populate the choice list?
Does the signed in user have access to the feature layer?

Best, Jim

Re: search() and pulldata() from feature service returning empty list and attributes

JenniferAcunto — Wed, 11 Sep 2024 12:38:39 GMT

Pulldata does not like being included with other functions (concat, if, etc). You might want to try breaking up your pulldata into separate calculations:

1st question builds the where clause.

concat("site_name= '", ${site_name}, "'")

2nd question is the pulldata calculation.

pulldata("@layer", "getRecord", "https://<enterprise_url>/server/rest/services/PNHP/NHA_EDIT/FeatureServer/0", ${where1}).

Along with what Jim mentioned, I would also check to ensure that query is enabled on the layer you are using with the search appearance.

Re: search() and pulldata() from feature service returning empty list and attributes

Chris3030 — Fri, 13 Sep 2024 17:39:43 GMT

Hi @MollyMoore , does this happen in the desktop app or the web form version of the survey? I'm experiencing a similar problem right now

Re: search() and pulldata() from feature service returning empty list and attributes

MollyMoore — Fri, 13 Sep 2024 18:30:29 GMT

Mysteriously, everything started working after rebooting two days later without changes. I updated to separate the concat() function from the pulldata() function anyway, as you suggested @JenniferAcunto, and everything seems to be functioning well. Thank you for the tip and hopefully it will make things more stable.

Re: search() and pulldata() from feature service returning empty list and attributes

MollyMoore — Fri, 13 Sep 2024 18:32:36 GMT

Hi @Chris3030, I am using the desktop app and creating in Survey123 Connect. After two days, my functions mysteriously started working without changes. I did update my .xlsx to separate the functions as @JenniferAcunto suggested and things seem to be working well now.

Re: search() and pulldata() from feature service returning empty list and attributes

TKSHEP — Tue, 17 Mar 2026 15:38:36 GMT

How would I use the pulldata calculation to search a feature layer for the same field name and update a different column in the feature layer when survey is submitted?

Example:

both features are in the same map and have the same column name site. When survey is submitted update site locations feature column inspection completed to yes with the matching site from the survey that was submitted.

Thank you for your help!