Power Platform Community Forum Thread Details

I'm having issues with a text input field that doesn't update in excel. I did make some changes to the format of the text input field default property with the following "Text(Value(Parent.Default),"$#,###","en-US")" When I submit a form, the data doesn't update, nor does anything appear. Within that field the formula in excel is =IF(ISBLANK(F2),E2,F2)-G2. The formula seems to prevent the data to come through, but I still need to the format to change on the form when submitted. When I set the Default value back to "Parent. Default", The formula works fine and the form updates with the correct value. How can have this text input keep the format I placed in the default property as well as utilize the formula I placed within excel? I text input filed will be set to View only. The text input is based on the Excel cell that contains a formula.