Survey123-Dynamic dropdown list of 30.000 records

[GeorgeF]

Hi,

we currently host a table of 30.000+records in AGOL and we want to reference it in a survey123 as a dynamic dropdown using autocomplete.

However we are not able to load all the records. 

Would you be able to advise? I was looking at this saying this was fixed in 08/2023?

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-dynamic-lists-web/...

Thank you

[abureaux]

Records displayed are capped. I think default is around 2000 5000. That is normal behaviour.

Typing to search should still query the entire database. I have a similar set-up, but my database has around 500,000 items. You'll want to use a WHERE clause somewhere to narrow down your search. E.g.,

Where "wbs1" is a field in my database, and "gn_pn" is a field in my survey.