cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

format currency field

In my form I have some currency fields, and I would like to format them.

 

The fields are in DataCard so my entry is Default, I would like to know if there is any possibility to perform this formatting?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi  @Anonymous ,

 

Please try this:

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

Sik

 

View solution in original post

9 REPLIES 9
eka24
Super User
Super User

Yes. But can you show exactly the kind of fogrmat. Meanwhile follow this link

https://youtu.be/scCV3BQs-Cs

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Anonymous
Not applicable

but my field is not as text as the video, it is like editing. Is it still possible?

Yes. Try any of these because you have not stated exactly the format you want;

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

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

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

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

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Anonymous
Not applicable

Include the formula in the Default, but there was no change, I saved it to see if it would change in the output and it didn't either.

 

Do I have to include something in the Update or the save icon as well?

Take a screenshot of your formula

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Anonymous
Not applicable

 

Hi @Anonymous ,

 

Have your issue been resolved? If not, happy to help further.

What is the Default language of your PowerApps studio/Browser? 

It seems that Partent.Default code returns a Text. but what you want to format must be a Number, please use Value() function to convert to Number first and use Text function to format it.

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

 Sik

Anonymous
Not applicable

not yet, the language is english.

 

I entered the informed formula, but this error is appearing:

Lourenacdm_0-1597653947076.png

 

Hi  @Anonymous ,

 

Please try this:

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

Sik

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (5,025)