Answered

Update gallery data with Save button "Excel"

(1) Share

Report

Posted on by ASH3

111

I'm facing small issue. I have vertical gallery with editable controls so it is looks like excel each row has save button.

save button has this code "I'm testing only one column" :

Patch( Table1,ThisItem,{Column1:TextInput8_17.Text});

Notify("Data updated successfully!", NotificationType.Success);

Refresh(Table1);

it is already update in excel and in the gallery " for second" and it returned back to the old data but in excel it has the new data. and it require me to refresh the data manually. so I think I need to add delay before refreshing the data, but I don't know how much.

note that I have 14 columns that the user can edit so I will add them to the code later after solving this issue, but I'm not sure if the delay will be extended or not.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Copy link

Link copied!
hi @ASH3 ,
The issue you are facing with the gallery updating and then reverting to the old data temporarily is likely due to the time it takes for the data to be patched and then reflected back from Excel. Adding a delay before the Refresh should help, but instead of guessing the delay time, it would be better to wait for the operation to complete.

Patch(Table1, ThisItem, {Column1: TextInput8_17.Text}); Notify("Data updated successfully!", NotificationType.Success); // Introduce a delay Timer1.Duration = 2000; // 2000 milliseconds = 2 seconds Timer1.Start();

Add a timer control (Timer1) to your screen.
Set the timer properties as follows:
Duration: 2000 (for 2 seconds)
AutoStart: false
Repeat: false
Add this code to the OnTimerEnd property of the timer:

Refresh(Table1);

Was this reply helpful? Yes No
ASH3 111 on at

Like (0)

Report
Copy link

Link copied!

Hi @anandm08
Thank you so much !!

Was this reply helpful? Yes No