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
PowerApps Forms
Microsoft Flow
SharePoint List
Microsoft Graph
Azure AD
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!!.
Creating SharePoint site and List to manage user details.
Creating Microsoft PowerApps form
Creating Microsoft Flows for the actions
Adding Azure AD Application and setting the permissions
Creating An Approval Flow
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,