cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate V
Advocate V

Filter using Email address

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Champion
Community Champion

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

 

View solution in original post

6 REPLIES 6
Community Champion
Community Champion

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

 

View solution in original post

Super User
Super User

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)


--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

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?

Community Champion
Community Champion

Yes, you need to save and close the app and reopen it for the Start method to fire. It will fire once only.
Community Champion
Community Champion

OnStart, not Start. Apologies but am now on mobile and the interface for the community is even worse than on the deaktop. Can’t seem to be able to edit posts.
Helper II
Helper II

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.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (82,782)