Use a Feature Layer as a Dynamic Choice List in Survey123 Connect in ArcGIS Online

Summary

In ArcGIS Survey123 Connect, you can use a Hosted Table or Hosted Feature Layer via its REST URL as a dynamic choice list for select_one list_name or select_multiple list_name questions by using the search() function.

Procedure

In this example, a Hosted Table is used.

1. Open the survey in ArcGIS Survey123 Connect and open the XLSForm.
2. In the survey worksheet, configure the question:
   1. In the type column, select select_one list_name or select_multiple list_name, and replace list name with the name of the choice list. In this example, the choice list name is table.
   2. In the name column, enter a question name (for example, Animal).
   3. In the label column, enter the text to appear in the form. For example, "Choices from the hosted table".

3. Go to the choices worksheet:
   1. In the list_name column, enter table (the same list name used in Step 2a).
   2. In the name and label columns, reference the field in your hosted table that contains the dynamic values. In this example, the field is Animal.

4. Return to the survey worksheet and configure the appearance:
   1. In the appearance column, enter a search() expression using this format: search ("unique_name?url=Hosted Feature Layer REST URL/<layer index>").
   2. In our example, the expression would be: minimal search ("Table_Animal?url=Hosted Feature Layer REST URL/0").

Note: 

4. • • The layer index is typically 0, which refers to the first layer or table in the Feature Service.
     • The <unique_name> can be anything, and it doesn't need to match the name of the hosted table, but this is how Survey123 internally refers to your search.
     • The search() appearance can be combined with other appearances, such as minimal or autocomplete. Using these appearances prevents the form from attempting to render all available choices at once, which helps avoid performance issues. 
5. Save the XLSForm file.
6. Publish the survey.
7. After publishing, Survey123 Connect populates the question's choices from records in the hosted table.