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.
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?!
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?
@@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 👍
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
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
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?
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?
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?
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?
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.
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
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?
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.
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), "$#.#")
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?
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.
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
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?
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!
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
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 $?
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!
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...
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 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!
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...
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.
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)?
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
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')
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
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.
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
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.
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
Hello Shane, I've got a gallery that is being used as an editable grid (th-cam.com/video/76RJyaoW0BQ/w-d-xo.html) - 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.
Hello Shane, there is an addition to your video I would like to share... th-cam.com/video/povxwFZ4yik/w-d-xo.html, it would be nice to see the entry formatted at least when you finish typing the text
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.
Awesome. Good job digging in and learning Power Apps. 😎 It is a great skill to learn.
Congrats on 100k! well done
Thank you so much 😀
Excellent explanation. I love the dog in the background 😍
Thanks! Lots of people just watch for the dog 😎
Hi Shane, is it possible to format the text input so that while you type, the number gets formatted?
This is called an "input mask" and there is FAR TOO LITTLE support for this in Power Apps.
Thank you so much for this. Tricky to keep straight but finally got it. Super helpful.
Glad you got it. 🙂
Works great with labels would like to see formatting text input box options as this is more commonly used.
Noted. :)
exactly what I was about to ask :)
I was cracking my head on this 😅 Thank you for sharing
You are welcome, this is the type of video that comes from a place of pain for all of us. 😀
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?!
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?
@@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 👍
Hi, thank you. I’m not sure how to handle this issue in an edit form when submitting back to SPO unfortunately.
You cannot use it inside of an edit form easily. Text Input controls are not quite so friendly :(
@@ShanesCows thank you Shane for getting back to me!
Congrats on 100k! well deserved 🎉🎉🎉👏👏👏👏🚀🚀🚀🚀🔥🔥🔥🔥
Thank you so much 😀
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
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
Very useful Teacher. thank you so much for your support. :)
You are welcome!
Is there any way to format the input numbers while typing values in the TextInput ,instead of having label to show the format numbers
Nope. 😑
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?
Nope, sorry
Thank you so much Shane ! How do i put the currency in the right side of the number ?
I haven’t tried. Hmmm
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?
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?
Correct. Text function outputs text so can’t write it to number column.
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?
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.
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
You would need to do it into another label like I show here. There is no mask feature in Power Apps
Thx :D
I love it, very useful. Thanks
Glad it was helpful!
Thank you Shane, you made my day ... again :-)
Glad to help. 😀
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?
I would like to know this as well
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
Sorry I don’t understand the question
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
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.
@@ShanesCows i tried but doesn't work. Thanks anyway
Hey, just wanted to check if you were you able to fix the issue? TIA
Thanks! Very helpful!! I applied this to a dataCard and it didn't work. Any suggestions?
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), "$#.#")
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?
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.
Thank you. I knew I had to be missing something simple.@@ShanesCows
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
Do you know what language that is the standard for? Try Text(12345, “#,###”, “thatLanguage”) and it should work.
@@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
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?
Don’t know how to do that. Sorry
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!
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
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 $?
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!
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...
Practice saying 1000 separator 100 times :P. Great Video Shane as always.
Tongue twister 🤪
hi there! this work with a sharepoint list in numer format? thx
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?
Hey, just wanted to check if you were you able to fix the issue by adding en-US?
@@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!
I appreciate you so much!!!
Thanks Shelby! 😎
Thank you! I used the the Value() to convert number to military hours.
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...
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.
Hi Shane can you make video on how to convert 32 to Thirtytwo
I don't have an easy answer for that one.
Thank you, now I can format on my country currency 😁😁😁
Absolute legend!
thanks so much
You're welcome!
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)?
Off the top of my head I think If is the way to go. 😎
Julio you ended up inspiring todays video. A different way to think about this problem. I hope it helps. th-cam.com/video/ruRDG-xCbKs/w-d-xo.html
@@ShanesCows Great ! thanks for tips. This works great.
Thank you! It *SHOULD BE* right click and select on value > currency and the code would update accordingly.
That would be nice!
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.
Not that I know of. :(
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
Noted Mo. thanks 😊
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')
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
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.
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
hii, u find the way to do this?
Amazing, thanks!!!
how to change number automatic ?
I Fuckn Love you man , I really fucken do.
stay awsome my guy!
Appreciate that. 😎
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.
thank you so much
Welcome 😊
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
Hi, Shane! Thanks for your informative videos. Kindly share the currency format for India. "##,##,###.00" is working as "#,###,###.00"
thank you
You're welcome
Hello Shane, I've got a gallery that is being used as an editable grid (th-cam.com/video/76RJyaoW0BQ/w-d-xo.html) - 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.
Hello Shane, there is an addition to your video I would like to share... th-cam.com/video/povxwFZ4yik/w-d-xo.html, it would be nice to see the entry formatted at least when you finish typing the text