cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bsakura
Regular Visitor

Format field to currency in portal

Hey, I have a budget field in my portal and I would like to format it automatically to a currency so user won't be confused upon making an input, Is it possible to achieve result like $ 4,000,000 instead of 4000000? Thank you in advance!

bsakura_0-1618432654919.png

 

1 REPLY 1
Fubar
Solution Sage
Solution Sage

Not out of the box.  Believe this is only an issue on an  Insert, once it is saved it should show the currency symbol and formatting - think the underlying issue is that the portal doesn't get the usually hidden 'currency' field populated until the record is saved 

 

See these 2 threads about the same issue for some links etc 

https://powerusers.microsoft.com/t5/Power-Apps-Portals/format-number-when-filling-in/m-p/548036#M137...

 

https://powerusers.microsoft.com/t5/Power-Apps-Portals/How-to-enable-currency-formatting-on-Entity-F...

 

If your doing a completely custom rather than using Enitity/Web Form then you can use currency filters etc in Liquid as per https://crmtipoftheday.com/1321/formatting-currency-values-in-power-apps-portals/

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,762)