Hide one of the gallery for some users

(0) Share

Report

Posted on by MIA27

I have 3 gallery on the screen.

I want to hide one of the gallery from all users other than 3 users (whose email address I am having)

I am aware that the code to be applied on the visible property of gallery for it, but unaware of the correct code.

kindly guide by an example.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

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

Like (1)

Report
Copy link

Link copied!
@MIA27 one method:

User().Email exactin [ "name2@abc.com", "name2@abc.com", "name2@abc.com" ]

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

Dear Mr. Imran,
Thank you for your advise, I am in process to implement your advised code and check.

BUT idea came to my mind, Instead of hard coding, tomorrow that user may leave and another may join, so it will be required to edit in the App, so get rid of this re-work, I am planning to make a table like below and then link the code that
IF the email address exist in the table and MATCHES with the Current USER , it will view ELSE it will HIDE the gallery

Please advise, we need to change to code to DLOOKUP or need other method coding?
Please advise the better way to handle this situation.

RowNo UserName UserDivision UserBranch UserEmail
1 Aaaa HED Site-A-Branch aaa.com
2 Bbbb HED Site-A-Branch bbb.com
3 Ccccc HED Site-A-Branch
ccc.com

Was this reply helpful? Yes No
Chitrakant 4 on at

Like (0)

Report
Copy link

Link copied!

Hi MI27,

In that case you use - If(!IsBlank(lookup(Table_name,UserEmail=User().Email)),True,false)
Hope this code will work & accept this reply as solution , if it work.

Thanks,
Chitrakant

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report
Copy link

Link copied!
@MIA27 - for that scenario you can simply apply the below to the Visible property of the Gallery:

!IsBlank( LookUp( 'Your People Table', UserEmail = User().Email ) )

@Chitrakant - there is no need use the IF function to return true or false if the property or control already expects a boolean.

Was this reply helpful? Yes No