SharePoint List Calculated field, currency format

[kmw1130]

I have a calculated SharePoint field with a data type of currency.  In my PowerApp, my formulat is:

"$" & Value(Text(Parent.Default, "[$-en-US]$ 00.00")), it displays like: $68558.  It does not add a comma or the .00.

I've tried this formulat as well: "$" & Value(Text(Parent.Default,"[$-en-US]$###,##0.00")) and results are the same.

Is it possible to format a calculated field in PowerApps?

Thanks

Kim

[padminisravya]

Hi,

Can you try using this Formula  Text(Value(Datasource,filed),"[$-en-US]$ #,###,##0")

[RandyHayes]

@kmw1130 

Please consider changing your Formula to the following:

    Text(Parent.Default, "[$-en-US]$#,##0.00")

I hope this is helpful for you.

[kmw1130]

@padminisravya I get formula errors.

[kmw1130]

@RandyHayes This gives me a bunch of extra 0s (68558.0000000000) and no dollar sign.

[RandyHayes]

@kmw1130 

This formula works well, so there is something amiss in your value.

Change your formula to Parent.Default alone.  What does it show?

[kmw1130]

@RandyHayes 

This is a SharePoint Calculated field.

[RandyHayes]

@kmw1130 

What do you get when you change the formula to:

Text(18138.0000000000, "[$-en-US]$#,##0.00")

[kmw1130]

@RandyHayes 

Is what I want, but how would I get it on the field value?  Would I need to copy it into a Text field?

[RandyHayes]

@kmw1130 

No, that was just a test to make sure you were not experiencing any language locale issues.

Your formula should be Text(Parent.Default, "$#,##0.00")

Currency columns are not special in any way except that the concept of "Currency" is for the SharePoint interface only.  IN the column, the value is still stored as a number.  It is not stored with any currency information.

The calculated column is usually somewhat problematic to PowerApps, but in this case, there should be no issue.