cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
diegoadum
Level: Powered On

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
Meneghino
Level 10

Re: Filter using Email address

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
Meneghino
Level 10

Re: Filter using Email address

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

Re: Filter using Email address

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.
diegoadum
Level: Powered On

Re: Filter using Email address

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?

Meneghino
Level 10

Re: Filter using Email address

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

Re: Filter using Email address

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.
Highlighted
Lexnnn
Level: Powered On

Re: Filter using Email address

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,951)