Initialing Form... Failed to load data from (data source)

Error Message

Using the pulldata() function to obtain data from a CSV file for a geopoint question loads successfully in ArcGIS Survey123 Connect. However, the following error is returned in the ArcGIS Survey123 web form:

Error:   
Initialing Form... Failed to load data from (data source)

Cause

The latitude and longitude columns in the CSV are not formatted correctly. The pulldata() function can only calculate the location data if the latitude and longitude data are in separate columns.

Solution or Workaround

To resolve this error when using existing data to create the survey, use the correct formatting method as described below.

Note:
Before creating a new survey, it is best practice to determine the correct formatting for the data.

1. Sign in to ArcGIS Survey123 Connect and create a new survey, or open an existing survey form.
2. In the survey form, create a calculate question for the latitude. Type lat in the name column and set the label. Use the following pulldata() function for the latitude in the calculation column:

pulldata('Intersections', 'Lat', 'IntersectionID', ${intersection})

3. Create another calculate question for the longitude. Type lon in the name column and set the label. Use the following pulldata() function for the latitude in the calculation column:

pulldata('Intersections', 'Long', 'IntersectionID', ${intersection})

4. Create a calculate question to concatenate the latitude and longitude. Assign a name and label in the name and label columns, respectively. Use the following pulldata() function:

concat(number(${lat}),' ', number(${lon}))

5. Create a geopoint question for the location and assign a name and label.
6. In the calculation column, use the pulldata() function with the name assigned for the concatenation of the calculate question in Step 4. Following this workflow, type location_calc in the pulldata() function.

${name assigned in the calculate question for concatenation}