Hello everyone!
We would like to filter the data from our SharePoint list 'Travel Request' on the traveler (being the current user of the PowerApps).
E.g. Request 1:
Traveler: John Doe
Destination: New York
When the PowerApps User is Jane, she can not see this request in the BrowseGallery.
When it's John Doe, he can see his request.
Thanks in advance!
Solved! Go to Solution.
Thanks for the idea ! It worked for me !
Thank you for the great idea. It is giving Blue Circle Deligation Error which still works for me.
I have the same problem and your solution does not work.
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.
User | Count |
---|---|
174 | |
111 | |
86 | |
44 | |
42 |
User | Count |
---|---|
229 | |
118 | |
118 | |
74 | |
67 |