cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Sum a collection of Latitude and Longitude Values

I'm building a feature in an app that overcomes the variance of GPS readings in an area around airport interference. I've put a timer on a loop using an if statement and every time the timer ends I gather the latitude and longitude into a collection. At the end of the loop I'd like to Sum and then Average the lists of Latitude and Longitude readings I'm gathering. 

 

I tried Average(Sum(XCoordinates.Latitude)) but it doesn't like it. Thinking the Location.Latitude call is giving me text I also tried Average(Sum(Value(XCoordinates.Latitude))) and it also doesn't like it. 

 

After I've got these averages I'm going to render the results to Google Maps. Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Sum a collection of Latitude and Longitude Values

@RobDin 

Yes, this is possible.

 

First, I would suggest storing the gps coordinates as numbers in your collection.  Some code like this could be placed in the OnTimerEnd property of your timer.

Collect(myCoord, {Latitude: Value(Location.Latitude), Longitude: Value(Location.Latitude)})

 

Then you can find the average latitude & longitude like this.

Average(myCoord, Latitude)
Average(myCoord, Longitude)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

1 REPLY 1
Highlighted
Super User
Super User

Re: Sum a collection of Latitude and Longitude Values

@RobDin 

Yes, this is possible.

 

First, I would suggest storing the gps coordinates as numbers in your collection.  Some code like this could be placed in the OnTimerEnd property of your timer.

Collect(myCoord, {Latitude: Value(Location.Latitude), Longitude: Value(Location.Latitude)})

 

Then you can find the average latitude & longitude like this.

Average(myCoord, Latitude)
Average(myCoord, Longitude)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020 Winner Announced

Check it out!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (11,595)