SOLVED

how to use the fields associated with the address/location field

Copper Contributor
Sharepoint allows the use of address fields (or geolocation). This field provides assistance in searching for the address and returns the values of the components of the address.

I would like to be able to use it's subfields in my formulas and automation.
Unfortunately, I can't find these values.
They do not appear in dynamic content in power automate They do not appear in sharepoint for use in function.

Do you know how to retrieve these fields?

3 Replies

@EiC4733 Are you using this modern "Location" type column in list? 

ganeshsanap_0-1662121780942.png


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

@EiC4733 I just did a quick test and using 'When an item is created or modified' I was able to return the data in an email. 

 

  locationdetails.jpg

best response confirmed by EiC4733 (Copper Contributor)
Solution

@EiC4733 If you are using modern "Location" column as shown in my above response, you can get the fields associate with location field in power automate: 

ganeshsanap_0-1662122764923.png

Also, you can get the location values using REST API call using endpoint like: 

 

https://contoso.sharepoint.com/sites/wlive/_api/web/Lists/getbytitle('LocationList')/Items?$select=Title,MyLocation

 

Sample output

 

<m:properties>
    <d:Title>Location Item 2</d:Title>
    <d:MyLocation>{"EntityType":"LocalBusiness","LocationSource":"Bing","LocationUri":"https://www.bingapis.com/api/v6/localbusinesses/YN4070x13951153930869343075?setLang=en","UniqueId":"https://www.bingapis.com/api/v6/localbusinesses/YN4070x13951153930869343075?setLang=en","DisplayName":"Chhatrapati Shivaji International Airport","Address":{"Street":"Santacruz East","City":"Mumbai","State":"Maharashtra","CountryOrRegion":"IN","PostalCode":"400099"},"Coordinates":{"Latitude":18.96904754638672,"Longitude":72.82118225097656}}</d:MyLocation>
</m:properties>

 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

1 best response

Accepted Solutions
best response confirmed by EiC4733 (Copper Contributor)
Solution

@EiC4733 If you are using modern "Location" column as shown in my above response, you can get the fields associate with location field in power automate: 

ganeshsanap_0-1662122764923.png

Also, you can get the location values using REST API call using endpoint like: 

 

https://contoso.sharepoint.com/sites/wlive/_api/web/Lists/getbytitle('LocationList')/Items?$select=Title,MyLocation

 

Sample output

 

<m:properties>
    <d:Title>Location Item 2</d:Title>
    <d:MyLocation>{"EntityType":"LocalBusiness","LocationSource":"Bing","LocationUri":"https://www.bingapis.com/api/v6/localbusinesses/YN4070x13951153930869343075?setLang=en","UniqueId":"https://www.bingapis.com/api/v6/localbusinesses/YN4070x13951153930869343075?setLang=en","DisplayName":"Chhatrapati Shivaji International Airport","Address":{"Street":"Santacruz East","City":"Mumbai","State":"Maharashtra","CountryOrRegion":"IN","PostalCode":"400099"},"Coordinates":{"Latitude":18.96904754638672,"Longitude":72.82118225097656}}</d:MyLocation>
</m:properties>

 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

View solution in original post