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).
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:
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:
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?