Set visibility on button for multiple user groups

(0) Share

Report

Posted on by joshieboy

519

Hello,

I have a button on my form that I have targeted to a group of users that pulls from a SharePoint list. The formula on the visible property for the button is: If(IsBlank(LookUp('IIN Admins', Admins.DisplayName = varUser.FullName, Admins.DisplayName)),false,true) And currentTab="EditIIN"

This works really well and only users from the table/custom list "IIN Admins" can see it. I also have another table/custom list called "Operations Admins" with the same layout and field "Admins" as the IIN Admins list. I wanted to include this operations table in the visible formula for the same button as I did not want to include those users in the IIN Admins list, since they have more permissions. However, I can't seem to figure it out.

I tried the following but it does not seem to work: currentTab="EditIIN" AND (IsBlank(LookUp('IIN Admins', Admins.DisplayName = varUser.FullName, Admins.DisplayName)),false,true) Or If(IsBlank(LookUp('Operations Admins',Admins.DisplayName=varUser.FullName,Admins.DisplayName)),false,true)

Would appreciate some guidance on this.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@joshieboy

Please consider changing your Formula to the following:

currentTab="EditIIN" && ( LookUp('IIN Admins', Admins.DisplayName = varUser.FullName, true) || LookUp('Operations Admins',Admins.DisplayName=varUser.FullName, true) )

I hope this is helpful for you.
joshieboy 519 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes -- appreciate the prompt response on this. The good news is that there is no longer an error on the button and it is now showing. However, when I remove a user from the list they should not be able to see the button, and somehow the couple of users I tested it with they still see it. Not sure what is missing.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@joshieboy

Make sure you have removed them from both lists and make sure you are refreshing your datasource in the designer when testing.
joshieboy 519 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes - thanks. Forgot to mention that I also did that during the test. There was an issue with this which I now recall. I believe I had to use varUserOffice365.Mail as the email address in SharePoint was showing firstname.lastname@domain.com whereas PowerApps was first letter of first name.lastname@domain.com. So if I have to change the above to Name.Email=varUserOffice365.Mail how should that be included in the formula?