How to format a currency field in Power Apps modern form

(0) Share

Report

Posted on by Fada

154

Hello,

I have a Sharepoint list with a currency (USA currency) column named Amount and a Power Apps modern Form.

In Power Apps, I would like to format figugures typed by users like in Sharepoint. Example when Users type 123456.78 or type 123,456.78 , it should be formatted as 123,456.78 in display mode.

Thanks

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Fahd ,

Put in a Label with (actual field name)

Text(ThisItem.YourFieldName, ##,###,###.00)

and on the Visible

YourFormName.Mode = FormMode.View

Then make the Visible of the input box

!YourLabelName.Visible

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Fada 154 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz , Thank you for your reply but I truggle to understand the steps. Can you send me screenshot where I should put the formulas?
Thanks
WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Fahd ,

I am simply saying put a Label in the same Data Card as the Text Box with the properties as I have posted.
Fada 154 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz , many thanks, it works perfectly. Good idea to add a label in the Data Card.