Adding currency formatting

(0) Share

Report

Posted on by FA-18030952-0

I have the following code which works for $ how can I get this to work for £
Text(Parent.Default,"[$-en-US]$#.00")

Thanks

Categories:

Building Power Apps

All responses (9)

Answers (0)

Sort by

AndrewR1 1,572 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Fali324 you can try this for me:

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

Here is my example:

Hope this helps:

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew
FA-18030952-0 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thank you for your reply, I've copied it exactly but mine still comes up with $ rather than £
ganeshsanap 1,555 on at

Like
a
(0)

Report
Copy link

Link copied!
@Fali324 Try using:

Text(Parent.Default,"[$-en-US]£#.00")
References:
Power Apps Currency format

Please click Accept as solution & ‌‌👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
AndrewR1 1,572 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Fali324 my apologies you just need to add this:

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

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew
FA-18030952-0 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

When I use this code I get the error, it can't convert the text to a number. I'm putting the code into the default attribute is that correct?
AndrewR1 1,572 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Fali324 you should put this in the text property not the default sorry so it would look somthing like this:

As long as your passing a numeric value you don’t need to have the Value() if its text you will need to add that:

Value being passed:

Text(ThisItem.Quantity,"[$-en-US]$#.00","en-GB")

Text being Passed:

Text(Value(ThisItem.Quantity),"[$-en-US]$#.00","en-GB")

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew
FA-18030952-0 25 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't have the text option as it's datacard in a form
AndrewR1 1,572 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Fali324 Yes then you can use the default property:

My Code:

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

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew
FA-18030952-0 25 on at

Like
a
(0)

Report
Copy link

Link copied!

When the form is in view mode: I get this error
but then if I into edit mode and then type a number in, it says it can't save it but then it does as when I revert back to view mode the new number is there with the pound sign