Sep 02 2022 05:06 AM
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?
Sep 02 2022 05:30 AM
@EiC4733 Are you using this modern "Location" type column in list?
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.
Sep 02 2022 05:34 AM
@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.
Sep 02 2022 05:50 AM
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:
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.