cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to change coma into point ?

Hi everyone,

 

I would like to create a map with a precise position using Location.Latitude and Location.Longitude, the issue is my PowerApps is in french so the coordinate appears like "48,8891395" so when I clicked on my image control to go to Google Map it says that there is no place found beacause of ",".

 

If I put "." manually it works, I would like to "convert" my "," into ".". How is it possible ? 

 

I tried this formula "Text(Location.Longitude;"[$-en]")&"."&Text(Mod(Location.Longitude;1)*1000000;"[$-en]")" but the coordinate change to "48,8891395" to "49.889119" why that change ? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: How to change coma into point ?

@Asy 

You might look at the substitute function for this.

 

Substitute(Text(Location.Longitude), ",", ".")

I hope that is a quick help for you.

 

EDIT: that was assuming that the value in your longitute is with the comas.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: How to change coma into point ?

@Asy 

You might look at the substitute function for this.

 

Substitute(Text(Location.Longitude), ",", ".")

I hope that is a quick help for you.

 

EDIT: that was assuming that the value in your longitute is with the comas.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Highlighted
Helper I
Helper I

Re: How to change coma into point ?

@RandyHayes ,

 

Thank you ! It's working great 🙂

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

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 (7,352)