Power App Monitor getting thousands of record

[Johany_Navarro]

Hi, Power apps legends.

My end-users have been complaining about the performance of my app, checking the monitor I noticed that a patch function is getting thousands of rows, as you can see the ID 1 is the click action on the button however the actual response is the ID 1569 WTH!! 

The patch function is below.

If(
    IsBlank(ProcessesGallery.Selected.EditingBy),
    //TRUE VALUE EDITING BY IS EMPTY
        Patch(
            SharePointList,
            //ProcessesGallery.Selected,
            {ID: ProcessesGallery.Selected.ID},
            {EditingBy: Text(User().FullName)},
            {LockedAt: Now()}
        );
        If(
            IsEmpty(Errors(SharePointList)),
            //TRUE VALUE NO ERROR
                Notify(
                    "Client was locked successfully",
                    NotificationType.Success,
                    2000
                );
                Set(
                    Process,
                    ProcessesGallery.Selected
                );
                Navigate(
                EditFormScreen
                ),
            //ELSE VALUE NO ERRORS
                Notify(
                    First(Errors(SharePointList)).Message,
                    NotificationType.Error,
                    2000
                );
                Patch(
                    SharePointList,
                    ProcessesGallery.Selected,
                    {EditingBy: Blank()},
                    {LockedAt: Blank()}
                )
        ),
    //ELSE VALUE EDITING BY IS EMPTY
    Notify(
        "This process is being edited by " & ProcessesGallery.Selected.EditingBy,
        NotificationType.Error,
        2000
    )
)

Furthermore, I noticed that the control called ErrorMessage32_4, which is a label, in the record 1572 is placed on another screen so why it's coming up here??

Any help would be appreciated!!

[zmorek]

I think it's the Errors() function causing the delay, because it returns a table of errors based on the data source, and each time it's called, I would wager that it's checking the entire data source for errors (e.g. all records and columns, then gathering the error message/code for each one).

I also think in regards to ErrorMessage32_4's label, that it might be referencing a control on the other screen.

[Johany_Navarro]

Hi @zmorek, thanks for taking the time for this.

Any idea how to avoid that? cause I have plenty of Errors() function in my apps however only that one is acting like that. The ErrorMessage32_4.Visible formula is below.

If(
    !IsEmpty(
        Filter(
            SharePoint list, 
            ProjectNo = cbProjectCodeNew_1.Selected.ProjectID)
    ),
    true,
    false
)

Do you think the cause is related to the same SharePoint list?

[zmorek]

I'm not entirely certain it's the Errors() function, but it was my first stab at trying to think of something causing it! Can you try removing the Errors() from the patch, and/or breaking the patch down into its individual parts, and see if any of them individually is causing the delay?

For ErrorMessage32_4, is cbProjectCodeNew_1 on the same screen as ErrorMessage32_4?

[Johany_Navarro]

Hi @zmorek , I modify the logic of ErrorMessage32_4.Visible and it worked so that's fixed however when I click on a list's item I still get thousands of records on the monitor.

Would you mind having a look at the exported .csv from the Monitor? I literally don't know where to start debugging 😑😑😑

[zmorek]

The majority of those records appear to say that 316 records are getting a blank value passed into it, specifically a bunch of labels such as 

lbDocumentsPickedUpOnAdminVew

lbMBRSubmittedAdminVew

lbAssembledOnAdminVew

lbDocumentsPickedUpOnAdminVew

lbDocumentsForwardedToPartnersAdminVew

That's not causing a performance hit though, there's no response size for that. I've gotten that warning in the monitor a few times, for example, when I have a control in a gallery that references a column in a record with nothing in it. I ignore it; costs nothing.

Best I can guess is whatever results in those labels' formulas, at the time, has no value to return.

[Johany_Navarro]

Hi @zmorek it's me again 😁

I have been trying to find out what is affecting the performance.

UpdateContext({varStart: Now()});
Patch(
        'Core Services Automation',
        ThisItem,
         //TaxProcessesGallery.Selected,
         //{ID: TaxProcess.ID},
         //TaxProcess,
        {
            EditingBy: Text(User().FullName),
            LockedAt: Now()
        }
    );
UpdateContext({varEnd: Now()});UpdateContext({varTime: varStart - varEnd})

I created two variables to know exactly how long the Patch() takes and surprisingly it takes almost nothing 😯😯 so the problem is not the Patch() (I think) however my app keeps on loading something (no clue what) for around 10 seconds before it navigates to the screen

Perhaps this gives you an idea, I am just testing around any crazy or silly ideas that comes to my mind but no improvements 😫

[Johany_Navarro]

an update, no success yet 🤐

I created a blank app, connected to the same Sharepoint list, inserted a button, and OnSelect I wrote exactly the same Patch() function and it worked perfectly it didn't take that long 

[Johany_Navarro]

@RezaDorrani @WarrenBelz @RandyHayes @ShaneYoung I beg your help Power Apps legends 😯😯.

I also found this post with a similar issue

Power App broke - Monitor showing thousands of lin... - Power Platform Community (microsoft.com)