Re: Retrieve and update a number in an excel cell
@Flowbginner
Yes, you can do this. Take a look at my table below. There are two columns ID and Value. Every value you want to call from the table must have a unique ID. In this case the unique ID is 1.
Create a new label and change the Text property to the following code.
LookUp(
your_datasource_name,
ID=1,
Value
);
The label will now display this
50
To update the number in your Excel spreadsheet you'll have to create 2 new controls: a Text Input (TextInput1) and a Button (Button1).
To update the value in your spreadsheet we must tell PowerApps what to do when the button is clicked. Put the following code in the OnSelect property of the Button.
Patch(
your_datasource_name,
LookUp(your_datasource_name,ID=1),
{Value: TextInput1.Text}
);
Write a number in the Text Input and click the button. It will update the value in your spreadsheet. If you want the change to be immediately reflected in your label make sure to Refresh the datasource.
Patch(
your_datasource_name,
LookUp(your_datasource_name,ID=1),
{Value: TextInput1.Text}
);
Refresh(your_datasource_name);
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
