Unanswered

Formula Column and Converting Decimals to Text

(1) Share

Report

Posted on by Joshua Wollberg

Hi, I am attempting to concatenate text in a formula column to create a dynamic google maps link. When I attempt to convert a decimal (latitude or longitude values) to text, I'm not able to use a decimal in the formatting. Any workarounds here? It is requiring a formatting argument when using Text().

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

KT-07052127-0 15 on at

Like (1)

Report
Copy link

Link copied!

From Learn: The Text and Value functions only work
with whole numbers, where no decimal separator is involved. The decimal
separator varies across locales. Since formula columns are evaluated
without locale knowledge, there's no way to properly interpret or
generate the decimal separator.

I'd use Power Automate to do the conversion.

Was this reply helpful? Yes No
ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can try extracting the integer potion and the decimal portion to get the text values then concatenate them.

I have not tested this.

For the integer portion Trunc(12345.3454) should work

for the decimal portion where 234.23 would be the latitude or longitude

(234.23 - Trunc(234.23)) * 100

This would produce 23.00 thus giving you the decimal portion

The factor that you multiply by would depend on the precision in your values and you can then concatenate the period back in

Hope this can help to point you in the right direction

Give me a like if helpful

1 people found this reply helpful.

Was this reply helpful? Yes No
Joshua Wollberg 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the help!

I attempted the solution ronaldwalcott recommended and it was so close to working. Unfortunately, if there are any leading zeroes in the decimal, it does not convert accurately (they get dropped).

There is probably a way around this I haven't considered, but I will be using power automate to achieve this for now.

Thanks again!

Was this reply helpful? Yes No