Hi! I'm trying to filter my dataset based on the user email address. So I'm adding the below line into the OnStart method of my screen.
Filter(FlotaTest_1; FlotaTest_1.EMail = User().Email)
FlotaTest_1 is my DataSource name which brings data from SharePOint online and FlotaTest_1.EMail is the field on where I do have user eMail address.
I'm not getting what I'm doing wrong here. The error message in the above formula sayd that the number of Arguments are not valid.
Ideas will be apreciates!
Regards,
Diego!
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.
Hi Meneghino,
I changed the place of the formula and now it's located into the Gallery (Items), but the result is the same. IN fact I do create a variable using Set(CurrentUser, User()) in the OnStart method of the screen and nothing. As a test I place a label and set the Text property as CurrentUser.Email and the result is blank.
Any idea?
The code should go into the Items property of the gallery. That code by itself won't do anything in the OnStart and the semi colon should be a comma (unless the language setting is like German where commas are semi colons).
Filter(FlotaTest_1, FlotaTest_1.EMail = User().Email)
Hi @diegoadum
The OnStart property is normally for actions, not table valued results. The formula you supply should return a table.
Also, you do not need to repeat the table name.
Finally: https://baizini-it.com/blog/index.php/2017/08/29/powerapps-user-function-cache-current-user-onstart/
Happy to give more guidance