I have an edit form, one of the field "DataCardValue24" is number, I want to display the number in below format
"##,##0.00#"
On default it is
Can we write Text(Parent.Default,"##,##0.00#")
There will no issue for new form, edit form, view form.
Or it should be written in another way.
Applied Text(Parent.Default,"##,##0.00#") and edited an old record, when try to submit form, below is the error
Please guide
@MIA27 ,
The issue is that the data source is expecting a number and you have converted the field to Text. I normally have a Label with the text formatted number visible when the Form is in View Mode and the Text Input with the proper number (what you have now) hidden when the label is displayed.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
WarrenBelz
146,596
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,928
Most Valuable Professional