Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Retrieve formatted value for a currency column using Javascript

(1) ShareShare
ReportReport
Posted on by 65
I can retrieve the numeric value for a currency column as shown below and get the value, such as 9999
 
var totalQuoteAmount = formContext
    .getAttribute("kcw_totalquoteamount")
    .getValue();
 
I want to get the formatted value, such as 'CA$9,999.00'.
 
I understand there is a 'getFormattedValue' feature but I have not been able to determine what the correct syntax is.
 
Can anyone point me in the right direction?
 
Thanks.
 
 
Categories:
  • Verified answer
    MichaelFP Profile Picture
    1,827 Super User 2025 Season 1 on at
    Retrieve formatted value for a currency column using Javascript
    You can use that
     
    formContext.getAttribute("kcw_totalquoteamount").getValueInternal().formatted

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard