I have been working through the information located @ https://community.esri.com/t5/arcgis-survey123-blog/dynamic-choice-lists-using-search-appearance/bc-p/1143108#M4937 to develop a survey that is pulling information from a feature service for a choice list (select_one with autocomplete search appearance where you are searching a feature service url). But I'm running into an issue: the survey performs a single query and pre-populates the list. If your feature service doesn't return the value you're looking for in a single query then you are out of luck. You can always change the max record results returned, either in the service itself or apparently in the way you structure the appearance cell of the XLSX, but what if your feature service contains 500k records or more? This is not a good solution.
Seemingly, how it should work, is when you are typing into the select_one text box, it should perform a dynamic query (where=fieldname LIKE '%{inputtext}%') to retrieve a smaller list of results, similar to how the search widget in the JavaScript works. After the 3rd character, the search widget just starts querying the REST endpoint after each character, resulting in an ever-narrowing down list of results that match your text input.
Does anyone have any ideas on how to get this to work for much larger number of records?
