(Delegation?) Can someone explain why this works.

[samuelJ]

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. 

[mdevaney · Accepted 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]

A great simple answer.  Thank you @mdevaney