web

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

News and Announcements icon

Power Platform CommunityForums Power Apps GRANT ACCESS TO SPECIF...

Power Apps

Unanswered

GRANT ACCESS TO SPECIFIC GROUPED EMAIL ADDRESSES (DISABLE BUTTON IF EMAIL NOT INCLUDED)

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I have button, and want to grant specific access to a group email address xyz@love.com (which contain 60 emails users).

I have tried using the group email address as below;

If("xyz@love.com" = User().Email, DisplayMode.Edit, DisplayMode.Disabled)

it doesnt grant anyone of the 60 email users access, button is disabled.

how do i work with group email here? instead of typing over 60 emails like below

If("Janet.Anda@x.com" = User().Email || "jogh.ami@x.com" = User().Email || "kayi.ayi@x.com" = User().Email, DisplayMode.Edit, DisplayMode.Disabled)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

Your formula doesn't work because the users' email address is not what you stated. They all have unique email addresses. You are trying to determine if they are in a group which has such an email address.

To do this you will need to utilize the Office365Groups connector and the ListGroupMembers action.

You will need to know the group ID for the xyz@love.com group.

This is expensive in terms of processing, so I would perform this ONCE, like in the OnStart action of your app and set a global variable to use elsewhere.

Ex.

OnStart:

Set(isGroupMember, LookUp( Office365Groups.ListGroupMembers(<groupIDhere>).value, StartsWith(Mail, User().Mail), true ) )

Then you can use this variable in your formulas.

Ex.

If(isGroupMember, DisplayMode.Edit, DisplayMode.Disabled)

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

thank you for your prompt response @RandyHayes , i also have multiple group emails to use with the app, how do i go about that please?

Was this reply helpful? Yes No

Join the conversation