Citizen Developer
explore our new search
Utilizing Power Automate for Tenant Group Management
Power Automate
Oct 7, 2023 2:30 AM

Utilizing Power Automate for Tenant Group Management

by HubSite 365 about Christine Payton

Power Platform Developer

Citizen DeveloperPower AutomateLearning Selection

Become a Microsoft Expert: Leverage Power Automate to gain control of M365/Teams groups, Azure AD and distribution groups.

In this YouTube video, Christine Payton explains how to utilize Power Automate to gain information on all groups, their members, and their owners in your tenant. This applies to M365/Teams groups, Azure AD groups, and distribution groups.

This tool can be quite useful for various purposes, such as auditing membership, cleaning up potentially stale groups, and improving your overall visibility into your group's data.

Additionally, Christine Payton also demonstrated row-level security aimed to filter groups based on the assigned group owner.

The video is structured as follows: Initially, there is an introduction and data preview. The 2:25 mark brings the creation of a scheduled Power Automate flow, followed by the explanation of Pagination for large queries at 8:35. She then walks through getting all group owners in the tenant at 9:40.

At 16:07, Christine shows how to connect the data in Power BI, followed by creating a link to manage users in Azure at 19:00. A discussion on relating the groups to the members follows this at 20:25, with the 21:00 mark bringing visualisation into focus. Lastly, dynamic row-level security for group owners is touched on at 22:50.

Power Automate's Utilization

Is an integral tool in managing M365, Azure AD, and distribution groups. It offers comprehensive visibility into group data, crucial for auditing, discarding obsolete groups, and introducing more organized group management methods.

With its integrated functionality with Power BI, Power Automate fosters a seamless connection for data analysis and visual representation. Additionally, the tool's ability to manage users and link them efficiently to their respective groups is noteworthy.

Moreover, its feature of dynamic row-level security enhances the control over data accessibility, offering additional protection based on group ownership.

To get all groups, members, and owners in your tenant!

In today's video, the main topic revolves around the practical use of Power Automate by Microsoft to effectively manage all groups, members, and respective owners in an M365/Teams group, Azure AD group, or distribution group within your tenant. The several potential benefits of this approach including auditing membership, cleaning up outdated or unused groups for better organization, and generally gaining more visibility into your groups data.

The step by step demonstration of the process starts off with a brief introduction and a preview of the data used at 0:00. At the 2:25 mark, the process of creating a scheduled Power Automate flow is detailed. While handling large queries, pagination is a useful tool to keep track of data and is explained at the 8:35 point in the video.

Moving forward, at 9:40 the method to get all group owners in the tenant is shown, followed by the steps to connect to the data in Power BI at 16:07. A unique feature showcased in the video at the 19:00 mark is the creation of a link to manage user data in Azure. Relating to the groups to the members' functionality is elucidated at 20:25, which is followed by visualization techniques at 21:00 to understand the data better.

Lastly, the video also covers the dynamic row-level security for group owners at 22:50 that adds an extra layer of safeguarding and restricting unauthorized access and modifications.

To learn more about this subject which is primarily about managing groups in various Microsoft platforms using Power Automate, several Microsoft resources and training courses are available. This includes 'Managing Microsoft Teams' by Microsoft Learn and 'Microsoft Certified: Power Platform Fundamentals' that offers detailed explanations and practical experience on topics similar to the ones covered in this video. The courses and thorough instruction manuals available on Microsoft’s official site also serve as profound resources to dive deeper into the matter.

  • Introduction and data preview.
  • Creation of a scheduled Power Automate flow.
  • Pagination for large queries.
  • Getting all group owners in tenant.
  • Connecting to the data in Power BI.
  • Creating a link to manage users in Azure.
  • Relating the groups to the members.
  • Data visualization techniques.
  • Dynamic row-level security for group owners.

More links on about Use Power Automate to get all groups, members, and owners in your tenant!

2 Ways to List Group Members in Power Automate
Another option is to use the List groups action from the Office 365 Group connector. This will list all the groups in your tenant regardless of ownership or ...
Getting group members by office 365 group name in Flow
Sep 29, 2020 — Hi, I have SharePoint column which takes multiple people or groups. I want to send an email to all members of listed groups.


Power Automate, Get Groups, Tenant Members, Tenant Owners, Automate Processes, Microsoft Flow, Workflow Automation, Group Management, Tenant Administration, Microsoft Power Automate Tutorial