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?
Solved! Go to Solution.
The Value function should be on Parent.Default, not on the whole expression.
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!
Please consider changing your Formula to the following:
I hope this is helpful for you.
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:
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.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!