Forum Discussion

EiC4733's avatar
EiC4733
Brass Contributor
Sep 02, 2022
Solved

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

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...
apis
developer
  • ganeshsanap's avatar
    ganeshsanap
    Sep 02, 2022

    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: 

    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.

ganeshsanap's avatar
ganeshsanap
MVP
Sep 02, 2022

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: 

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.

Resources