web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Table based off...

Power Apps

Unanswered

Filter Table based off of user access table

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Morning All,

I have a table that filters the rows based off of the user access. However, there are some users that have access to the entire table.

This is how I am filtering (this works)

Filter(

DeptFinancial

Admins in LookUp(

Employee,

User.Email = User().Email

).Admins

)

The filtering code works based off who is signed in (no problems here) However, when I try to add an if statement that says "If the user have access to view all the contents in DeptFinaincial show the entire table" I get hung up.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

The non-delegable method below will display a blank table if the current user does not exist in the "Admins" column of the Employee table:

Filter( DeptFinancial, User().Email exactin ForAll( Employee, Admins.Email ) )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No

Join the conversation