PowerApp doesn't accept Location columns

[PurpleHaze]

I just tried to make a PowerApp connected to a Sharepoint list I made.

Two of the lists columns are Location type ones meant to designate a location I am travelling from and my planned destination so it would calculate the mileage between them.

Unfortunately, I was unable to make the app and got this error message.

{ 

  "status": 400, 

  "message": "The required field \"Destination\" data type is not supported\r\nclientRequestId: db4ffc65-49cb-42bd-9eeb-6704c6bf90a3\r\nserviceRequestId: db4ffc65-49cb-42bd-9eeb-6704c6bf90a3" 

} 

Any help please?

Thanks.

[jlindstrom]

@RezaDorrani wrote a blog post about this about 18 months ago. is there any new capability to work with these columns Reza?

[PurpleHaze]

Really?

Can I have the link to that blog post?

Thanks.

[jlindstrom]

sorry, thought I posted it https://rezadorrani.com/index.php/2018/12/04/location-columns-for-sharepoint-online-lists-libraries/

[RezaDorrani]

Hello, No progress made on location type columns. Same behavior to date. Regards, Reza

[v-yutliu-msft]

Hi @PurpleHaze ,

Do you want to calculate the distance between two location columns?

I've made a similar test and found that: it's only supported to calculate the distance between two location columns' cities.

The point is:

Location column display as these columns in  powerapps:

'location1: City'

'location1: Country/Region'

'location1: Name'

'location1: Postal Code'

location1: State'

'location1: Street'

The most detailed columns are 'location1: City'  and 'location1: Street'.

I try to use 'location1: Street' to calculate distance, but received error.

Using  'location1: City' will work.

Firstly, you need to connect with bing maps.

Then use this formula to calculate:

BingMaps.GetRoute(ThisItem.'location1: City',ThisItem.'location2: City').travelDistance

Then you will get the distance between cities in location1 column and location2 column.

Maybe you want to know more about this function:

https://docs.microsoft.com/en-us/connectors/bingmaps/#get-route

Best regards,

[PurpleHaze]

Hello.

After just reading your replies,

I took a stab at it again.

I remade the location columns and added the following secondary columns for each:

Street, City, State, Postcode and Name.

I tried to make the PowerApp again, directly from the Sharepoint list but came across the exact same error as before.

It does not support the overall location columns, even if I only show the subcolumns.

{
  "status": 400,
  "message": "The required field \"Travelling From\" data type is not supported\r\nclientRequestId: f0fc84df-d0d9-4f95-b3c3-7b5f17c0c8dc\r\nserviceRequestId: f0fc84df-d0d9-4f95-b3c3-7b5f17c0c8dc"
}

Did I miss anything?