Round/Shorten location value

[servicesGB95]

Hi guys,

in my app I want to match the location value with a sharepoint list in order to auto fulfill data. 
Is it possible to cut of the last 3 numbers of the longtitude and latitude value?

Cheers
Julian 

[Drrickryp · Accepted solution]

Hi @servicesGB95 

Round(), RoundUp() and RoundDown() all can be used for numeric data. The number of decimal places is set as the second element of the function: Round( Number, DecimalPlaces ). I have no idea if it can be used on location values.  It will work on a whole column in a single column table.  see https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-round  for more details on Round() and the related functions.