Hello, I'm somewhat new to PowerApps, but I seem to be hitting a wall that I don't fully understand. After reading up, it seems that some functions can put the workload on the source server verses having PowerApps do it directly. And that PowerApps by default can do 500 lines itself and be modified to go up to 2,000.
I'm personally working with a SQL server and am trying to populate a Data Table using this function
I have a List Box that will change the value of lblMaterialName_Materials, and then that is used to filter what I'm trying to show. This works on most of the results from that List Box, however, there are a few it won't work at all for. The Data Table shows as blank.
I went and looked at the SQL table and the results it would be populating in that Data Table are past the 500 count, so I'm thinking that this query isn't getting delegated to the SQL server. Now, I can obviously just change the threshold to 2,000, but it's possible this table will grow past 2,000. And things I have planned later in my application already have 16k lines in it.
My questions are
Why isn't my function being delegated to the SQL server? I've already verified that each of those functions should support delegation with SQL.
Is there something I have to do to enable delegation in PowerApps or the SQL Server?
If for some reason I wanted to put a CountRows around that, which I don't think supports delegation with SQL, would the inside part still be delegated and then the final CountRows wouldn't be or does the whole thing stop being delegated?
I'm not clear why it is different, but if I make a new Label (lblHelper_Materials) that is hidden and set it's value to LookUp(mT_SalesAttributeDB_Materials, MaterialName = lblMaterialName_Materials.Text).ID