Access Management is a core part of any modern business strategy, and making sure the right people can easily get access to tools is vitally important to success. So, is there a simple way to do it? Or is it something that we need to rely on someone else for? 

The simplest answer is that you will always need to rely on others for some elements, but great management comes from delegation and management of appropriate levels of delegation. Over the last decade we have worked to ensure the Group Management is delegated to the end users. They know who needs access after all, so inserting a delay there seems silly.  

The Problem and Best Practice 

Group management is a headache for organisations of all size and complexity. Almost all businesses struggle to find a solution and very often things end up either too rigid or too flexible. O365 and the more user-led side of your IT estate also require separate management.

The recommendation for O365 and Microsoft Power Platform 
is to consider it as partly standard and partly ad-hoc. 
Users need to have locked down and controlled areas 
and more open areas that they can manage as needed. 

So, how can we manage and balance the two elements, remembering that you should have at least one group for each Workspace and App? Things can get complicated quickly. There are some recommendations in terms of manging groups and permissions, and we’ll quickly cover those next, but fundamentally it is an administrative overhead that you may not want to get involved with. 

Microsoft Best Practice for Groups and Permissions 

  1. Add People to a “Role” group 
  2. Create Groups for each “Permission” required 
  3. Add Role groups to Permission groups 

In practice, within your ad-hoc space you may find that removing the expectation of using Role groups as an intermediary makes sense. Users can manage the specific list of permissions to their managed resources themselves.  

By working this way it becomes very easy to audit permissions. We can check to make sure people are not in “Permissions” groups, for example, and the task of adding someone to or removing them from a User Group is relatively simple.  

In practice, though, it is extremely rare for a business to be able to commit to fully using this practice with O365, Microsoft Power Platform and Teams. Changes have been made by Microsoft to make things easier so Teams can now be used to manage access to resources. Some companies have experimented with limiting who can create O365 and Power Platform resources, often receiving significant pushback, or they have not been able to fully delegate the controls. 

A Solution 

The Microsoft O365 estate (and Azure) support something called “Owner”, that means that one or more people can be assigned owner rights to a group. When you are a group owner you have the rights to add people to and remove people from a group. If you want to see if you are the owner of an groups follow the link below – you need to be using O365. 

https://myaccount.microsoft.com/groups/groups-i-own 

The default behaviour of the environment is to allow you to manage the group memberships of the groups that you own, technically you can add users or groups to them. Our advice would be to start using this solution with your ad-hoc spaces, a good JLM (Joiners, Leavers and Movers) process will manage the role side of things.  

Geordie Consulting has published a free PowerApp for you to use to manage the groups that you own.

How does it work? 

  1. When opened for the first time it asks you to confirm the O365 accounts to use for User and Group access (in PowerApps those are separate). 
  2. Select the group you want to manage from the drop down and press “Get Members” 
  3. Use the second drop down box to select users one at a time and add them to the group (note you can search using this box as well to refine the list) 
  4. If you want to remove anyone from the group you can select the Trashcan icon next to their name 
  5. When complete you can select Quit to close or change the group to manage another group the same way 

Installation 

  1. Download the Tool from our Github page. 
  2. Open https://make.powerapps.com  
  3. Select Apps from the menu on the left. 
  4. Select “Import an App” (from package .zip). 
  5. Browse to the Zip file you downloaded and upload, then import. 
  6. Select Create a New PowerApp (if you are replacing or upgrading it change this as appropriate). 
  7. Save and Publish the PowerApp. 
  8. Create access groups (if needed) and assign access to people. 

You can use and share this PowerApp internally with your bundled O365 PowerApps subscriptions.  

Conclusions 

This simple app allows people with Ownership of groups to modify the membership of those groups. This is far better than contacting IT to add or remove people. You can further tweak the PowerApp to add an audit trail, to track what has been done and by whom – and it can email that record to the person making the changes. This is intended as a simple way of managing your ad-hoc environment and assigning access quickly and easily, and most importantly,  it empowers the user-base to make the changes themselves, all without adding cost. 

If you would like assistance in updating the app please do not hesitate to get in contact with Geordie Consulting. 

Geordie Consulting have a wealth of expertise and a proven track record of delivering high-quality, customised solutions tailored to our clients’ specific needs. Our skilled professionals are dedicated to ensuring that your organisation reaps the maximum benefits from the Power Platform, driving efficiency and innovation. We pride ourselves on our commitment to customer satisfaction, providing ongoing support and continuous improvement to keep your systems running smoothly. By choosing Geordie Consulting, you are investing in a reliable partner who understands your business and is ready to help you achieve your goals without the burden of excessive costs or complicated processes. 

Helping you build your Data Enterprise.

Book a Free Consultation Meeting with us today.

Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.