Currency fields are displayed as Decimal Numbers in Modern table control

(0) Share

Report

Posted on by Venkata Golla

Hi Experts,

I am building a custom page that has a Table control with Dataverse as source. I found that the data of Currency columns are displayed differently in Studio vs live app/ page.

Please advise if I am missing something or has a workaround for this.

Preview in Studio:

Live Page:

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

mmbr1606 14,605 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hey

this is related to modern controls and there is no solution. i and many others wonr suggest using modern controls as of now. they are still in preview and act very buggy.

do yourself a favor and stick to the classic controls as of now.

if my answer helped please mark as verified,

cheers

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

Like (0)

Report
Copy link

Link copied!
Hi Venkata Golla,

To workaround this, I'd suggest that you change the Items property of your data table to included formatted versions of the Planned AUD and Variance values. If you display these formatted columns instead, it should hopefully work.

AddColumns( YourDataVerseTable, PlannedAUDFormatted, Text(PlannedAUD, "$#,#.00"), VarianceFormatted Text(Variance, "$#,#.00") )

From your screenshot, it appears that you might be in Australia. If that's the case, I note that in your "working" screenshot, the dates are displayed in mm/dd/yyyy (which is incorrect for Australia), but they appear correctly as dd/mm/yyyy in the live page.

Was this reply helpful? Yes No
Venkata Golla 78 on at

Like (0)

Report
Copy link

Link copied!

@timl

Thanks for your response.

I will create few text columns if I don't find any other way, but I can't use add columns in the app as it will break all references to fx columns in the table.

Was this reply helpful? Yes No
Venkata Golla 78 on at

Like (0)

Report
Copy link

Link copied!

@mmbr1606,

Thanks for your response.

I am not sure what you meant by stick with Classic controls. Is there a classic table control?

I can't use galleries as I have morethan100k rows and 26 columns to display. I thought of using Fluent UI details list but that is a bit annoying cause of double click to select a row.

Was this reply helpful? Yes No
Suggested answer

mmbr1606 14,605 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey

No there is No Classic table Control.

But working with modern controls is Not a solution as of now (as u can see in your use Case).

Maybe this Video helps:

https://youtu.be/zxZGaXQlZqo?si=gy324ZDXyV0DsotH

If IT does please mark my answer as verified.

Cheers

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

Like (0)

Report
Copy link

Link copied!

Hi Venkata Golla

>>but I can't use add columns in the app as it will break all references to fx columns in the table.

If you place the call to AddColumns in the Items property, it'll just add 2 additional formatted columns and it shouldn't break any references. Can you clarify what you mean or what errors you see when you do this?

Was this reply helpful? Yes No