The Editor pane shows the domain values instead of the labels in ArcGIS Survey123

Description

After republishing a survey, the attributes of some features of existing submissions display the value of the domain in the Editor pane of the ArcGIS Survey123 website instead of the label.

Cause

• The name of a choice is removed from the ArcGIS Survey123 Connect XLS form. Updating the form will not display any prompt from ArcGIS Survey123 Connect, but existing submissions with the removed choice will cause the issue to occur.
• The choice is removed and re-added under a new name. This creates two domains with the same label and is not supported in ArcGIS Online.

Solution or Workaround

Note:
In ArcGIS Online, delete the unnecessary value from the list of values before performing any of the workflows. Refer to ArcGIS Online: Edit a list of values for further instructions.

Edit the attribute table of the hosted feature layer manually in ArcGIS Online

Note:
This workflow is not practical for a survey with many submissions.

1. Log in to ArcGIS Online.
2. Click Content > My Content.
3. Navigate to and click the hosted feature layer of the form.
4. On the item details page, click Data.
5. On the Data tab, click Table.
6. Double-click the cell with the incorrect value and select the updated value.

Use the Calculate Field tool in ArcGIS Pro

1. Open ArcGIS Pro.
2. Add the layer to the map. Refer to ArcGIS Pro: Add data from the Catalog pane for further instructions.
3. In the Contents pane, right-click the layer and click Attribute table.
4. Use the Select By Attributes tool to select the features with the incorrect value.
   1. In the attribute table, click Select By Attributes.
   2. In the Select By Attributes dialog box, in the Expression box, click the Select a field drop-down menu and select the field with the incorrect value.
   3. Select is equal from the drop-down list.
   4. Click the values drop-down list and select the incorrect value.
   5. Click Apply, and click OK.

5. Use the Calculate Field tool to replace incorrect values with the updated values.
   1. In the Calculate Field dialog box, click the Expression Type drop-down menu and select SQL.
   2. In the query builder, type in the updated value and enclose it with single quotation marks.
   3. Click Apply, and click OK.

6. Overwrite the web layer in ArcGIS Online. Refer to ArcGIS Pro: Overwrite a web feature layer for further instructions.

Use an Arcade expression in ArcGIS Online

1. Log in to ArcGIS Online.
2. Click Content > My Content.
3. Navigate to and click the hosted feature layer of the survey form.
4. Calculate the field using an Arcade expression. Refer to ArcGIS Online: Calculate field values for further instructions.
5. In the Expression box, modify the following expression with the relevant fields and values to replace the old submissions with the updated choices. Include an Else statement to ensure the values for the new submissions remain intact. Otherwise, they will be calculated as Null.

if ($feature.<field>=='<old value>') {
   ;return "<new value>";
} else {
  return $feature.<field>;
}

6. Click Test to verify the expression.
7. Click OK.

The image below shows the Editor pane displaying the correct label in the ArcGIS Survey123 web app.