Power Platform Community Forum Thread Details

Hi All!

I have tried for hours and can't figure this out.

For a field in my form I have an If statement:

If ( 'Form1'.Mode = FormMode.Edit , Text ( Parent.Default , "[$-en-US]$#,###" ) , varPrice2 )

This means If a gallery item is picked, the form will populate that items info in Edit Mode and if not, and a new form is created with a separate button, then varPrice2 will populate. This part works.

Now when I person selects the gallery item it is formatted in currency, when they go to change, say their prices however, the change does not format at all. How can I make the changed price format into currency using my above If statement?

The formula I have for the OnChange property is for the varPrice2 which basically changes the live input to currency format in new formmode:

Set(varPrice2,Text(Value(Substitute(Substitute(DataCardValue2.Text,",",""),"$","")),"[$-en-US]$###,###"))

Thanks in advanced!

Categories:

Building Power Apps