Hello,
I have another question that I can't seem to find an answer to. I have a calculated value in a text box based on users choices in drop down menus. The value needs to be expressed as a dollar value inside that text box. I tried using the Excel DOLLAR function but PowerApps didn't seem to recognize it. I see in apps generated as examples that it seems to show a calculated value in the format I require so I know its possible...I just don't know how.
As an aside, I would like to suggest that the examples posted by MS are allowed to be viewed in an editable state so that others can learn by deconstructing the examples.
Thanks for your help!
Solved! Go to Solution.
Hi Tdorscher,
If I understand your scenario correctly, I guess you should use a Text function to format the value as a dollar value.
My steps for a reference:
Add two Drop down controls, set Items property as [“1”,”2”,”3”,”4”].
Add a Text box control, set its Text property as Text(Dropdown1.Selected.Value*Dropdown2.Selected.Value,"[$-en-US]$ ###.##").
Then when values are selected from Drop down controls, a dollar value would be calculated and shown.
For more details about Text function, please see this article:
https://powerapps.microsoft.com/en-us/tutorials/function-text/
when we configure a function, there would be a prompt about how to enter values. Likes the screenshot:
You could also submit an idea about this if it doesn’t meet your needs at PowerApps Ideas Fourm:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas
Best regards,
Mabel Mao
Hi Tdorscher,
If I understand your scenario correctly, I guess you should use a Text function to format the value as a dollar value.
My steps for a reference:
Add two Drop down controls, set Items property as [“1”,”2”,”3”,”4”].
Add a Text box control, set its Text property as Text(Dropdown1.Selected.Value*Dropdown2.Selected.Value,"[$-en-US]$ ###.##").
Then when values are selected from Drop down controls, a dollar value would be calculated and shown.
For more details about Text function, please see this article:
https://powerapps.microsoft.com/en-us/tutorials/function-text/
when we configure a function, there would be a prompt about how to enter values. Likes the screenshot:
You could also submit an idea about this if it doesn’t meet your needs at PowerApps Ideas Fourm:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas
Best regards,
Mabel Mao
So first I want to say thank you so much for your help! That was what I needed however the ###.## format will only show one decimal place. I found that if I change it to ###.00 then it in fact will show two decial places. Again I wouldn't have even known where to start with that. Thanks so much!