I have an edit form that is displaying different monetary values. In order to show them in correct formating, I have set the default values to variables like "varCateringCost". The onchange property is then set to:
This works absolutely fine with all cases except of one:
If I change from 200 to 300, eg, it correctly displays € 200 and then € 300.
However, I realized, if I completly delete the text inside the input field, it looks to the user as if it was blank, but it still patches the old value to the sharepoint list. I created a workaround:
If(IsBlank(DataCardValue1.Text) || DataCardValue1.Text = "" || IsEmpty(DataCardValue1.Text);
This works fine the first time. For example, changing fom € 300 to empty, it is displaying € 0 and thus should also patch 0.
However, if I remove "€ 0" again, the field is just staying empty. I tested the value of the variable outside the data card. The value seems to be "€ 0". This however is not correctly displayed inside the data card. I assume, the variable varCateringCost, which is the default value for the datacardvalue1 field, is not refreshed properly. Does anyone have an idea what to do? I am absolutly open for different ways of solving this. The only thing I need is the correct submission of an empty or blank field to the sharepoint list. Thanks a lot in advance!
Hi @anotherlama ,
I've made a similar test and met the same problem.
I've reported this issue to our product team. If there's any replay, I will leave message here.
Firstly, I suggest you separate number and "$" like @Delid4ve said. Then you could avoid the situation of not display "$".
Secondly, I suggest you not use variable to justify whether the textinput has value. Then you could avoid the default value becoming blank.
You could set this field's UpDate directly:
In this way, you could make sure that the update value is right.
hi @Delid4ve and @v-yutliu-msft !
thanks a lot for your response!
However, the currency formatting with "###.###" and the currency sign "€" need to be included. Especially the dot between the thousands digit and the hundreds digit. If I continue as suggest, I think the formatting is not happening anymore. Is that correct? Any ideas what else I could do?
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications