You’re offline. This is a read only version of the page.
2
Hi, Looking for help in an issue in that is occurring since last week in PowerApps…
I have a TextInput section and Gallery Section. The gallery displays data if the text entered in TextInput occurs in one of many columns (all Single line of Text) in a SharePoint list using Filter function. The Sharepoint list is a large list containing >14000 records. Delegation has been taken care of. It was working well and displaying expected results until last week. Since Thursday (that's when user reported this issue), the filter condition doesn't fetch the intended records. On further investigation, I found that as the numbers of columns to compare in the Filter increases, it searches only a subset of the search string. For example, if the number of conditions used in filter condition is 28, it searches only 10 characters given in the search string. i.e., it displays correct results if the Search string is 'Frank Rodg' but shows empty when the search string is 'Frank Rodger' (while using a StartsWith condition). If I reduce the number of conditions in Filter to 20, it would display correct results for up to say 15 characters in search string.
In PowerApps editor mode, it throws a runtime error - "You don't have permission to view this data. Server Response LISTNAME failed: The response is not in a JSON format" and in PowerApps debugger it shows, "Unauthorized" error in the getRows function while testing with large search strings. I have full control on the list and site collection administrator. Not sure why it would throw this error.
Anyone has come across this issue in recent times or aware of any recent update in PowerApps that might be causing this?
Share
Report
All responses (
Answers (
