OfficeDev
"My requests" not visible when total number of BAR_Requests > Data Row Limit canvas app setting
When the building access app stores more than 2000 requests (or reaches the data row limit setting for the canvas app), any requests above the threshold are not shown in the "My requests" section of the building access app. On closer inspection (via the powerapp "Monitor" feature) it looks like ALL requests are being returned before it is filtered and when the number of rows breach the data row limit threshold, the additional rows are truncated. When opening the app in edit mode, we can see some delegation warnings, even though SharePoint is supposed to support delegation. Is there anything we can do to resolve this in setup/config without amending the code or is there a bug?
Tried a few different ways to get more data but working with MS they seem to think its the volume of data in BAR_Requests thats causing our issue. We have 3 time slots, AM, PM, Full Day and each booking creates three records. at the moment we have 124K records and when a user withdraws the booking it only updates the one record and not the other two.
We're going through and trimming the data at the moment and wanted to share part of the flow that i'm using to do it.
{ "inputs": { "host": { "connection": { "name": "@parameters('$connections')['shared_sharepointonline']['connectionId']" } }, "method": "get", "path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://domain.sharepoint.com/sites/BuildingAccess'))}/tables/@{encodeURIComponent(encodeURIComponent('8ec97f6e-fcf0-4348-be95-aec457b711db'))}/items", "queries": { "$filter": "Created le '@{addDays(utcNow(), -180, 'yyyy-MM-dd')}'" }, "authentication": "@parameters('$authentication')" }, "runtimeConfiguration": { "paginationPolicy": { "minimumItemCount": 500 }, "staticResult": { "staticResultOptions": "Disabled", "name": "Get_items0" } }, "metadata": { "flowSystemMetadata": { "swaggerOperationId": "GetItems" }, "operationMetadataId": "cb6782d0-9753-49ec-a716-219b08b5b8b4" } }
