Unanswered

Reset Values Button in TextInput

(0) Share

Report

Posted on by jha95

Hi everyone!

I'm trying to add a "Reset Values" button to reset the values in TextInput item. My TextInput item has the formula ThisItem.Value and I want to change -0.07 by -0.1, for example, and after click Reset Values button, it changes by -0.07 (predeterminated value).

Is it possible?

Thank you very much.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @jha95

Can you share more details about the implementation, do you want to reset to old value when user changes it or do you want to round it off?

If you want to reset the control, then you can add below code to the button and the text input control:

Button -> OnSelect -> Set(ResetControl,true);Set(ResetControl,false)

TextInput -> Reset -> ResetControl

Please share more details so that we might help you better.

Hope this helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
jha95 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your fast answer!

I'm reading parameters values from an Excel file, for example, -0.07. I can change this value and save it in the Excel but I want to click in the "Reset Value" button and set the predeterminated values as -0.07. By the moment I created another sheet in Excel which has the predeterminates values of the parameters I want to set.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @jha95

Did you try out with the expressions I suggested in my last reply?

This will reset the control to its default value. The value, that is passed in the Default property of the control.

Button -> OnSelect -> Set(ResetControl,true);Set(ResetControl,false)

TextInput -> Reset -> ResetControl

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
jha95 12 on at

Like
a
(0)

Report
Copy link

Link copied!
It works perfectly!

But I have a problem... If I change the value, save and execute my App -> OnStart, the "predeterminated" value is the changed one and I want to set back the predeterminated value -0.07 that I have in another sheet ("Predeterminated values Sheet").

I did this:
Open the App -> It execute OnStart -> Load the Excel data
Change the predeterminated value: -0.07 by -0.09
Save it
Click in Reset Values button -> Change -0.09 by -0.07
This part is OK.
But I want to do this:
Open the App -> It execute OnStart -> Load the Excel data
Change the predeterminated value: -0.07 by -0.09
Save it
Close App
Two hours later, for example, Open the App -> It execute OnStart -> Load the Excel data
Now the predeterminated value is -0.09 and if I execute the Reset values button it doesn't change this to -0.07
I'm trying to find the way to put back -0.07.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @jha95

To achieve this, change the config as:

Reset Button -> Set(Showpredeterminated,true)

TextInput -> Default -> If(Showpredeterminated,Lookup('Predeterminated values Sheet',ColName = "Value1").Col2, Exising Expression to get last saved value)

Here, Col2 is the name of column which holds predetermined value and ColName and Value1 is used to identify the record in Predeterminated values Sheet.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
jha95 12 on at

Like
a
(0)

Report
Copy link

Link copied!

My data origin is given by a flow, so I can't write 'Predeterminated Values Sheet' in the lookup sentence...

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jha95

To get data from the sheet, you need to add a connection. Can you please share more details about the logical flow here? Maybe through some screenshots and example. The thing here is if this -0.7 is a fixed value, you can set this directly in the default property, otherwise either you need to connect to this other list or return this key from the flow you mentioned in above reply. If you could share more details, we might help you better.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
jha95 12 on at

Like
a
(0)

Report
Copy link

Link copied!

First of all, I have an Excel hosted in One Drive with two sheets: "Parameters Sheet" and "Calculated Sheet".
In my App -> OnStart, I'm reading the parameters of the "Parameters Sheet" with Flow and show it in a Gallery Item.
In the TextInput item, I change the value by -0.09 and save it.
Then, the cell is changed in the Excel file:
Now I want to change -0.09 who is in the TextInput item by the -0.07 value who is in the column "ValorFijo" (predeterminated value) with the "Reset" button.

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jha95 ,

The process that you described is not "Reset" actually.

In excel and PowerApps it will not save the original data.

So if you want to come back to the original data, you could only update again.

Try to set the reset button's OnSelect:

Patch(tablename,ThisItem,{Valor parametro:ThisItem.ValorFijo})

Best regadrs,

Was this reply helpful? Yes No