Power App | Canvas - Stopped working

(1) Share

Report

Posted on by CU29092301-0

I have a power app that has data sources from four SharePoint lists. The lists are simple in nature, and the app is set to simply bring back data for a specific user's request that they have submitted on the app. So basically, a search app.

The app had been working fine and then one day, nothing. There is one gallery that sorts and filters all the items in one SP list and returns that data if "All" is selected from the drop down and subsequently there are 10 other status values that can be selected here as well. Nothing is populating and the total is showing 0.

I refreshed all the lists and still nothing returns. I also removed and re-added the main list with no results. It's as if the App is not retrieving any data source information. Any help would be appreciated.

The App - OnStart is set to ClearCollect( and filter on the user email, ClearCollect(statusvalues "All", Collect(statusvalues, and ClearCollect(MyCCs on a sort.
Gallery - Items - If ddStatus selcted value = All, SortByColumns and then Filter(SortByColumns

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Valantis 1,723 on at

Like (1)

Report
Copy link

Link copied!

Hi @CU29092301-0,

A likely reason this stopped working is that the app is using ClearCollect in App.OnStart to load SharePoint data into a collection.

This is not delegable, which means Power Apps may only pull part of the list. If the list has grown, the records you expect might no longer be included, so the gallery can show 0 items even though the data is still there.

Another possible reason is timing. Microsoft also says the app screen can load before App.OnStart has finished, so the collection may not be ready when the gallery tries to display the data.

The best next step is to stop using the SharePoint collection for this gallery and instead connect the gallery directly to a Filter / SortByColumns formula against the SharePoint list. Also, if you are filtering on a Person column, use Email or DisplayName only.

I would also recommend checking App Checker / Monitor to see whether the query is failing or showing delegation warnings.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

Was this reply helpful? Yes No
CU29092301-0 44 on at

Like (1)

Report
Copy link

Link copied!

Hi Valantis,

Thank you for your quick response!

Yes, I did some preliminary testing, and it appears that the clear collect is failing and the query isn't running because too many lookup columns.

On the App checker performance, I found that there are 2 warnings, unused variable and data row limit for non-delegable queries, which is set to 2000, unused variable removed. On the App checker Data source, also found, that two of the SharePoint data sources are showing as "unused".

I tried creating a Sort/Filter directly tied to the SharePoint list instead using the Filter/SortByColumns formula, it too is failing. Error saying too much for lookup threshold. Not sure what to do here next.

Was this reply helpful? Yes No
Suggested answer

Valantis 1,723 on at

Like (1)

Report
Copy link

Link copied!
Hi @CU29092301-0,

Thanks for the update. Since the direct Filter / SortByColumns query is also failing with a lookup threshold message, this now looks more like a SharePoint list design / threshold issue than just a Power Apps formula issue.

The most likely cause is that the main SharePoint list has too many complex columns involved, such as People, Lookup, or Managed Metadata columns. Microsoft documents that these count toward the SharePoint lookup threshold, and once that threshold is hit, queries can start failing.

My recommendation would be:

review the main SharePoint list and reduce unnecessary People / Lookup / Managed Metadata columns where possible

use simple columns for app filtering, such as plain text for email or status, where practical

avoid loading the full SharePoint list with ClearCollect on startup

keep the gallery directly connected to SharePoint with a delegable Filter / SortByColumns formula

make sure the columns used for filtering and sorting are indexed

So in short, this now seems to be a SharePoint threshold/schema issue, not only an app formula issue.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

Was this reply helpful? Yes No