Answered

Filter all gallery values if the user is the admin of the app

(0) Share

Report

Posted on by nmlsanmiguel

Hi Team,

It's been a while, I am seeking assistance if it's possible to filter gallery based on user security level? Like if the app will detect that the user viewing the app is the admin, he/she will see all gallery values?

Kindly see screen shot of my code on start.

Thank you!

Categories:

Dataflows

Connecting to Data

General Questions

All responses (4)

Answers (1)

nmlsanmiguel on at

Like (1)

Report

Re: Filter all gallery values if the user is the admin of the app

Hello, it's already working I just forgot to click the run on start button that's why it's return value is null.

Thank you
Verified answer

narayan225 2,449 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter all gallery values if the user is the admin of the app

@nmlsanmiguel

Where is varUsers defined? I suggest you use User().Email instead.

Cheers!
nmlsanmiguel on at

Like (1)

Report

Re: Filter all gallery values if the user is the admin of the app

Hello, Thank you for your answer. I tried the logic statement above,
but lookup returning blank, idk why it returns blank when in MS List it has true value. Thank you!
narayan225 2,449 Super User 2025 Season 1 on at

Like (0)

Report
Re: Filter all gallery values if the user is the admin of the app

@nmlsanmiguel
If you have a separate list for security privileges, you can use If condition for Filters.
If(LookUp(SecurityTable,Email = User().Email,Role) = "Admin",DataSource,Filter(filer condition for other users))
Here if the role is Admin from SecurityTable that contains email and roles, it will display whole datasource but if the role is other than Admin, you can specify your own filter.

Cheers!