Hi,
So this app uses various SQL Server tables as the source. The table SalespersonMaster as over 500 records, about 700. I have read delegation documents. I thought using a filter happens on the sql server side and I can find one records out of the 700 using the below code. It gives a delegation warning. However the line above it works fine when I set the users email to a variable search that way.
Just trying to understand if this a delegation issue and what it works one way and not the other.
Solved! Go to Solution.
@samuelJ
User.Email() is something that PowerApps understands but the SQL datasource does not. If you put it inside a variable it causes PowerApps to evaluate it and pass a 'fixed value' to the filter query thus avoiding delegation issues.
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
@samuelJ
User.Email() is something that PowerApps understands but the SQL datasource does not. If you put it inside a variable it causes PowerApps to evaluate it and pass a 'fixed value' to the filter query thus avoiding delegation issues.
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."