Can't figure out why the search or pull isn't working to bring in feature layer data for another survey choice column

Mobius_devil1

I have a very simple survey that needs to pull another survey's data as a choice picklist for users to select from. I can't get the feature layer data to pass through and show up on the new survey as a choice picklist. Any suggestions would be appreciated.

in my appearance column, I have this 

pulldata("@layer", "https://services6.arcgis.com/N6rP5o1W5BrPYgsm/arcgis/rest/services/survey123_9e24d36efd414b7f8c55c10573042563/FeatureServer/0", "Event")

 

and this 

autocomplete search('Signup?url=https://services6.arcgis.com/N6rP5o1W5BrPYgsm/arcgis/rest/services/survey123_9e24d36efd414b7f8c55c10573042563/FeatureServer/0', 'Event')

 

And I do not have any data showing up, even though there are only 6 total data points from the feature layer.

Neal_t_k

To start with,  the pulldata(@layer) should go in as a calculation, and it is not properly formatted

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_BB97985CAFB740EE8AEF99EFD6E238E3

you need to tell it what kind of query eg. "getRecord" and a where clause eg. "Event = ${Event}"

 

Same with the search appearance,  you need to properly format the criteria

something like

autocomplete search('Signup?url=https://services6.arcgis.com/N6rP5o1W5BrPYgsm/arcgis/rest/services/survey123_9e24d36efd414b7f8c55c10...','matches', 'Event', ${Event})

https://community.esri.com/t5/arcgis-survey123-blog/dynamic-choice-lists-using-search-appearance/ba-p/1060838

Fix those up, and if your queries still doesn't work post back, syntax can be tricky.