Power Apps -Text Input Numbers Formatting - comma, dot, currency code WITHOUT using additional label

In this episode I'll show you how to format Text Input without using any additional label to store same function, , You can add comma, dots and currency Codes in the same Text Input after you finish typing. Circular reference would also be overcome, couple of different solutions will be provided

In my recent tutorials, I'm concentrating heavily on powerapps, model-driven apps, Dataverse, and Power Platform as a whole, When I'm encountering an interesting topic / defect I try to immediately post it on Youtube to make other people's life easier. Sometimes I'll also touch Power Automate but mostly when it supports Canvas.

[DanielRodriguez-pd]

Thank you so much for this solution, it's a life saver. Nothing is quite so motivating like nitpicky, older coworkers who want to see their phone numbers properly formatted.

[Gnuify]

That seems like such a "little" problem, yet it was kind of hard to find a good solution to it. Thanks for the video, that actually helped! 🙂

[MaliYojez]

This was extremely helpful, put me on the right path, but also needed the saved value to be retrieved from the list. A saved value of 0 would never be needed. My solution was this:

I used a number only field.
In the default of the text input - If(varAmountChange = 0, Text(Parent.Default, "#, ##0.00"), Text(varAmountChange, "#, ##0.00"))
In the On Change of the text input - Set(varAmountChange, Value(DataCardValue3.Text))
I then placed this Set () wherever the form was opened or closed - Set(varAmountChange, 0)

[pantaman]

Thanks, this actually helps, showing with label is not a workaround in most cases..

[mariayeghiazaryan]

Great video! Very helpful, thank you!

[halimahabfatar]

Thank you for the sharing. However, I want to ask if I am doing it in the form and have tried to submit the form. But when using the new form, the formatted data is not reset even though I have using the NewForm and ResetForm function. Can I know why?

[DarraSmith-owxz]

How do you get this to work on a value that is store in a SharePoint list. In other words, the value of the text box is populated with different values as you click on a gallery, which pulls in the Sharepoint record. The formatting only happens on a change and so setting the default to the value from the SP List (number only) you don't get the formatting.

[jospph]

Hi, thanks for your video. You know if it's possible to do sums or other operations and using this text format?

[_JezzaG]

Any hints on getting this to work in a gallery? This approach overrides all rows as it uses a variable...

[DarraSmith-owxz]

Ok, I'm going to try again. The issue is what if the value for this field is populated when you click on a gallery that contains a lot of different values for the field. Each time you click on the SharePoint it populates the text field with the value the numeric value that was stored. However, it doesn't format it because there isn't an OnChange fired. Would love to know how to use this solution when you aren't starting out with a blank.

[mhochups]

Can't reset the variable to blank. Any workarounds for this

[pavannalamala]

this is for only one control what if we use textinput control inside a gallery and on change if we write it displays for all records as the variable set to default

[karolinaunderwood]

This is cool, thank you for sharing. However, what about if I would want to use this to create new record in SharePoint where my cost column is a currency column? How can i convert this back to the number when creating new record (not just displaying it)? I am using Patch to create new record

[rodfmess]

Super helpful 🙂. One question, though: what if the default property of the text input is a lookup?

[DarrenCarlson-zvec]

This is exactly what I'm trying to accomplish so thank you for taking the time to create this video. I've liked and subbed. But could you help explain how to do this within a form with the Default property of the input field is Parent.Default since it's getting it from a datacard?

[benjaminnzioki]

It seems so many of Power Apps maker really want to a solution to this problem. This works perfectly in standalone text input control but not if the control is part of a gallery, would you be knowing how to set up this in a gallery?

[Christiangoncalves]

Hi, How to just put something like "038 - 040"? just the hifen

[talhaiqb]

how to reset the data we just entered?

[zbigniewlukowskitutorials]

If you want to cover also the scenario when user enters SAME input again use Function: of "OnSelect" property of input

[dbcpro]

Long story short, PowerApp is bugged and shows Value() as an error until you click out of it and let it run.