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:

Connecting to Data

Using Apps Using Formulas

All responses (6)

Answers (0)

timl 32,024 on at

Like (0)

Report

Currency fields are displayed as Decimal Numbers in Modern table control

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?
Suggested answer

mmbr1606 9,998 on at

Like (0)

Report

Currency fields are displayed as Decimal Numbers in Modern table control

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
Venkata Golla 78 on at

Like (0)

Report

Currency fields are displayed as Decimal Numbers in Modern table control

@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.
Venkata Golla 78 on at

Like (0)

Report

Currency fields are displayed as Decimal Numbers in Modern table control

@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.
timl 32,024 on at

Like (0)

Report
Currency fields are displayed as Decimal Numbers in Modern table control

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.
Suggested answer

mmbr1606 9,998 on at

Like (0)

Report

Currency fields are displayed as Decimal Numbers in Modern table control

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