Answered

Filter using Email address

(0) Share

Report

Posted on by diegoadum

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!

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Verified answer

Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
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)
diegoadum 78 on at

Like
a
(0)

Report
Copy link

Link copied!

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 6,949 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes, you need to save and close the app and reopen it for the Start method to fire. It will fire once only.
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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.