The Esri Maps Locate workflow can spatially enable SharePoint list items that contain the following location types:
Latitude and longitude—Latitude and longitude values represent the position of a point on the earth's surface in an X, Y format. For SharePoint lists with coordinate data, run the Esri Maps Locate workflow only if the list will be used in the Silverlight-based ArcGIS Map Web Part.
Address—In the United States, address data is comprised of street name, city, state, ZIP Code, and country. There are similar address elements in other countries. The more address elements your data contains, the more accurate your results will be. You can find a complete list of countries for which there is address coverage in the supported countries link on the World Geocoding Service overview page.
US city, State, ZIP code, World city, and Country—Cities (US city and World city) are added to the map as points. States, ZIP codes, and Countries are added to the map as polygons, which represent both the shape and the location of the place. When entering World countries, you can use the Geonames country codes as a reference for accepted spelling variations.
Custom location types—This feature allows you to use a hosted service from ArcGIS Online to specify a location type. For example, if your organization has its own boundaries (water districts, sales districts, zoning boundaries) shared on ArcGIS Online, you can map your spreadsheet data using those locations instead of the default location types.
The Esri Maps Locate workflow requires a connection to the ArcGIS platform, through ArcGIS Online or Portal for ArcGIS, to access the ArcGISWorld geocoding service for geocoding addresses. By default, the Esri Maps Locate workflow connects to http://www.arcgis.com, but you can change this connection string to point to a Portal for ArcGIS instance by editing the ArcGISConnection item in the Esri Maps Configuration Settings list. If you're connecting to a Portal for ArcGIS instance, the default locator of your portal instance is available when running the Esri Maps Locate workflow.
When the Esri Maps Locate workflow executes on a list, it adds three new columns to the list: Esri Maps Location, ShapeX, and ShapeY. The ShapeX and ShapeY fields store the geographic coordinate data for the list item. The Esri Maps Location field stores the geometry for the list item in JSON format, which can be a point, line, or polygon, and embeds an interactive map in each item's form, which allows you to view and manipulate an item's location. See Fix a location for more information. These columns can be removed, if needed, using the List Settings page for the list.