Hi @MostafaGamal ,
Firstly, if you want to use multiple multiple condition to filter, the syntax should be like this:
Filter( Table, condition1,condition2,....)
LookUp(Table, condition1&&condition2&....)
So in your issue, you could use these formulas:
First(Filter(UserBOS3Years,MailOfUser = VarUser.Email,Entries= 0 ))
LookUp(UserBOS3Years,MailOfUser = VarUser.Email&&Entries= 0 )
However, I've found you posted another issue here:
https://powerusers.microsoft.com/t5/Building-Power-Apps/how-to-filter-more-than-2000-records-in-powerapps/m-p/629796#M199684
It seems that your current problem is delegation warning.
To avoid delegation warning, you need to use delegate functions.
The delegate functions for sharepoint are:
| Item |
Number |
Text |
Boolean |
DateTime |
Complex [1] |
| Filter |
Yes |
Yes |
Yes |
No [4] |
Yes |
| Sort |
Yes |
Yes |
Yes |
Yes |
No |
| SortByColumns |
Yes |
Yes |
Yes |
Yes |
No |
| Lookup |
Yes |
Yes |
Yes |
No |
Yes |
| = |
Yes |
Yes |
Yes |
No [4] |
Yes |
| <, <=,<>, >, >= |
Yes [2] |
No |
No |
No |
Yes |
| StartsWith |
- |
Yes |
- |
- |
Yes |
| IsBlank |
- |
No [3] |
- |
- |
No |
Since First() is not delegate, LookUp() is delegate, so please use LookUp function.
This formula will be more suitable for you:
LookUp(UserBOS3Years,MailOfUser = VarUser.Email&&Entries= 0 )
Best regards,
