Good afternoon. I created a gallery and three drop down that a user selects to filter the table. This worked fine for months, until yesterday when my app received multiple runtime errors. This simple error has caused about 35 other runtime errors within my app.
The formula I used to filter the gallery is the following:
Filter('[dbo].[items]',itemType = DropItemType.SelectedText.Value && location = DropItemLocation.SelectedText.Value && status = DropItemStatus.SelectedText.Value)
Completed Troubleshooting
I've disconnected and reconnected my SQL database source
Replaced the formula in the ITEMS Value with the datasource
Set delegation limit to 2000. Previously, it was set to 500.
1. Are there any recent updates that would have caused this issue to occur? The application worked fine for months.
PowerApps Monitor Errors Received:
{
"duration": 0,
"size": 0,
"status": 400,
"headers": {
"Cache-Control": "no-cache,no-store",
"Content-Length": 688,
"Content-Type": "application/json",
"Date": "Fri, 04 Sep 2020 15:20:45 GMT",
"expires": -1,
"pragma": "no-cache",
"strict-transport-security": "max-age=31536000; includeSubDomains",
"timing-allow-origin": "*",
"x-content-type-options": "nosniff",
"x-frame-options": "DENY",
"x-ms-apihub-cached-response": true,
"x-ms-request-id": "f837ba3e-ddc6-4562-84c5-7813bbe64ba2",
"x-ms-user-agent": "PowerApps/3.20083.15 (Web Player; AppName=f905fe9c-5183-52c6-d838-51c6e3de2c72)",
"x-ms-client-request-id": "f837ba3e-ddc6-4562-84c5-7813bbe64ba2"
},
"body": {
"status": 400,
"message": "An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'\r\n inner exception: An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'\r\nclientRequestId: f837ba3e-ddc6-4562-84c5-7813bbe64ba2",
"error": {
"message": "An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'\r\n inner exception: An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'"
},
"source": "sql-ncus.azconn-ncus.p.azurewebsites.net"
}
}
