Dynamic list from feature service works in web form but not Survey123 Desktop

[HanliePetoors]

Hi,

I'm working in ArcGIS Online

I have a survey that pulls values from an AGOL hosted feature service to a select_one question.

In the web form it pulls in the values and they can be selected:

But in Survey123 Connect and Survey123 for Desktop the values are not retrieved:

Any ideas why this might be?

Thanks

Hanlie

[abureaux]

External Selects need to be downloaded separately from the survey.

Exit the survey and return to the main S123 screen. Then, click on the survey and it should download the external select. You should see the list now.

[abureaux]

Actually, you know what... I send this News Post out at least weekly to internal staff. I may as well copy it here to continue the trend (lol).

(larger version attached)

[HanliePetoors]

@abureaux thanks for the reply.

Unfortunately your suggestion did not change the behaviour of the form.

I created a new survey using a different feature service as source for the list and that worked. So it looks like the service may be suspect. But that doesn't explain why it works in the web form but not in Survey123.

Also doesn't work in the mobile app.

Regards

Hanlie

[abureaux]

Oh, search() appearance. Ya, that changes things 😂

Looks like your Desktop apps are up to date. And you mentioned that this was a "Hosted" layer. Both of those are good things.

Have you tried using other layers, and is the behaviour replicated on them? And have you tried changing security settings for the FL used? Almost seems like a security issue. But then you'd expect Connect to work at least.

EDIT: Defiantly seems like a layer issue. I swapped your FL with a public one, and updated the name choice/label to match new FL. No issues.

I can only assume your name/label combo is correct since the list does show up in the web app. If either the name or label, or both, were wrong, you would see a very specific behaviour (either a blank list, or a list of all "undefined" or "label"). That really just least the FL.

[HanliePetoors]

I have not been able to replicate this with another service - it worked fine with the other service I used.
It does seem to have something to do with the service but I don't know what. The two services have identical settings.
It's also very strange that the list works in the web form but not in the Desktop or Mobile apps.
I'll post here if I find a solution.
Regards
Hanlie

[PietaSwanepoel_esriza]

@abureaux, your solution seem to use csv files as source for select_one questions. Helpful. Thank you.

But this question is related to autocomplete search that uses a feature service as source as opposed to a csv.

[ChristopherCounsell]

Version of Survey123 Connect? Field app? Are you logged in with an account that has access to the feature service? Can you share the XLSForm?

Could just be as simple as updating connect, republishing the survey, updating the field app, downloading the latest survey.

Could also be other elements at play. Couldn't see any known limitations or issues around this.

[HanliePetoors]

Hi Christopher,

Thanks for the reply.

Survey123Connect V3.21.62

Survey123 V3.21.62

I am the owner of the feature service.

I have attached a version of the survey that I created in the web designer to see how it works there and I have the same issue - works in the web form but not in Connect or the Desktop app.

Thanks

[ChristopherCounsell]

Can you use a random string like "carrots" as the unique table name in the search() call?

or an ArcGIS layer (use the format‘<unique_name>?url=<Layer REST URL>’,including the layer index). The<unique_name>can be anything, it doesn't need to match the name of the hosted layer, but as this is how Survey123 internally refers to your search, must be different from all other table names and CSVs used in the survey:

e.g. autocomplete search("carrots?url=https://services.arcgis.com/k7HsiFEIdlPzZNnP/arcgis/rest/services/Water_Licence_eWULAAS/FeatureServe...")

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformsappearance.htm#ESRI_SECTION1_46A7...

 This table name doesn't need to match the name of the hosted layer, but because this is how Survey123 internally refers to your search, it must be different from all other table names and CSV files used in the survey.

I wonder if it's because you've got some csv table in the media folder or even just the list name is the same?