Data corruption

[Thomaw]

Hello,

I have a problem of corruption of my connected source file and I can't debug 😫

It's a connection with Excel Onedrive and I don't know how, but every now and then Power apps mixes up my table data

Basically my file looks like this :  

And after corruption, some information is mixed :

So in the principle of operation of my app, the user uses the "tick" icon which puts the information of the item in variables

Set(BloquePICKIDClick;ThisItem.PICK_ID);;
Set(BloqueCutOffClick;Text(DateTimeValue(ThisItem.CUT_OFF_DATE); "dd/mm/yyyy"));;
Set(BloqueCutOffTimeClick;Text(DateAdd(DateAdd(ThisItem.CUT_OFF_TIME;-9;Minutes);TimeZoneOffset());"hh:mm"));;
Set(BloqueREF1Click;ThisItem.ARTNO2);;
Set(BloqueQTYClick;ThisItem.OPEN_PICK_QTY);;
Set(ValideNO2;ThisItem);;

//Ouvre la boite de dialogue
Set(DisplayPopupValideClick; true );;

//Reset le timer
Set(ResetTimerValideClick; false);;
Reset(Timer1_3);;
Set(ResetTimerValideClick; true);;
Set(StartTimerValideClick; true );;

It opens a multi-choice window for him to choose his action (DisplayPopupValideClick) and each action writes something different in the connected file

3/ Bloquer

Set(StartTimerValideClick; false);;
IfError(
    Refresh(Click);;
    Refresh(Truck);;
    Refresh(JIT_Liste_Mail);;
    Refresh(Traités);;
    Refresh(Version);;

Patch(Click;ValideNO2;{Nom_preparateur:"Bloqué Click "&User().FullName & Text(Now();" le dd/mm à hh:mm");Etat:"Bloqué"});Set(Gestion_Erreur_Visible;true);

Patch(Traités;{ID: BloquePICKIDClick;CutOffDate: BloqueCutOffClick&" "&BloqueCutOffTimeClick;RefAlerte1: BloqueREF1Click;QTY:BloqueQTYClick;Nom:"Bloqué Click "&User().FullName & Text(Now();" le dd/mm à hh:mm");Nom_Pick:User().FullName;Date_Pick:Text(Now();"dd/mm/yyyy hhmm");Etat:"Bloqué";Type:"Click"});Set(Gestion_Erreur_Visible;true);

Notify( "Juste In Time impossible à faire, il sera grisé jusqu'au Cut OFF";NotificationType.Success;4000));;

Set(DisplayPopupValideClick; false);;

2/ Traiter

Set(StartTimerValideClick; false);;
IfError(
    Refresh(Click);;
    Refresh(Truck);;
    Refresh(JIT_Liste_Mail);;
    Refresh(Traités);;
    Refresh(Version);;

Patch(Click;ValideNO2;{Nom_preparateur:"Traité Click "&User().FullName & Text(Now();" le dd/mm à hh:mm");Etat:"Traité"});Set(Gestion_Erreur_Visible;true);

Patch(Traités;{ID: BloquePICKIDClick;CutOffDate: BloqueCutOffClick&" "&BloqueCutOffTimeClick;RefAlerte1: BloqueREF1Click;QTY:BloqueQTYClick;Nom:"Traité Click "&User().FullName & Text(Now();" le dd/mm à hh:mm");Nom_Pick:User().FullName;Date_Pick:Text(Now();"dd/mm/yyyy hhmm");Etat:"Traité";Type:"Click"});Set(Gestion_Erreur_Visible;true);

Notify( "Juste In Time traité (stocké), il sera grisé jusqu'au Cut OFF";NotificationType.Success;4000));;

Set(DisplayPopupValideClick; false);;

1/ Confirmer

Set(StartTimerValideClick; false);;
IfError(
    Refresh(Click);;
    Refresh(Truck);;
    Refresh(JIT_Liste_Mail);;
    Refresh(Traités);;
    Refresh(Version);;

Patch(Click;ValideNO2;{Nom_preparateur:"Fait Click "&User().FullName & Text( Now(); " le dd/mm à hh:mm");Etat:"Fait"});Set(Gestion_Erreur_Visible;true);

Patch(Traités;{ID: BloquePICKIDClick;CutOffDate: BloqueCutOffClick&" "&BloqueCutOffTimeClick;RefAlerte1: BloqueREF1Click;QTY:BloqueQTYClick;Nom:"Fait Click "&User().FullName & Text(Now();" le dd/mm à hh:mm");Nom_Pick:User().FullName;Date_Pick:Text(Now();"dd/mm/yyyy hhmm");Etat:"Fait";Type:"Click"});Set(Gestion_Erreur_Visible;true);

Notify( "Juste In Time confirmé (validé avec le RDT), il sera grisé jusqu'au Cut OFF";NotificationType.Success;4000));;

Set(DisplayPopupValideClick; false);;

My connected Excel file is updated via a VBA macro every 2 hours which causes the power apps ID to change or the error handling (IfError)(Set(Gestion_Erreur_Visible;true)) in case the user is on a not updated gallery

But I can't fix this problem of corruption of my file which is punctual (from time to time)

So is this a known problem, or I have a problem in the functioning of my application

If someone can help me, I've been on this for days.

Thanks in advance

@R3dKap  Si tu passes par la et que tu as le temps de m'apporter ton expertise 😉

[Drrickryp]

@Thomaw 

There are many ways for an Excel data source to be corrupted.  Please see @Shanescows 's  video about why Excel is a terrible data source.   https://www.youtube.com/watch?v=RtmZM3tm2Zs 

[Thomaw]

Hello and thank you for your answer @Drrickryp 

I want to hear it  when sending data from Power Apps to Excel you cannot have it open or if you work with a lot of lines in your data source you will have problems with delegation...

But to corrupt the data, It wouldn't even be a bug but it would be a big malfunction and I don't think Microsoft allows such a thing.

Also knowing that I have several Power apps connected to excel files and that I do not have this problem

I honestly think it's more about how my app works