Home

Add Location Details to SharePoint Data and Content

James Jackson
Microsoft

Add Location Details to SharePoint Data and Content

We are excited to announce a new capability for SharePoint lists and libraries. The new location column allows you to add rich location data from Bing Maps or your organization directory to any SharePoint list or library. You can then filter, sort, and search by any aspect of the location data such as address, city, or state.

 

Creating a Location Column

To add a location column, simply click Add Column then select Location

Screenshot of the add column dropdown menu with the location option highlighted

 

You can then name the column and add secondary columns to display, sort, and filter by attributes such as city, state, or country.

The Create Column pane for Location Column, showing the required name field and checkboxes for adding subcolumns such as Street Address, city, and State

 

Now when creating or editing list items, you can search for location data from Bing Maps or your organization directory to associate it with your list item.

The add item pane highlighting the location field combobox. As the user types into the combobox, potential location matches appear below and can be selected

 

Once you have added location data for your list items, you can sort and filter your list based on any of the additional columns added during the column creation process. If you want to filter by an attribute you did not include during column creation, it can be added in the Edit Column pane.

A SharePoint list of locations in Seattle sorted by street address

 

Adding a new column type to SharePoint is a rare event. We can’t wait to see what uses you come up with for this new column!

 

We anticipate roll out for targeted release will begin by the end of November, with full worldwide release by mid-December.

21 Replies

Re: Add Location Details to SharePoint Data and Content

How will this look from a REST perspective?

e.g. what will the data look like if pulled into power BI? lat and long?

Re: Add Location Details to SharePoint Data and Content


@James Jackson wrote:

The new location column allows you to add rich location data from Bing Maps or your organization directory to any SharePoint list or library.

 


Does this include 'Rooms & Equipment'?  And can this column be added to the SharePoint Calendars or is it only available in 'modern' lists?

Cool feature!

Re: Add Location Details to SharePoint Data and Content

This is a great new column. will there be a bing maps plot available to show where all the location are? 

Re: Add Location Details to SharePoint Data and Content

I would like to know this too!

Re: Add Location Details to SharePoint Data and Content

We are pleased with this addition and hope to see this feature option soon.  Will we be able to convert columns with address info (currently using multiple lines of text) into a location column?

Re: Add Location Details to SharePoint Data and Content

Will there be a possiblity to use OSM (OpenStreetMaps) instead Bing Maps?

Re: Add Location Details to SharePoint Data and Content

Could You please give any visual exaple of using coordinates property.

Re: Add Location Details to SharePoint Data and Content

Is it available for classic SharePoint versions, like SP 2013 too?

Re: Add Location Details to SharePoint Data and Content

Hi Jackson

Still can't see that option in our Office356 environement... do we need to do something to activate?

Re: Add Location Details to SharePoint Data and Content

Just use the _api/web/lists/getbytitle('yourlist')/items URL to see the RAW data behind this field. For i.e. a field in which I entered the Microsoft HQ in Redmond, WA, it stores internally:

 

<d:Location>{"EntityType":"LocalBusiness","LocationSource":"Bing","LocationUri":"https://www.bingapis.com/api/v6/localbusinesses/YN873x16209519703153017334","UniqueId":"https://www.bingapis.com/api/v6/localbusinesses/YN873x16209519703153017334","DisplayName":"Microsoft Corporation","Address":{"Street":"1 Microsoft Way","City":"Redmond","State":"WA","CountryOrRegion":"US","PostalCode":"98052"},"Coordinates":{"Latitude":47.6398811340332,"Longitude":-122.12833404541016}}</d:Location>

 

Re: Add Location Details to SharePoint Data and Content


@Ariel Kropp wrote:

How will this look from a REST perspective?

e.g. what will the data look like if pulled into power BI? lat and long?

The main Location column stores all the location data as a JSON blob. APIs can be called to either return the full blob, or can call for specific information like geocoordinates, street address, place name, etc. by calling the related columns.

 

Calling individual sub columns will probably be the easiest method in most cases

Re: Add Location Details to SharePoint Data and Content


@Scott Smith wrote:

@James Jackson wrote:

The new location column allows you to add rich location data from Bing Maps or your organization directory to any SharePoint list or library.

 


Does this include 'Rooms & Equipment'?  And can this column be added to the SharePoint Calendars or is it only available in 'modern' lists?

Cool feature!


Thanks for your enthusiasm.

 

The column does support looking up specific rooms through Room & Equipment Mailboxes, but is only available in Modern Lists, so cannot be added to a calendar.

Re: Add Location Details to SharePoint Data and Content


@Carlos Cordeiro wrote:

This is a great new column. will there be a bing maps plot available to show where all the location are? 

That's a very interesting suggestion. I think this would require work on the Bing maps side and we could look into partnering with them on it.

Re: Add Location Details to SharePoint Data and Content


@Patrick Fulton wrote:

We are pleased with this addition and hope to see this feature option soon.  Will we be able to convert columns with address info (currently using multiple lines of text) into a location column?

We don't currently have a way to do this, but can look into it if there is substantial interest

Re: Add Location Details to SharePoint Data and Content


@Afghan Salon wrote:

Will there be a possiblity to use OSM (OpenStreetMaps) instead Bing Maps?


Currently Bing Maps and your Organizations directory are the only data sources available. This is so that we can guarantee that all the data processed stays within your organization

Re: Add Location Details to SharePoint Data and Content


@Afghan Salon wrote:

Could You please give any visual exaple of using coordinates property.


Here is a list with Geo Coordinates:

Capture.PNG

Re: Add Location Details to SharePoint Data and Content


@Kaiyan Liu wrote:

Is it available for classic SharePoint versions, like SP 2013 too?


This is only available in Modern SharePoint

Re: Add Location Details to SharePoint Data and Content


@Adi Mader wrote:

Hi Jackson

Still can't see that option in our Office356 environement... do we need to do something to activate?

Role out has been a bit delayed. We are currently at 100% First Release Users and will be at 100% of First Release tenants tomorrow

Re: Add Location Details to SharePoint Data and Content

I came back at the right time! Just tried it and it works great. I had a test list waiting to add this piece. Love it!

LocationSP.JPG

Re: Add Location Details to SharePoint Data and Content

Well, we are very interested.  We have several contact lists that have separate fields for street address, city, state and zip and it would be great to be able to simply convert those to location columns based on the existing data.

Re: Add Location Details to SharePoint Data and Content

Thanks for the enthusiasm!

 


@Becky Benishek wrote:

I came back at the right time! Just tried it and it works great. I had a test list waiting to add this piece. Love it!

LocationSP.JPG


 

Related Conversations