Power Platform Community Forum Thread Details

Hello everyone,

I was wondering if anyone could help with a problem I am having, my data source is SQL Server and I have all this code to filter data and to get the values for different clients, but although it works in the DEV environment it doesn't work in PROD, the database schema is exactly the same, they have been changed with migrations throughout the project. But the thing is that the PROD database has way more rows than the DEV one, in fact the AcoesDiplomas table referred in the code has over 50k rows already but I converted the code to not have any delegation warnings as it did before because I thought it could be that but the output still remains the same in Production, it's 0. If anyone who is more experienced could take a look, this is my first Canvas App so I don't really understand all the limitations and possibilities.

To add more context this is happening in the OnChange of a Date Picker.

Code is in attachment.

Thank you for any help.

Telmo Ferreira