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.
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)
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.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!