weird issue with decimals

(1) Share

Report

Posted on by neleS

i made this app, where it gives specific data for specific chosen rows.

"herboeken lokaal in" and "bezet op wachtlijst" are calculated from other columns.

this is what it looks like in the list:

this is what ti's supposed to look like:

Everything is nicely rounded. this is with my account to make the apps.

If i go to Teams, where the app is situated for other users, and myself.

I get this:

"reeds bezet", no issue, it shows the value perfectly. the others have all the 0 decimals showing...

My own user (not the maker of the app) has full rights on the List, so do the other users. I already tried everything code wise to put this correctly, yet nothing works.

Round(Value(ThisItem.CalculatedColumn), 0), Text(Value(ThisItem.CalculatedColumn), "[$-en-US]#"), Round(Int(Value(ThisItem.CalculatedColumn)), 0), and other functions that round a value.

I am lost on what else I can do to make this work...

How can I fix this?

Greetings

Nele

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

timl 37,227 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nele

Can you confirm the data type of your "herboeken lokaal in" calculated column? Is it of type number?

What happens if you just use ThisItem.'herboeken lokaal in'?

Do you see '16.0000000000' or '16,0000000000'? If so, what decimal separator symbol is shown?

Was this reply helpful? Yes No
neleS 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi timl

yes, all the calculated colums are 'number'.

if i use: thisitem.'herboeken lokaal in' I get "16.000000". So i have to use Int(thisitem.herboeken lokaal in). to make it a rounded value.

when there are decimals (when using the app in Teams), it's 16.00000000.

Thanks

Nele

Was this reply helpful? Yes No
timl 37,227 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Nele,

Thanks for clarifying that. I'm pretty certain that the cause of this is a mismatch of language settings in the browser, Power Apps, and/or SharePoint.

In the screenshot of what you use to create your apps, it looks as though you have it setup to use US English (based on the date format of 10/31/2024).

I assume SharePoint is setup to use English (since the calculated value returns 16.0000000 rather than 16,0000000)

It looks like your Teams is probably setup for Dutch (since the date format used is 31/10/2024)

Given that the US/English setup is what works for you, I would specify US English to see if that fixes the problem in Teams.

Round(Value(ThisItem.CalculatedColumn, "en-US"), 0)

Was this reply helpful? Yes No