Answered

Set field value of different Field onChange

(0) Share

Report

Posted on by Community Power Pla...

I've got the following problem:

I have three fields: Gross and Net Values of a purchased item, aswell as sales tax.

As soon as either the Net value or the sales tax (drop down field) gets changed, i want the Gross value to be updated accordingly. The formular would be something similar to [ Net.Text * (Tax.Selected.Value/100+1) ] -> (If any of that formular doesnt make sense to you, I'm from Austria so that might be why). At the end of the day i just need to know how to update the Gross Value field when one of the other changes.

Thank you advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Can you describe how this is currently set up and possibly provide screenshots?

Is Gross an inputText? Is this within a gallery? Is there a reference to this particular item so that you could patch the value directly each time? Is it just a label showing or are you storing the value for Gross?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

I am remodeling an old infopath form. Both Gross and Net Value are input-fields, while sales tax is a dropdown.

I could send screenshots if needed, however the form is in german (So you probably wouldn't understand much) and it won't give you a lot more info than that.

The Components are:
- "Kaufbetrag_Datacard1", where the Net input field is in ("Kaufbetrag")
- "Umsatzsteuer_Datacard2", where Sales tax is in("MwstValue")
- "Kaufbetrag mit Steuer_Datacard", where the Gross input-field is ("KaufbetragMwstValue")

It would also be great if it would be possible in both ways. Meaning that you could either enter Net value and it calculates gross value, or the other way around!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

As additional info, i tried filling in the onChange property of MwstValue with the following code:

Set(KaufbetragMwstValue,Value(Kaufbetrag.Text)*MwstValue.Selected.Value)

But it shows an error on the "KaufbetragMwstValue" part, saying "Unexpected Characters. The formular contains 'Control' where "ident" is expected".

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (2)

Report
Ok, so you don't set control values that way unless you are using variables as their default values - Power Apps is more like Excel, where a cell's formula defines its value, so you might put a formula on Cell A1, and the formula would be B2 + B3

I will include a proof-of-concept app that shows the basic principle, you can open this from within the editor by using the ellipsis, then Open:

So what I've done is:

Set the Default value of Kaufbetrag to gblNet

Set the Default value of KaufbetragMwstValue to gblGross

Set the OnChange property of Kaufbetrag to:

Set( gblGross, If( Len(Kaufbetrag)>0 && Len(MwstValue.Selected.Value)>0, Kaufbetrag.Text * (MwstValue.Selected.Value/100+1) ) );

Set the OnChange property of KaufbetragMwstValue to:

Set( gblNet, If( Len(KaufbetragMwstValue) > 0 && Len(MwstValue.Selected.Value) > 0, KaufbetragMwstValue.Text / (MwstValue.Selected.Value / 100 + 1) ) );

Set the OnChange property of KaufbetragMwstValue to:

Set( gblGross, If( Len(Kaufbetrag) > 0 && Len(MwstValue.Selected.Value) > 0, Kaufbetrag.Text * (MwstValue.Selected.Value / 100 + 1) ) ); Set( gblNet, If( Len(KaufbetragMwstValue) > 0 && Len(MwstValue.Selected.Value) > 0, KaufbetragMwstValue.Text / (MwstValue.Selected.Value / 100 + 1) ) );

This now changes when you change any of the values 🙂

Cheers,

Sancho

Net Gross Price.m...

Was this reply helpful? Yes No