PowerApps Text function to format currency and numbers

Do you want to format Power Apps Currency? Do you need $12,354.00 or €032,195.55. Or how about other things like 333-22-4444? then this is the video for you. We talk about all things number formatting in PowerApps using the Text function.
Power Apps Consulting and training at www.PowerApps9...

[@rafaelmorales6736]

Hello Shane, I would like to thank you for your advice in this video. I have learned PA by myself, your videos have meant an excellent reference. Your explanations and examples are straight and clear. Keep going to be an top guru.

[@ShanesCows]

Awesome. Good job digging in and learning Power Apps. 😎 It is a great skill to learn.

[@BigLeafDropper86]

Works great with labels would like to see formatting text input box options as this is more commonly used.

[@ShanesCows]

Noted. :)

[@kilaj1]

exactly what I was about to ask :)

[@chairattangthong]

Very useful Teacher. thank you so much for your support. :)

[@ShanesCows]

You are welcome!

[@daniellemartineau4065]

Thank you so much for this. Tricky to keep straight but finally got it. Super helpful.

[@ShanesCows]

Glad you got it. 🙂

[@sundrapillay6668]

Congrats on 100k! well done

[@ShanesCows]

Thank you so much 😀

[@LifeWithMyWifeAfrica]

Hi Shane, is it possible to format the text input so that while you type, the number gets formatted?

[@johnnyvlee]

This is called an "input mask" and there is FAR TOO LITTLE support for this in Power Apps.

[@tristangeoffroy9286]

Thank you Shane that's painful topic, .. all the time. You also could add that in reverse, Text to Value we have to specify the language so it could be translate in number ( Value(Text,'thelanguage of the text')

[@pietjehans206]

These cultural differences have taken me hours and hours. And most of the time, it still needs a workaround. It is way more complicated then shown in the video. The main reason is that the Microsoft applications use TEXT in order to determine this. I don't want to change my datatype! I just want to force certain cultural aspects without changing it on environment level.

[@bellam2413]

Thank you! I used the the Value() to convert number to military hours.

[@teddavis1689]

Thank you! It *SHOULD BE* right click and select on value > currency and the code would update accordingly.

[@ShanesCows]

That would be nice!

[@juandavila4035]

I love it, very useful. Thanks

[@ShanesCows]

Glad it was helpful!

[@ResponsibleXI]

Practice saying 1000 separator 100 times :P. Great Video Shane as always.

[@ShanesCows]

Tongue twister 🤪

[@GreyDob]

Thank you Shane, you made my day ... again :-)

[@ShanesCows]

Glad to help. 😀

[@BigLeafDropper86]

Congrats on 100k! well deserved 🎉🎉🎉👏👏👏👏🚀🚀🚀🚀🔥🔥🔥🔥

[@ShanesCows]

Thank you so much 😀

[@iyengar007]

Shane MY Hero, Here is a tricky question. Can you demo how to use file convertors without using any premium or third party connectors like excel to PDF?

[@ShanesCows]

Don’t know how to do that. Sorry

[@ilikeurstyle2594]

Is there any way to format the input numbers while typing values in the TextInput ,instead of having label to show the format numbers

[@ShanesCows]

Nope. 😑

[@onkarteli3388]

Hello Shane, Thank you for this wonderful video. Please let me know how we can set number as data type to Text Label without using the Text Input

[@ShanesCows]

Sorry I don’t understand the question

[@juliandini6477]

Thank you, now I can format on my country currency 😁😁😁

[@StuCrooks]

Hi Shane, Great videos BTW. Question, can you format the field that's being typed in? I see you use a different field to display the formatted data. So, if someone types in 15.5 after they move to another field, it shows $15.50. Thanks, Stu

[@davidsheumaker3836]

So for a Text Input the way that I did was: for the OnChange property I set a variable to Self.Text and then reset the text box. For the default property I sent: Text(Value(variable),"$##,###.00"). OnChange Property: Set(varTextInput,Self.Text); Reset(textInput1); Default Property: Text(Value(varTextInput),"$##,###.00") hope this helps

