https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-unique-distinct-values-from-dynamic/m-p/1287222#M49124 <P>I have a csv used to dynamically auto-populate the choice lists. The same csv is used for multiple lists and hence there are duplicate values. How can the list be limited to distinct/unique values? I tried combining both DISTINCT &amp; UNIQUE with the search() but neither worked so I either have the syntax incorrect or am using the wrong thing. The spreadsheet is attached. Is there a way to do this without breaking it into multiple csv files with unique values or creating lists in the choices tab?</P><P>Workflow:</P><OL><LI>Select System</LI><LI>Based on System, select Class: autocomplete search('groups','matches','ecgSystem',${system})</LI><LI>Based on Class, select Ecological Group: autocomplete search('groups','matches','ecgClass',${class})</LI><LI>Based on Ecological Group, select Community Type:&nbsp; autocomplete search('groups','matches','ecgName',${ecological_group})</LI></OL> Tue, 09 May 2023 13:24:51 GMT WhitneyWeber 2023-05-09T13:24:51Z https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-unique-distinct-values-from-dynamic/m-p/1287222#M49124 <P>I have a csv used to dynamically auto-populate the choice lists. The same csv is used for multiple lists and hence there are duplicate values. How can the list be limited to distinct/unique values? I tried combining both DISTINCT &amp; UNIQUE with the search() but neither worked so I either have the syntax incorrect or am using the wrong thing. The spreadsheet is attached. Is there a way to do this without breaking it into multiple csv files with unique values or creating lists in the choices tab?</P><P>Workflow:</P><OL><LI>Select System</LI><LI>Based on System, select Class: autocomplete search('groups','matches','ecgSystem',${system})</LI><LI>Based on Class, select Ecological Group: autocomplete search('groups','matches','ecgClass',${class})</LI><LI>Based on Ecological Group, select Community Type:&nbsp; autocomplete search('groups','matches','ecgName',${ecological_group})</LI></OL> Tue, 09 May 2023 13:24:51 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-unique-distinct-values-from-dynamic/m-p/1287222#M49124 WhitneyWeber 2023-05-09T13:24:51Z https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-unique-distinct-values-from-dynamic/m-p/1287278#M49130 <P>Not that I am aware of.</P> Tue, 09 May 2023 15:16:50 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-unique-distinct-values-from-dynamic/m-p/1287278#M49130 abureaux 2023-05-09T15:16:50Z