cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Variable as default value for Data Card doesn't refresh

Hello everyone!
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:

 

Set(varCateringCost;
Text(Value(DataCardValue1.Text);"[$-de-DE]€ ###.##0"))

 

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:


Set(varCateringCost;
If(IsBlank(DataCardValue1.Text) || DataCardValue1.Text = "" || IsEmpty(DataCardValue1.Text);
Text(Value("0");"[$-de-DE]€ ###.##0");
Text(Value(DataCardValue1.Text);"[$-de-DE]€ ###.##0")))


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!

3 REPLIES 3
Highlighted
Impactful Individual
Impactful Individual

Re: Variable as default value for Data Card doesn't refresh

Scrap the variables, reset it to how it was and put a label next to the input field with “€” in it,
If you want to be really clever you can put a rectangle around it all (position behind) to put a border around the whole lot so it appears as one box
Highlighted
Community Support
Community Support

Re: Variable as default value for Data Card doesn't refresh

Hi @Anonymous ,

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:

If(IsBlank(DataCardValue1.Text),0,Value(DataCardValue1.Text))

In this way, you could make sure that the update value is right.

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: Variable as default value for Data Card doesn't refresh

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? 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,895)