cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Benjimang
Helper I
Helper I

Update SharePoint Location Column with Bing Connector

Hi Everyone,

 

Is there any way to update a SharePoint list 'Location' column with flow? I have a heap of sites with addresses in secondary address columns (Street, City, State, Country, Post Code, Lon, Lat). I would love to transfer it all into an actual Location column. I was thinking I could get the Point Coordinates using the Bing Maps connector, but it seems Flow cannot update a Location column.

 

I would love to do something like the following:

- Button trigger

- Get Items (all in the list)

- Update Items (the same list)

 

I have seen someone use the Send HTML command action, but I don't understand it at all. I also think you need to have a bing location code already, which I don't (but I do have good quality location info).

 

Any ideas?

3 REPLIES 3
v-alzhan-msft
Community Support
Community Support

Hi @Benjimang ,

 

Could you please explain more details about the Location Column?

Does the Location Column is created manually?

 

If the Location Column is created manually, I have made a test on my side to create a Location Colum with single line of text type, and you could refer to screenshot below to create the flow:

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-alzhan-msft ,

 

No, the 'location' column is actually named "Address" and is of the 'location' column type. This keeps track of all of our clients. It produces:

 

- Address (Bing address code)

- Address: Name

- Address: Street

- Address: City

- Address: State

- Address: Country/Region

- Address: Point Coordinates

 

I have then decided to add 800 venues to the list as targets for our sales team. I have manually created a complete set of text columns (below) and imported some address info into (from an excel sheet) in the same list:

 

- Address (target): Name

- Address (target): Street

- Address (target): City

- Address (target): State

- Address (target): Country/Region

- Address (target): Point Coordinates

 

What I would love to do, is somehow update the actual 'location' column so that I get proper Bing addresses and coordinates. Is this in any way possible?

Hi @v-alzhan-msft ,

 

Just as an update, I've experimented with the output of the Bing connector and I don't believe it's compatible with any technique I have discovered for SharePoint Location columns. Here is one method that uses the 'Send HTTP Request to SharePoint' action:

 

https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/How-to-update-a-SharePoint-location-fie...

 

Unfortunately, you need to already know the SharePoint location column JSON for the location. Using the Bing connector doesn't give you that. At present, we have a way to use Bing to turn manual address info into high quality location information, but no way to turn that into an entry in a SharePoint Location Column. 

 

Unless anyone else knows a way?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,684)