Power Apps

Refreshing my dataset resets my texinputs inside the Gallery!

(0) Share

Report

Posted on by Calcioscacchi

413

Hi there,

1)I have a gallery linked to a Sharepoint List which works as input dataset.

2)The gallery contains a TextInput that I use to set some parameters to record in another list (target dataset)

3)In the TextInputs, the operator has to write some percentages.

4)I need to refresh the input dataset because tha materials could change and the operator who reads this informations must know it. So I setted a timer and every 5 mins the dataset is refreshed.

The problem is that when I refresh the input dataset, the TextInputs is resetted to default value which is "".

I don't want this: If my dataset is refreshed, TextInputs must stay still with the values that I've inserted before.

For example, If I set the TextInputs with 20, 20, 30, 15, 95, 5, then I Patch the informations in the target dataset, the TextInputs don't change and they remain valued as I setted.

In 5 minutes the input dataset will be refreshed and the TextInputs are resetted to blank value:

But also If the input dataset is refreshed, I need this situation again:

Do you know some methods to avoid this behaviour?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

timl 36,411 Super User 2025 Season 2 on at

Like (0)

Report
One way to do this is to store the percentage values that the user enters in a collection.

In the OnChange property of the percentage text input control, you would add the following:

Collect(colPercentages, {colID: ThisItem.ID, Percentage: txtPercent.Text})

You would then set the Default property of your text input control to the following.

LookUp(colPercentages, colID = ThisItem.ID).Percentage

The text input control should then retain the value after a refresh.

Was this reply helpful? Yes No
Mark Nanneman 991 Super User 2025 Season 2 on at

Like (0)

Report

@timl's suggestion is good. You could also make Percentuale a column on the source database (if it isn't already) and set it to display the value you from the database as default. Then you could set the "OnChange" property of the Percentuale TextInput control to Patch an update to the datasource for that record. Something like "Patch(yourDataSource, ThisItem, {Percentuale: Value(Self.Text)})

Was this reply helpful? Yes No
Calcioscacchi 413 on at

Like (0)

Report

timl Mark Nanneman

Thanks for your replies.

Collecting the input data could be nice, but i'll put that in the button used to patch the values in the destination dataset in order to use the "ClearCollect" function.

Putting something different to "" in Default Values could be tricky: I tried it previously in a similar way, and when I try to patch new values, sometimes it fails. I?ll keep you updated.

Was this reply helpful? Yes No