web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Get currency value usi...
Power Pages
Answered

Get currency value using web template

(0) ShareShare
ReportReport
Posted on by 1,510

Hello,

 

I'm retrieving data using Web Template/Fetch XML in my Basic form.

My result array has name(string), id(guid), total(currency). So, when I get value  of total(currency) field, it returns like 22,00 Here comma is like fullstop. It returns like this because of my currency format settings in Dataverse. 

 

Now, I want to retrieve total field value as 22.22 instead of 22,22

 

How can I achieve this?

Categories:
I have the same question (0)
  • H V Profile Picture
    1,510 on at

    Thank you @OOlashyn   🙂 🙂 🙂

  • Verified answer
    OOlashyn Profile Picture
    3,496 Most Valuable Professional on at

    Hi @hardikv ,

    If it will always return "," instead of "." you can use replace string filter:

    {{ item | replace: ',', '.' }}

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 58 Super User 2025 Season 2

#2
Jerald Felix Profile Picture

Jerald Felix 27

#3
Lucas001 Profile Picture

Lucas001 25 Super User 2025 Season 2

Last 30 days Overall leaderboard