https://community.esri.com/t5/arcgis-survey123-questions/survey123-dynamic-dropdown-list-of-30-000-records/m-p/1382273#M54778 <P>Hi,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>However we are not able to load all the records.&nbsp;</P><P>Would you be able to advise? I was looking at this saying this was fixed in 08/2023?</P><P>&nbsp;</P><P><A href="https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-dynamic-lists-web/ba-p/1297811" target="_blank">https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-dynamic-lists-web/ba-p/1297811</A></P><P>&nbsp;</P><P>Thank you</P> Wed, 14 Feb 2024 16:20:21 GMT GeorgeF 2024-02-14T16:20:21Z https://community.esri.com/t5/arcgis-survey123-questions/survey123-dynamic-dropdown-list-of-30-000-records/m-p/1382273#M54778 <P>Hi,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>However we are not able to load all the records.&nbsp;</P><P>Would you be able to advise? I was looking at this saying this was fixed in 08/2023?</P><P>&nbsp;</P><P><A href="https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-dynamic-lists-web/ba-p/1297811" target="_blank">https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-dynamic-lists-web/ba-p/1297811</A></P><P>&nbsp;</P><P>Thank you</P> Wed, 14 Feb 2024 16:20:21 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-dynamic-dropdown-list-of-30-000-records/m-p/1382273#M54778 GeorgeF 2024-02-14T16:20:21Z https://community.esri.com/t5/arcgis-survey123-questions/survey123-dynamic-dropdown-list-of-30-000-records/m-p/1382399#M54784 <P>Records displayed are capped. I think default is around 2000 <STRIKE>5000</STRIKE>. That is normal behaviour.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="abureaux_0-1707936659414.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/94786i7D4C5DA60C6B42A4/image-size/medium?v=v2&amp;px=400" role="button" title="abureaux_0-1707936659414.png" alt="abureaux_0-1707936659414.png" /></span></P><P>&nbsp;</P><P>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.,</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="abureaux_1-1707936752458.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/94789i325C3B8C6D5C8C70/image-size/medium?v=v2&amp;px=400" role="button" title="abureaux_1-1707936752458.png" alt="abureaux_1-1707936752458.png" /></span></P><P>Where "wbs1" is a field in my database, and "gn_pn" is a field in my survey.</P> Wed, 14 Feb 2024 18:53:04 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-dynamic-dropdown-list-of-30-000-records/m-p/1382399#M54784 abureaux 2024-02-14T18:53:04Z