How to Update Calculated Column value to another field

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

All responses (7)

Answers (1)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Perumal 604 on at

Like
a
(0)

Report
Copy link

Link copied!

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)})
hpkeong 2,944 on at

Like
a
(0)

Report
Copy link

Link copied!

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).
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

murali Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks all for helping