Server Response: "AppName" Request to the backend service timed out

(1) Share

Report

Posted on by PowerAppsMinkZ

Hello,

I get this error An error occurred on the server. Server Response: Request to the backend service timed out on this one App I have created.

The Issue occurs within my ClearCollect in OnStart Property.

And it only occurs when my ClearCollect has a sortByColumn property assigned to it

ClearCollect(
    InitialHSEList,
    SortByColumns(
        ShowColumns('HSE Incident Report', ID),
        "ID",
        SortOrder.Descending
    )
);
 
This will cause the app to error and not respond, where just donig a normal clear collect does not.
 
ClearCollect(
    InitialHSEList,
    'HSE Incident Report'
);
 
All my other apps I have created have sortByColumns and work absolutely fine. What is happening to my app? 

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

BhargavPatel 660 Moderator on at

Like (1)

Report
Copy link

Link copied!

PowerAppsMinkZ How many records are in the 'HSE Incident Report'?

Are the number of records same range as other apps where similar Power Fx has worked fine?

What is the reason for Sorting before collecting? Can you collect and then sort? Also, if you are trying to get around the delegation limits by sorting in descending order to get the newest records, then you need to Sort first and then use ShowColumns because ShowColumns is a non-delegable function,

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

let's clarify, the SortByColumns, in and of itself, is not to blame, it is simply something that depending on how it is used, and how many records and delegation issues, can cause this

1) is your App.OnStart set to Async or not (in the settings)

2) How many records are in the table/list?

3) How are you displaying these records? In a gallery? or a datatable?

Why do you have to load these into a Collection? (at all)?

Since collections are not visible, your need to sort, is that because you want to sort them so when you assign them to a Control, they are pre-sorted?

If so, don't, leave the sorting to within the components Items property

Also, you should remove this from your App.OnStart anyway and move it into the OnVisible property of your first Form. If you have too, add a Splash screen letting them know you are loading data.

Was this reply helpful? Yes No
PowerAppsMinkZ 19 on at

Like (0)

Report
Copy link

Link copied!

1) is your App.OnStart set to Async or not (in the settings)
Not sure, I can't find the option for Async

2) How many records are in the table/list?

About 2700

3) How are you displaying these records? In a gallery? or a datatable?
In a Gallery

Running the same Collect on any canvas, gives me 0 Rows, I added the sharepoint list to a new canvas. Ran a ClearCollect(Test, SharePoint List)

I get this error when trying to display the List on a Gallery

Was this reply helpful? Yes No