Delegation warnings in Power Apps - Canvas App

[Ancy]

Hi All,
We are facing issues while fetching data from the data sources in the Canvas App. We are using the SQL Server Connector and wanted to fetch the large set of records in Power Apps.
We have used the below code but it's showing the delegation warning at "&&" and "||" operators (example is given only for "&&" operator).

Set(
    loggedInEmpId,
    First(
        Filter(
            '[dbo].[employees]',
            emp_email = "test@test.com" && emp_name = "Test"
        )
    ).id

Also we face the similar problem with the "Filter" method being used under the "First" method.  

Is there any alternative to fix the aforesaid warnings?Any help would be appreciated.
Thank you

[Ancy]

Thanks everyone for the help!! My issue got resolved using the LookUp() function.