Answered

why the changes are not saved in excel file ?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want to edit a gallery with a tabled called Kapazität und Monat. And whenever i edit the Kapazität and want to save it, then the changes are not saved in excel. My approach was similar like in this video:

https://www.youtube.com/watch?v=wI6SHGQ9ATg&list=PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU&index=1

I do not know the cause for this problem, i show you as an example:

1. Editing the Gallery and the specific values

2. Click on Beenden to patch the changes of the Collection to the real data source

3. No changes are saved ?

What are the causes ?

Categories:

Building Power Apps

I have the same question (0)

All responses (27)

Answers (2)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

are thereany infos missing ?

Was this reply helpful? Yes No
SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Could You provide Your patch Function Code.

Did You use Monitor Tool to check what happening behind scene.

Are there any errors appearing after patch is done.

Are you making sure the excel file You patching to is close on all devices when you testing the app?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
i did not check the monito tool !
But let me show you what i did with the code details!

1. On change of a field then the OnChange property Select the parent like here:

in this case, it is the Gallery!

2. OnSelect of the current gallery then this function is used:

Patch(colKapa; ThisItem; { Mitarbeiter: DataCardValue15_6.Text; Monat: DataCardValue17_6.Selected.DateMonthYear; Kapazität: TextInput3_1.Text})
so the collection should be updated

3. Then i click on the Beenden Button, which updates the dataset with the collection
The OnSelect function look like this:
If(varGridEdit1;Patch(Kapazität; colKapa));; Select(Button_Kapa_1);; Set(varGridEdit1; !varGridEdit1)

my assumption is that the collection is not really updated well!

Was this reply helpful? Yes No
SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
How You creating :

colKapa

@Anonymous

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
by clicking on the button called "Aktualisieren".
OnSelect, this function runs

Refresh(Kapazität);;ClearCollect(colKapa; SortByColumns(Filter(Kapazität; Mitarbeiter = User().Email); "Monat"; SortOrder.Descending));;

Was this reply helpful? Yes No
SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

I replicate this and on my end it's working without an issue. Your theory about collection may be right.

To check that theory You could replace Patch to collection with Direct Patch to Data Source in Gallery and see if Direct patch will result in Record change in Table direct.

Patch(Kapazität, ThisItem; { Mitarbeiter: DataCardValue15_6.Text, Monat: DataCardValue17_6.Selected.DateMonthYear, Kapazität: TextInput3_1.Text})

In Your gallery OnSelect try above after change open Your Excel and see if Patch worked or check if no error show up when you patched

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

yeah it changed the value in the excel file

What should i do next ?

Was this reply helpful? Yes No
SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

So we know the connector works also all your controls work 🙂

but for performance You should still use collection and Patch Collection after You change grid View mode give me 1 hour I have a meeting at work and I digest all and look after meeting where You have and error what stopping collection to update and than Patch to Data Source.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

but there is still an issue with the connector. If i edit the second item in the gallery and save it then only the first row in the excel file is changed by that action not the actual one !

Was this reply helpful? Yes No
SebS 4,867 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Try to remove Table and add it again it's looks like You __PowerAppsId__ may be corrupted and this column is used to determinate witch Item should be updated if its corrupted most likely always first Item no matter what will get an update.

Was this reply helpful? Yes No