Power Platform Community Forum Thread Details

Hi,

I have a form that is connected to a SharePoint list that allows users to edit fields within it, the form onSuccess property is set to Back() and when a user submits their changes it takes them back to the previous form view and works fine for the first 101 items in the SharePoint list, but any items that I try to edit from 102 onwards it goes back to form view but will immediately show the no items to display message, it still updates the SharePoint list but would be grateful if anyone could help with what is causing this behavior?

Regards

Sean

Categories:

Building Power Apps

Hi @Sean_Francis ,

Follow these few steps:

Check the Delegation Limit: In the PowerApps Studio, go to "File" > "Settings" > "Advanced settings" and check the "Data row limit for non-delegable queries" setting. Consider increasing it to the maximum of 2000 if it's not already set to that.
Review Non-Delegable Queries: If your form or the previous screen uses functions like Filter, Search, or LookUp with non-delegable queries, this could be causing the issue. Make sure all filters and lookups are using delegable queries.
Optimize Your SharePoint List: If possible, structure your SharePoint list and queries to fall within delegable limits. For example, use indexed columns in SharePoint for filtering in PowerApps.
Use ClearCollect: On the previous screen before the form, instead of directly querying the SharePoint list, consider using ClearCollect to collect the items into a collection. This can sometimes bypass delegation limits for operations within the app. However, this is only practical if the total number of items in the list does not exceed the delegation limit after being collected.
Post-Submission Handling: After submission, ensure that the form is properly reset or that the correct item is selected for display. Use ResetForm() or set the form's Item property to a valid record.
Debugging: After submitting the form, use the Notify() function to display any potential errors or messages that could help you understand what's happening.
Form Refresh: If you have a gallery or list that the user selects an item from to edit, consider refreshing that data source upon returning to that screen. You can use the Refresh() function in PowerApps to refresh the SharePoint list.