Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

PowerApp doesn't accept Location columns

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?



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


Can I have the link to that blog post?



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

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:



Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor



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?

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,516)