How to Update Calculated Column value to another field

(0) Share

Report

Posted on by Community Power Pla...

I have field A and field B calculation is field A* Field B and update value to Field C how to do this in powerapps.

My calculation is correct but the value not update into excel in OneDrive.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

v-yamao-msft on at

Like (0)

Report

Hi KasunPathirana,

I have an Excel file saved in OneDrive and it has been formatted as a table. I have three columns in the table: Number1, Number2, Total.

In the App, I connect to data to the Excel file. Then add two Text Input controls and a Text Box control, and a button on a screen.
>About the Text Box, I set its Text property to:
TextInput1.Text*TextInput2.Text

>About the Button, I set its Onselect property to:
Patch(Table2,Defaults(Table2),{Number1:TextInput1.Text,Number2:TextInput2.Text,Total:TextBox1.Text})

When I click the button, all the data would be written to the Excel file saved in OneDrive. Please try if this works for you.

Best regards,
Mabel Mao

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

Like (0)

Report

Thanks for the reply MabelMao I do not use a button to update I want two text fields and behind the scene update the 3rd field with result and to update OneDrive excel file relevant field too. How should i do it.

Was this reply helpful? Yes No
Perumal 604 on at

Like (0)

Report

You can just move the Patch() function mentioned by @v-yamao-msft to the text property of TextBox3 and try as below.

For the 3rd text box use the formula:

Value(TextInput1.Text)*Value(TextInput2.Text); Patch(Table2,Defaults(Table2),{Number1:TextInput1.Text,Number2:TextInput2.Text,Total:Value(TextInput1.Text)*Value(TextInput2.Text)})

Was this reply helpful? Yes No
hpkeong 2,944 on at

Like (0)

Report

Hi

In fact, what MabelMeo sugeested was a normal and straightforwad practice.
If you wish, you may have:
On.Hidden = If(TextInput1*TextInput1_1.Text > 0, Patch(Table1, Defaults(Table1), {Qty: TextBox1.Text}))
(That means, when you navigate away from the screen, this behavior formula will fire, to replace BUTTON.OnSelect).

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

Like (0)

Report

Currency Amount - I have use DataCardValue18
Exchange Rate - I have use DataCardValue21
Amount (SGD) under Text Property I tried to use above function but was not successful only how do i incorporate and update table 2 is the source and update to the Amount (SGD) column.

Was this reply helpful? Yes No
Verified answer

murali on at

Like (0)

Report

You could do one of the following:
1. Set Amount.Default = DataCardValue18 * DataCardValue21. This however assumes that Amount.DataField is bound to a field in the datasource. You can do that by setting DataField of Amount card to Total
2. Patch(DS, Defaults(Table2), {...Total: DataCardValue18 * DataCardValue21}).

Hope this helps.

Murali

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

Like (0)

Report

Thanks all for helping

Was this reply helpful? Yes No