Power Automate is a trendy and relevant technology in the business world, especially for organizations aiming to streamline workflows and automate repetitive tasks. While it might not have the “hip” factor of cutting-edge AI like generative models or the latest blockchain developments, it holds a solid position as a practical, widely-used tool.
Microsoft Entra ID Security Groups
To simplify the governance of our users we have created teams of type Microsoft Entra ID security groups. We created a security group in Entra ID where we add the users we want to give access to the environment.
We then created a team of type Microsoft Entra ID Security Group in Power Platform where we assigned the Entra Group to the team. We then assigned the team the desired security roles:
We now only have to add users to the Group in Entra ID to give access to the environment. apps, automation and assign the users security roles.
Power automate – Force Sync users from Entra ID Groups
Now that we have automated and gotten more control of the governance of the users, we need to force sync the users.
The users will not appear in Dataverse unless they have logged into the environment. But building a power automate flow we can solve this issue:
The flow will be triggered once a day and then it will get the members of the Entra ID group. The flow then uses the force sync action to sync the users.
Governing the need relationship between data when users are added to the Entra ID Group
Need:
We needed to establish a connection between the logged-in user and the contact table. This way, we could retrieve the logged-in user’s Golden Snitch level and use it in the PCF, as well as access house names and house points for the app.
Solution:
We created a Power automate Flow that would get triggered when a user is added to the Entra ID group.
The flow then gets the user id in Entra ID:
We then list users and contacts with the matching email from Entra ID:
Then the flow uses the get row action to get the system user from the list row action. And a get row action to get the contact from the list row action:
The flow then updates the contact record and the lookup to the system user:
Results of adding the user to a Entra ID group:
