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
Solved! Go to Solution.
The Value function should be on Parent.Default, not on the whole expression.
"$"&Text(Value(Parent.Default),"[$-en-US]###,##0.00")
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi,
Can you try using this Formula Text(Value(Datasource,filed),"[$-en-US]$ #,###,##0")
Please consider changing your Formula to the following:
Text(Parent.Default, "[$-en-US]$#,##0.00")
I hope this is helpful for you.
@RandyHayes This gives me a bunch of extra 0s (68558.0000000000) and no dollar sign.
This formula works well, so there is something amiss in your value.
Change your formula to Parent.Default alone. What does it show?
What do you get when you change the formula to:
Text(18138.0000000000, "[$-en-US]$#,##0.00")
Is what I want, but how would I get it on the field value? Would I need to copy it into a Text field?
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.
User | Count |
---|---|
262 | |
110 | |
92 | |
54 | |
43 |