Answered

Can I add members to Security mail enabled group via PowerApps?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have created an app for an internal team in my Company. I have shared my app with a security group (mail-enabled). The normal O365 group was not visible when I was trying to share the app.

I have assigned some co-owners for that group. What is the most user-friendly way to add new members to this group? Can I do it in PowerApps?

Aakash

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

FlowMohit 64 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Power Apps can only be shared with security enabled group because it has to receive tokens in order to access app resources.

You can add or remove members to a group using pshell, papps or ui.

In powerapps you have to use two connectors -
Power Apps for Makers - https://docs.microsoft.com/en-us/connectors/powerappsforappmakers/#edit-app-role-assignment (Here you need to use GetAppRoleAssigment method to get the list of all the user and groups with whom the app has been shared)
Office 365 Groups - https://docs.microsoft.com/en-us/connectors/office365groups/ (you need to use Add member to group and Remove member from group)
Make sure the person who will use these two functions within powerapps have co-owner access at app level and owner at the group level.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to add new members to this Security Group within canvas app?

Firstly, you could share your canvas app to Office 365 Group, but this Office 365 Group must be security enabled. Please check the following article for more details:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/share-app#share-an-app-with-office-365-groups

If you want to add new members to this Security Group in your canvas app, I think Office 365 Groups connector could achieve your needs.

I have made a test on my side, please take a try with the following workaround:

Add Office 365 Groups connection and Office 365 Users connection in your app. Then add two Dropdown boxes to list your owned available Groups (including Security Group) and Available users in your Org:

Set the Items property of the first Dropdown box (GroupDropdown) to following

Office365Groups.ListOwnedGroupsV2().value

Set the Items property of the second Dropdown box (UserDropdown) to following:

Office365Users.SearchUserV2({top:999}).value

Set the OnSelect property of the "Add Member" button to following:

Office365Groups.AddMemberToGroup(GroupDropdown.Selected.id, UserDropdown.Selected.UserPrincipalName)

Within the GroupDropdown box, select the proper Security Group, then within the User Dropdown box, select proper User you want to add to to this Securoity Group, then press the "Add Member" button, then the selected user would be added into this Security group.

Note: I assume that you created this Security Group or you are one member of Security Group already

Please take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Gary_Eden 375 on at

Like (0)

Report
Copy link

Link copied!

Hi
I've built an app to manage user group members in both Office365 (Teams and SharePoint access) and Security Groups (PowerApp access), using the process described. This works perfectly on our own company set up and on another customers account.

However, for a new customer we are trying to attempt the same functionality but only the Office365 add/remove functions work. Trying to add/remove members from security groups throws out a request denied/insufficient privileges error.

Working with the customers' Azure administrator we have confirmed that I am co-owner of the security groups and that I can add and remove users directly to the security group at the Azure AD level - just not through the app. Comparing my permissions between Office365 and Security Groups they appear the same.

We think that there may be another permission setting somewhere that needs changing but are at a loss as to where to look.

This is the error (IDs removed).
Office365Groups.AddMemberToGroup failed: {"error": {"code": "Authorization_RequestDenied", "message": "Insufficient privileges to complete the operation.", "innerError": {"date": "2022-01-24T15:21:48", "request-id": "xxxxxxxxx", "client-request-id": "xxxxxxxx"}}}

Any suggestions on where to look to amend the setting would be appreciated.

Thanks in advance.
Gary

Was this reply helpful? Yes No
Vaishali999 6 on at

Like (0)

Report
Copy link

Link copied!

I also getting same error to add members in mail enabled group "Office365Groups.AddMemberToGroup failed: {"error": {"code": "Authorization_RequestDenied", "message": "Insufficient privileges to complete the operation." Is there any solution found using power apps or power automate. Both the ways I have tried getting same error. Please help.

Was this reply helpful? Yes No
Vaishali999 6 on at

Like (0)

Report
Copy link

Link copied!

I also getting same error to add members in mail enabled group "Office365Groups.AddMemberToGroup failed: {"error": {"code": "Authorization_RequestDenied", "message": "Insufficient privileges to complete the operation." Is there any solution found using power apps or power automate. Both the ways I have tried getting same error. Please help.

Was this reply helpful? Yes No
tonydileonardo 2 on at

Like (0)

Report
Copy link

Link copied!

I am looking for a solution for this too for mail enabled groups. (Either power apps or power automate) There is lot of documentation out there that says it should, but it doesn't. Even copliot AI will put together the exact same solution for you that does not work.

Was this reply helpful? Yes No