[@meenajain7349]

Hi Shane can you make video on how to convert 32 to Thirtytwo

[@ShanesCows]

I don't have an easy answer for that one.

[@apuapustaja2063]

I Fuckn Love you man , I really fucken do. stay awsome my guy!

[@ShanesCows]

Appreciate that. 😎

[@KatRG6453]

I appreciate you so much!!!

[@ShanesCows]

Thanks Shelby! 😎

[@leulmelaku2313]

Hi Shane. thumbs up for your work. I have one question regarding on this topic. I have a text field in number format and i wanted to display this numeric values in word on another label how can i achieve this?

[@ShanesCows]

There is no built in way to cover 5 to five if that is what you are asking for. I have seen people do it, but it requires finding logic or an API to call and get the result back.

[@belkaaloulwahiba4770]

thank you so much

[@ShanesCows]

Welcome 😊

[@stephendarier1390]

Great video. If you had to rap the label that has been formatted with Value when you patch it to a number column will it not accept it as a number value?

[@ShanesCows]

Correct. Text function outputs text so can’t write it to number column.

[@AlistairReid-mt6ne]

thank you

[@ShanesCows]

You're welcome

[@JenMayB]

Hi, thank you. I’m not sure how to handle this issue in an edit form when submitting back to SPO unfortunately.

[@ShanesCows]

You cannot use it inside of an edit form easily. Text Input controls are not quite so friendly :(

[@JenMayB]

@@ShanesCows thank you Shane for getting back to me!

[@MoTheSeeker]

Hi Shane! love your videos very practical and detail. I would like to request one video especially related to Master-Details records updates in Dataverse. Recently I came across the challenge as my detail table was not updating the record. It would be a great help if you can make a video on Datavers Master and Detail record update. Thank you in anticipation :) again love your great videos like always

[@ShanesCows]

Noted Mo. thanks 😊

[@DirtBikingFunWith14]

Shane, Can you create a video on importing an Excel number into a field box and how to format it as currency. Does Power Apps not recognize the value format of the item it's importing/exporting/editing?

[@ShanesCows]

When pulling from Excel it does try to understand the format. But if it sees it as currency that is a number and will not bring in the symbol. If the field is text then it would bring in the symbol. You could then use the Value function to turn the text number into a number number.

[@DirtBikingFunWith14]

Thank you. I knew I had to be missing something simple.@@ShanesCows

[@radiosonicfan1726]

Cool Lesson. Hey, with some numbers you want people to enter but also to hide the data (like Credit Card Info). Enter but only show last 4 digits. or convert the numbers to symbols and show last four. Is there a way to do this in Power Apps?

[@EM666Fly]

I don't know if I was searching wrong, but I just wanted to know how to convert text to number coming from a text input. I COULDN'T FIND IT ANYWHERE. Thank youuuu

[@ShanesCows]

Value(TextInput1.Text) would take the text 12 and change it to the number 12. Hopefully that is your question. If you want to convert twelve to 12 there is no easy way to do that.

[@TessAlmond]

So, we have a text input phone number field that will display as 3333333333, and a label that displays it as 333-33-3333. But I'd like it to display formated in the original field either while the user is typing, or as they tab out of the field. Can that be done?

[@ShanesCows]

Nope, sorry

[@TheDarkDarkHouse]

Absolute legend! thanks so much

[@ShanesCows]

You're welcome!

[@marcelocamavilca9229]

Can i change the language? Because i have es-ES but i'm in Perú ... so i have the numbers like 1.000,00 but i want 1,000.00

[@ShanesCows]

I think you could add the Language portion to the Text like I show but not 100% sure how it plays out. I don't have access to other regions to test. Boo.

[@marcelocamavilca9229]

@@ShanesCows i tried but doesn't work. Thanks anyway

[@pramathabhat]

Hey, just wanted to check if you were you able to fix the issue? TIA

[@CarFinanceSimplified]

Hi. I am trying to sum some text boxes, wrapped with VALUE, but each time I enter a negative ("-") sign into any of the boxes I get a warning that "-" cannot be converted to a number? Any ideas please?!

