Answered

Unable to Filter Gallery with Current Logged In User

(1) Share

Report

Posted on by mangchaaBI

Hi all,

Just starting to explore PowerApps for our needs, I'm having a bit of trouble filtering my gallery list to only show results for Current logged in user, I'm using a Sharepoint list btw

sharepointlist columns are as follows

employee_name (person/group)

session_date (date/time)

mentor_name (person/group)

Now I want to filter my gallery list to only show results specific to the current logged in user if he/she matches the records for employee_name or mentor_name

I tried a couple of suggestions in the web like adding this OnStart

Set(varUserEmail, User().Email);

And adding this on the item formula

Filter('sharepointlist', employee_name.Email=varUserEmail)

Thank you in Advance!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
HI @mangchaaBI ,

You should just need

Filter( 'sharepointlist', employee_name.Email=varUserEmail || mentor_name.Email = varUserMail )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
mangchaaBI 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Thanks for responding! tried the code and doesn't seem to show any result either, I can confirm that I do have 1 record under my current logged in user on the sharepoint list

Also I recreated a similar setup but using Excel Online as the datasource and I can get the filters to work though I used the User().Fullname filter in there because I have a column of Fullname list data..

Anyway, still need some help if possible, thanks
mangchaaBI 41 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz thanks for the assist, found a rather could be bug with the User().Email code and instead used

Set(varUserEmail, Office365Users.MyProfile().Mail)

And the filter code you provided is now working, thank you
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@mangchaaBI ,

Strange as I use User().Email extensively and have never had any issues - your code will work just as well however.