Assigning Azure RBAC Roles using PowerApps and Flow – Part 1

For Next Article, Assigning Azure RBAC Roles using PowerApps and Flow – Part 2

Welcome to Microsoft PowerApps and Microsoft Flow, the new technologies gets added in the Windowstechpro.. Going forward you will be seeing  more articles in this Category.

Well. In this Series of articles, we are going to see how to automate the Guest Access Inviter role assignment for the users based on the approvals. But it can be used for other azure directory roles assignment.. if the requirements are different, you can still use it for the ideas.

Note: This app is created just for an example(Really?). The same method also can be used for all other RBAC roles assignments or other Automations.

Since it is completely automated, We no need any administrators manual intervention in anywhere. Requester and Approver only gets involved for the request and approval processes. All other activities are completely automated.

Technologies used for this Automation

  1. PowerApps Forms
  2. Microsoft Flow
  3. SharePoint List
  4. Microsoft Graph
  5. Azure AD
  6. Azure AD Application Registration

Note: To follow this articles series , you should know basic ideas of the above technologies.

Finally , Complete Application flow diagram as follows,

Let’s get started!!.

  1. Creating SharePoint site and List to manage user details.
  2. Creating Microsoft PowerApps form
  3. Creating Microsoft Flows for the actions
  4. Adding Azure AD Application and setting the permissions
  5. Creating An Approval Flow
  6. Testing the application and approval process.

Step 1: Creating SharePoint site and List to manage user details

Login to SharePoint Admin Portal  https://tenantid.sharepoint.com  –> Site Collections –> New(Private Site Collection)

Give the name for the SharePoint name and add site administrator

Once the SharePoint site created. Login to SharePoint site using https://tenantID.Sharepoint.com/sites/Sitename

Now, Go the Site Contents — >New–> select the List

Give the Name for the List and Click on Create

Post creating the SharePoint list, go the SharePoint List.. Rename the Title as UserPrincipleName

Click on Add Columns and add all the data fields of the mentioned below which are required for our application

  • First Name – Single Line of text
  • Last Name – Single Line of text
  • Email Address – Single Line of text
  • Country – Single Line of text
  • Department – Single Line of text
  • Status – Single Line of text
  • Agreement Check – Single Line of text
  • Training attended  – Single Line of text

Once added all the columns and validate the columns are visible in the SharePoint list.

For Next Article, Assigning Azure RBAC Roles using PowerApps and Flow – Part 2

For Previous Articles in this series,

Assigning Azure RBAC Roles using PowerApps and Flow – Part 1

Assigning Azure RBAC Roles using PowerApps and Flow – Part 2

Assigning Azure RBAC Roles using PowerApps and Flow – Part 3

Assigning Azure RBAC Roles using PowerApps and Flow – Part 4

Assigning Azure RBAC Roles using PowerApps and Flow – Part 5

Assigning Azure RBAC Roles using PowerApps and Flow – Part 6

Assigning Azure RBAC Roles using PowerApps and Flow – Part 7

Leave a Reply

Your email address will not be published.