I have a PowerApp that is showing four currency fields from the Common Data Service as numbers with no commas or currency signs...
Within the common data service the fields are registered as currency...
So in PowerApps, I formatted the Text property of the Data field to Text(Parent.Default,"[$-en-US]$ #,###") as per the instructions at https://powerapps.microsoft.com/en-us/tutorials/function-text/ ...
However this does nothing to the field in the actual UI and I am still left with unformatted fields as referenced above.
This appears to be a bug. Can anyone else confirm that they are seeing the same issue? If not, how were you able to resolve this?
Solved! Go to Solution.
I would surmise that those fields are being delivered into PA as strings, not numbers, which is why attempts to format them as numbers fail. Try wrapping the field in the Value() function to turn it from a string into a number, then format that.
I would surmise that those fields are being delivered into PA as strings, not numbers, which is why attempts to format them as numbers fail. Try wrapping the field in the Value() function to turn it from a string into a number, then format that.
Hi @jobender,
Try this:
Text(Value(Parent.Default),"[$-en-US]$ #,###")
See:
Regards,
Michael
Thanks for the insight, that formula did the trick.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
175 | |
46 | |
46 | |
34 | |
33 |
User | Count |
---|---|
258 | |
87 | |
78 | |
68 | |
67 |