why the changes are not saved in excel file ?

[Akki2995]

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 ?

[SebS · Accepted solution]

@Akki2995 

Here is what I use to check this for You :

Gallery Item property colKapa

I create the colKapa in button Update Collection :

The only difference is I do not pre filter it and sorting it

Now in the Gallery OnSelect :

I'm Patching fields to the collection

The InputText Fields are set up OnChange property:

Select(Parent)

DisplayMode Property :

If(!varGridEdit1,DisplayMode.Edit,DisplayMode.Disabled)

Now the last Edit / Update button set up

Nothing fancy variable trigger to change name of the button and trigger Patch to Table than I refreshing collection by pulling new data from table

Set(varGridEdit1, !varGridEdit1);
Patch(Table2,colKapa);
ClearCollect(colKapa,Table2)

Last Text Property:

If(!varGridEdit1,"Update","Edit")

try to replicate this and if this will not work disconnect Excel connector and  re connect it again.

Everything You see above working without any issue 

[Akki2995]

how can still filter the data ? it is important because there several employe

[SebS]

@Akki2995 

Filtering is not a problem, real question is if it start working ?

[Akki2995]

it worked with another table but not with this,

do not know why

[SebS]

@Akki2995 

this is Excel as Data Source for You, there can be some error table crashed Power Apps leaving some staff behind and now you are having all sort of issues.

To sort this out create new spreadsheet with new table transfer data that table and connect it to App most of the times this will sort all small challenges.

I do recommend work with SharePoint List create list base on Your excel file that can also transfer all data from it direct to the list, and work using that list what is less complicate also allows for much more options.

[Akki2995]

it worked now 🙂

Thank you

[Akki2995]

what was the cause of this problem ?

[SebS · Accepted solution]

@Akki2995 

There are few.

1. Excel online Tables like to get corrupted, and when they do best to re-create them in new files.

2. __PowerAppsID__ also likes to get corrupted, and the only way to sort it out is to reconnect connector.

3. In your button You had the wrong order of functions

This is Your original order

If(varGridEdit1;Patch(Kapazität; colKapa));; Select(Button_Kapa_1);;
Set(varGridEdit1; !varGridEdit1)

The variable varGridEdit1 is set after the IF statement so there is an issue when you press it first to execute the IF Setting opposite the variable means not always have the outcome as You expected or any at all it was depending on if you have set somewhere a default of that variable and I did not see any setting like that in your example so always keep set of a variable before IF if IF depends on it.