Unanswered

Location.Latitude dissapears my decimal separator

(0) Share

Report

Posted on by luisoscarmtz

Hi, im working in a project where i need to get location and latitudes, im trying to patch my locations using location:Substitute(Location.Latitude;”,”;”.”)

but for example when my location is 22,678282 i keep getting 22678282, im using the exact same function with Longitude and its working correctly, i also tried to invert columns and the error still happens where Latitude is writed, my database is located in Excel Online and connected via One Drive For Business

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @luisoscarmtz

Please post both numbers so that we can validate your formatting on both, so hopefully we can find out why.
Also if you can post it in the </> code snipped just to make sure pls

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
luisoscarmtz 29 on at

Like (0)

Report

Sure, here´s my code:
The problem is with the column "Latitud", Longitud is working good, and also Geolocalización is giving the number correctly:

Was this reply helpful? Yes No
luisoscarmtz 29 on at

Like (0)

Report

I also tried extracting the location from "Geolocalización" column using:
Left(DataCardValue18.Text;(Find(" ";DataCardValue18.Text)) - 1)

But the latitude is still patching without the ".", so probably the issue is with Excel format, i also tried patching longitude on the "Latitud" column and it is patching correctly with the "." so the issue its a combination of format and latitude

Was this reply helpful? Yes No
Verified answer

luisoscarmtz 29 on at

Like (0)

Report

if its useful for someone i solved it using:
Text(Location.Latitude, "0.000000") instead of Substitute function, i really don't know why Longitude is working and Latitude don't but i fixed it this way.

Was this reply helpful? Yes No