cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nate167
Helper II
Helper II

Filter current user from 2 columns in SP list

Hello, 

  I'm trying to filter results from a SP list based off the current user.  I am able to get the filter to work looking at only one column but can not get it to work looking at 2 columns.   I need it to filter the current user based off the two separate columns due to one column being sales reps and the other being sales managers.   Depending on who's logged in I need them to be able to see all the accounts that are listed under them.  Below are screenshots of what I have so far and any help would be greatly appreciated.

 

Nate167_0-1598278414105.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Hi @Nate167 

Try this:

Filter('WRFP-2021 Sample',Or('Sales Manager 1' = User().FullName, 'Account Manager' = User().FullName))

Hope this will work 🙂

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @Nate167 

Try this:

Filter('WRFP-2021 Sample',Or('Sales Manager 1' = User().FullName, 'Account Manager' = User().FullName))

Hope this will work 🙂

View solution in original post

I tried it and I'm not getting any results in the return.  Below are screen shots of what I have for my current user code and the code you supplied.  My source list on SP only has 100 items in it so the delegation warning isn't of concern at this point. 

Nate167_1-1598285140600.png

 

Nate167_0-1598285121053.png

 

Thank you for the help!  I took your formula and modified it and got it to work. 

 

Nate167_0-1598287705094.png

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,062)