Filter SharePoint list on Current User

[rahulvartak]

Thanks for the idea ! It worked for me !

[pNabin]

Thank you for the great idea. It is giving Blue Circle Deligation Error which still works for me.

[Jimmy_Jazz]

I have the same problem and your solution does not work. 

[Lexnnn]

This did help me to filter on User = email from people field: (I was using people field and it did not work well with powerapps) (3200+ items)
https://wonderlaura.com/2018/10/26/powerapps-filter-by-me/

Solution in short: use variable "on start" + "OnVisisble" refresh of the list and use same variable in filter +  single line of text field instead of poeple field.

SortByColumns(Filter('Sandwich shop',(Salesrepemail = CurrentUser.Email) And ((StartsWith(Account_x0020_name, TextSearchBox1.Text)) Or (StartsWith(Street, TextSearchBox1.Text)) Or (StartsWith(City, TextSearchBox1.Text))Or (StartsWith(Postal_x0020_Code, TextSearchBox1.Text)))), "Account_x0020_name", If(SortDescending1, Descending, Ascending))

To let the users still be able to use the people field, I use flow to auto populate the new single line of text field with a copy of email adress from people field.