[@ShanesCows]

I just tried this and it worked fine. :( I added TextInput4 and typed in -12. The I had Value(TextInput4.Text) and it worked. Did you do anything different than that?

[@CarFinanceSimplified]

@@ShanesCows Many thanks for trying! Really odd as no matter what I try I get the error. However I’ve now sorted it by wrapping the total in an IFERROR statement which has sorted it 👍

[@jstrugnell]

Hi. Very helpful video, thanks. Once you've formatted a label in this way, as currency, is there any way to use that field as a number? For example, in a simple scenario, maybe you have 2 labels which each have a currency amount and then you have a 3rd label which is to show the sum of those. Once you format them in this way, you don't seem to be able to perform a Sum() operation on them (or any numerical-based formula). You also can't use a self-referencing formula in the Color property to make the color "Red" if the amount is negative. I've started using a backing variable for every label, so we're not referencing the labels themselves in formulae, do you have a better way?

[@giantdutchviking]

I would like to know this as well

[@jaysizmir9432]

Thank you so much Shane ! How do i put the currency in the right side of the number ?

[@ShanesCows]

I haven’t tried. Hmmm

[@a7xforever1111]

i have followed for quite some time, I still struggle with Dataverse and working with relational tables from powerapp, So if you could at some point make a video on how to add data to a table with information from relational table as input from powerapp. That would be very nice, as there is not much out there on Dataverse and relational tables. As I am often having trouble with accessing multiple relational tables, with one data table in powerapp. Hopeit made sense, and thanks in advance :D

[@kimgaskins6966]

Thanks! Very helpful!! I applied this to a dataCard and it didn't work. Any suggestions?

[@ShanesCows]

Kim the reason i bet is your datacard is returning text, not a number. :( The text function only works against values. Try wrapping the Text(Value(parent.default), "$#.#")

[@guytech9502]

Hi sir, How to set CultureInfo("en-US") or equivalent solution in Power Apps? Or Do you want format number without CultureInfo of User Setting? Example: I want to save 0.25 to Excel file, formular sum some 0.25 (as 0.25*5 = 1.25) and then view it (1,25) to screen

[@vinosuresh6678]

Hi, Shane! Thanks for your informative videos. Kindly share the currency format for India. "##,##,###.00" is working as "#,###,###.00"

[@MM-zf9ys]

Hey Shane, your videos are fantastic. They've helped me no end! Is there a way to show the decimal if there is one and exclude if there isn't. E.g. I would want 1000.26 to show as £1,000.26 - That's fine - But I would want 1000 to show as £1,000 - At present I'm getting £1,000.00

[@haziqaiman1687]

hii, u find the way to do this?

[@josueisaelcastrosoto]

Hi Shane, thanks for the video and explain how to format, hope you can help me with my issue, How can I set up the decimal separtor on the textinput to be dot instead of comma? I was told to change the regional setting on my 365 account, the sharepoint site and the computer, but nothing seems to be working, hope you can help me on this

[@ShanesCows]

Do you know what language that is the standard for? Try Text(12345, “#,###”, “thatLanguage”) and it should work.

[@josueisaelcastrosoto]

@@ShanesCows I don't, I use the formula to show on labels, but trying to figure it out when users type on the text input

[@waynepeinke]

Hey Shane, great video to learn how to format currencies but what about getting those currency values in to PowerApps in the first place? I've been fishing around and there's lots of info about creating a custom connector or using the HTTP premium connectors to get forex rates from api's but all of these options require additional licensing as they are not available with M365 licenses. Is there any way to pull some json code from a url/api call into PowerApps without using a custom connector? Currency converter app that gets live forex rates from the internet would be a good topic for another video maybe...

[@DutchNorthAtlanticAlliance]

Amazing, thanks!!!

[@user-vy8si6sl1u]

Hi Shane! Thanks for all of the helpful videos! How would I convert number values to currency imported from a SharePoint list displayed in a text label instead of an input text field within a gallery? I've tried the following formula and just get errors. Text(Value(ThisItem.'MAX VALUE'.Text,"$#,##0.00"). Any help would be appreciated!

[@yeraldo05]

Really great video Shane! Quick question, is there a function that can convert the numbers into words? Example: 100.10 = One Hundred and Ten Cents.

[@ShanesCows]

Not that I know of. :(

[@rrq177738]

Hi Shane, thanks for the video! Great content! Question for you, what brought to this video was a problem I was having. I have an app I use here in US and in Mexico. The colleagues in Mexico see a different cost then I see in the US. For example if I see 227.1734 they see 22,717.34. Is that power apps converting currency by default. If I use en-US like in your video should that fix the problem for the colleagues in Mexico?

[@pramathabhat]

Hey, just wanted to check if you were you able to fix the issue by adding en-US?

[@rrq177738]

@@pramathabhat en-us didn’t work it turns out the colleagues from Mexico had there language set to Spanish in Europe once I switched there region North America it worked perfectly!

[@karolinaunderwood1039]

hi Shane, this is cool, as always... but i have different problem.... I am displaying currency values from SharePoint datasource in a Gallery. I am based in the UK but the SP is in $. PowerApp is the values are displayed in £ and even my colleagues in the USA can only see £ (despite datasource).. Any idea how i can change this so all the values are displayed in $?

[@kaylamiller3748]

Hi Shane, I am creating a Form that feeds to a SP list. So the data comes from the list. I have in the list that the number should be in percentage format. But in the form in powerapps i dont want to require submitters to put in a decimal if i can avoid it. So, my problem is if someone enters 20, meaning 20% in the list, the item updates as 200% - which is obviously not correct. Any advice would be great. Thanks!

[@t12013]

Hello and thanks for amazing video. I was actually working on this for 3 days ago. What are the odds! Anyways. I have a problem. When the value is 0 then it displays nothing. Any idea on a solution. Or IF statement it is? Like if(input1 = 0,0, text(input1.text, ### eg)?

[@ShanesCows]

Off the top of my head I think If is the way to go. 😎

[@ShanesCows]

Julio you ended up inspiring todays video. A different way to think about this problem. I hope it helps. kzbin.info/www/bejne/qKa1dXpjraiVgdU

[@t12013]

@@ShanesCows Great ! thanks for tips. This works great.

[@TheCinrec]

hi there! this work with a sharepoint list in numer format? thx

[@indragunawan-uz9ke]

how to change number automatic ?

[@thalbauerlukas2634]

Hello and thx for your videos !:) I have one question.. Is there a way to convert a textimput directly? The user should type the time in a teximput. If the user type 1800 is it posible to convert it directly to 18:00? Thanks.:D

[@ShanesCows]

You would need to do it into another label like I show here. There is no mask feature in Power Apps

[@thalbauerlukas2634]

Thx :D

[@BryanSeigneur0]

Uhg, can't get phone number formatting working. I keep mine as long ints. Real straight forward in C# but I can't find how to do this in Pwrfx. I've seen Text(Value(stringToFormat), "[$-en-US](###) ###-####") but that gives nothing. If I put any character except for a select few in the second parameter of Text(), nothing at all happens. So there must be another tree I need to bark up. Or I need to do my own string parsing. But wow this seems like it would be a well trodden path...

[@BryanSeigneur0]

I found my problem. The format property of the control was "Number" instead of "Text". It needs to be Text in order for me to do the transforms on it. This seems Wrong(tm) but as long as I'm getting it back to a value/numeric form before update I guess all is good.

[@_JezzaG]

Hello Shane, I've got a gallery that is being used as an editable grid (kzbin.info/www/bejne/bWe1e6yXpLxjeLM) - how would I go about formatting currency and numbers in that situation? Data that's changed will go into a collection and then update the data source.

[@ivancuervo777]

Hello Shane, there is an addition to your video I would like to share... kzbin.info/www/bejne/pqDZqap8j5msn80, it would be nice to see the entry formatted at least when you finish typing the text