cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Thomaw
Helper III
Helper III

Data corruption

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 :  

Sans titre.png

 

And after corruption, some information is mixed :

Sans titre2.png

 

 

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

FireShot Capture 048 - Power Apps - make.powerapps.com.png

 

 

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

 

FireShot Capture 050 - Power Apps - make.powerapps.com.png

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 😉

2 REPLIES 2
Drrickryp
Super User
Super User

@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 

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,409)