Announcements
Here is the form fields and associated text fields.I have tried to convert both number and text to show the value as US currency but without success.How can I display the $ sybol.
Thanks!
Text(1000,"0,0.00$")
replace 1000 with your value reference.
Hi @golfnutt82 ,
Easiest way is to use an ampersand, for instance:
"$ " & ThisItem.Value
So this works for a label control but not the actual text input box that is associated with the currency field in SharePoint. "$ " & Text(DataCardValue75,"[$-en-US]0.00")
If this is a text input the user is typing into and you want it to always show a $ after they type into it you have to do something like settign its default to Switch(moneyVar, Blank(),Blank(), moneyVar) and then its onChange to something like UpdateContext({moneyVar: Text(Value(Self.Text), "0,0.00$")}) that shoudl have a blank default before they type, and after they type update the control to show what they had typed, but converted to money format
Is there a way to do a sum of all text fields and display the result in a label?
Is there a way to do what what you are showing but with a sum of fields?
where I have text inputs 2-5,
Text(Sum(TextInput2,TextInput3,TextInput4,TextInput5), "$0,00.00")
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 224 Super User 2026 Season 2
WarrenBelz 189 Most Valuable Professional
Mohsin Ali 126