topic Re: Populate drop down list from AGOL layer with multiple fields in ArcGIS Survey123 Questions

Populate drop down list from AGOL layer with multiple fields

mikaël — Tue, 09 Apr 2024 19:04:31 GMT

I'm trying to populate a drop down list from a search() question.

This question returns all the streets (polylines) within a buffer distance of the location of the user and then they select the closest street to them. This works without a problem.

However I would also like to concatenate multiple fields in the drop down list (street name, type of street, number from and up to) to make sure there are no errors when filling the form.

Is this possible?

Current appearance: search(concat("queryStreetName?url=service_url/0&distance=", ${distancebuffer}, "&units=esriSRUnit_Meter&orderByFields=field ASC"), 'intersects', '@geopoint', ${location})

where ${location} is a geopoint question.

I thought I could do something with pulldata() but from what I understand you can get only 1 record with this function, where I need multiple records and multiple fields.

Thanks!

Re: Populate drop down list from AGOL layer with multiple fields

ZacharySutherby — Wed, 10 Apr 2024 22:23:12 GMT

Hello @mikaël,

You would need to add a new field in your feature service and field calculate the concatenated value. The search() appearance can only use one field as the label in the choices worksheet.

Re: Populate drop down list from AGOL layer with multiple fields

mikaël — Thu, 11 Apr 2024 13:11:45 GMT

Oh yeah that's not a bad idea! And then I can extract different string values from this concatenated field to populate/query other fields (IDs and such)!

Thanks!

Re: Populate drop down list from AGOL layer with multiple fields

RobertAnderson3 — Thu, 11 Apr 2024 13:27:52 GMT

Is there a possibility of adding the ability to concatenate labels from multiple fields in the future? We have a situation we want to have it query our UNITID field, but also add the UNITDESC to the label the users see, and we don't really want to add an extra field that just duplicates existing data.

Re: Populate drop down list from AGOL layer with multiple fields

ZacharySutherby — Thu, 11 Apr 2024 17:50:40 GMT

Hey @RobertAnderson3,

I've logged this feedback as something for us to investigate if it's possible to support in the future. Please feel free to reach out to Esri Technical Support to log an official Enhancement to track progress on the feature.

Re: Populate drop down list from AGOL layer with multiple fields

KushShah — Tue, 04 Nov 2025 04:59:58 GMT

Hi Mikael,

I would like to know how return all the streets within the buffer distance of location. In fact I am having an issue that when the user added a geopoint location, I want to return list of pipeline features that are within the certain buffer distance lets say within 1 mile. Could you please share the expression that you use for your work? Any tips or suggestion is greatly appreciated.

Thanks,

KShah