I have created 'mail-enabled security' groups in admin center of office 365.
Further,I have created two dropdowns in powerapps
-one for group(dropdown1)
-other for users(dropdown2)
I want to fetch list of groups with 'mail-enabled security' in dropdown1.
And based on group selected ,I want to populate other dropdown(dropdown1) with corresponding users.
Problem is how to get list of security groups in powerapps?
Please help with the solution.
Hi @Anonymous ,
The office365Group connection can only get the Office 365 type group.
You should try to use AzureAD.GetMemberGroups function to get the security enabled groups.
Set the following formula in OnStart property of App, and set col_groups to Items property of Dropdown1.
Set the following formula in Items property of dropdown2
Hope this help.
If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.
I am also looking for the solution for the similar problem. Azure AD connector doesn't work for mail-enabled security group. It is mentioned in known issues and limitations in the page, https://docs.microsoft.com/en-us/connectors/azuread/
Ok. I found a solution. Can check out this site, https://www.c-sharpcorner.com/article/get-users-or-members-from-the-ad-security-group-in-power-apps/
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks