cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tdorscher
Frequent Visitor

Showing result as dollar value

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!

1 ACCEPTED SOLUTION

Accepted Solutions
v-yamao-msft
Community Support
Community Support

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.

B2.png

 

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:

B1.PNG

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yamao-msft
Community Support
Community Support

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.

B2.png

 

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:

B1.PNG

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,891)