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.


Report
All responses (
Answers (