cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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.

Highlighted

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?

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (4,087)