web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps sharepoint calculated ...

Power Apps

Unanswered

sharepoint calculated columns showing multiple decimals in PowerApps

(0) Share

Report

Report

Posted on by dennisb88

603

Hi All,

I've found a lot of solutions about displaying the numbers without decimals. But they all are not working in my situation.

What I have is a couple calculated fields from a SharePoint list in my Power App.

The result in SharePoint shows 10

In PowerApps it is show as: 10.00000000000000000

I found a couple of solutions to edit the text formula, but that will not help in my situation. I used this formula:

Text(Value(ThisItem.'Winst per uur');"€" &"#")

The result is:

€100000000000000

Thats not right because I expect €10

Another formula that I've tried is:

Text(Value(Parent.Default);"[$-nl]#.0")

This give the follow result:

100.000.000.000.000

Also not the expected result.

Hopefully someone of you know how to fix this.

Kind Regards,

Dennis

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

WarrenBelz 155,346 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @dennisb88 ,
Have you tried
Round(Value(ThisItem.'Winst per uur'),2)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
dennisb88 603 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thank you for you reply.

I've tried your suggestion, but it's not give me the expected result:

It's still showed 100000000000000 as value.
My SharePoint list showed as expected 10:

Any other idea?

Was this reply helpful? Yes No
WarrenBelz 155,346 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @dennisb88 ,
This has got to be a bug with your region code I suspect - I cannot replicate it here.
I suggest you lodge a Support Ticket with Microsoft

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No

Join the conversation