Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filter using Email address

(0) ShareShare
ReportReport
Posted on by 78

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!

  • Lexnnn Profile Picture
    Lexnnn 94 on at
    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.

  • Meneghino Profile Picture
    Meneghino 6,949 on at
    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.
  • Meneghino Profile Picture
    Meneghino 6,949 on at
    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.
  • diegoadum Profile Picture
    diegoadum 78 on at
    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?

  • Jeff_Thorpe Profile Picture
    Jeff_Thorpe 6,085 on at
    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)
  • Verified answer
    Meneghino Profile Picture
    Meneghino 6,949 on at
    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard