You’re offline. This is a read only version of the page.
146
Hopefully I explain this right.
I have a simple Sharepoint list as a data source. Several of the fields are currency fields. They don't play too nicely in a Power App.
I have a "manual" form in a Power App (manual meaning its text fields powered with Patch statement. No datacards). All of the field defaults are coming from varRecord. varRecord will have data depending on if the user hits a "New" or "Edit" button. From what I can tell, this is pretty much standard for a Power App and using Patch.
My issue is with the currency fields. I'd like to have it when entering, for example, "4" in a text field, something will trigger (maybe OnChange?) that will display it as $ 4.00. This seems like it would be simple, but can't quite get it.
I do have the Default property for UnitCost as "Text(Value(varRecord.UnitCost),"[$-en-US],$#,###.00")" , and this will work when the field already has data. But when changing / adding new data, this formula does nothing.
You could try setting a variable in the onchange property that sets the value that was written by the user in a variable
after setting the variabel reset the inputbox. Then in the default value of the inputbox set the variable with desired formatting. Not very pretty but it works.
Share
Report
All responses (
Answers (
