PowerApps Issue... showing a currency field as a currency and not a number

[jobender]

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?

[AndyPennell · Accepted 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.

[v-micsh-msft]

Hi @jobender,

Try this:

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

See:

Regards,

Michael

[jobender]

Thanks for the insight, that formula did the trick.