PowerApps: Search User In Azure AD

Hello Friends,

Welcome back with another post on PowerApps. In previous post, we learned about fetching of groups and then it's members.

PowerApps: Fetch Groups And Users

Today, we will learn about fetching the Users from Azure AD. So, let's start-

1. Add a blank screen named "ScreenADUsers".
2. Now Add below controls-
1. Label - lblSearchUserLabel
2. Text Input - txtSearchUserText
3. Button - btnLoadUsers
4. DataTable - dtUsers
3. Initially, add Label, Text input, button.
4. 
5. Now, click on "Data" link from left navigation menu and the click on "Add data".
6. 
7. Here we will add "Office 365 Groups" connection. Search for "office 365".
8. 
9. Select the "Office 365 Users" connector.
10. 
11. Now, on "OnSelect" property of btnLoadGroups, we will add below code to fetch Users.

1. ClearCollect(
       collOffice365Users,
       RenameColumns(
           Office365Users.SearchUser({searchTerm: txtSearchUserText.Text}),
           "DisplayName",
           "Member Name",
           "Mail",
           "Email ID",
           "Id",
           "ID",
           "UserPrincipalName",
           "User Principal Name"
       )
   );
   

12. 
13. Run the app and click on button so that the collection get its structure.
14. Now, add one DataTable (as mentioned above) named "dtUsers'. Provide the collOffice365Groups as Data Source. Then click on "Edit Fields" link and choose "Member Name", "ID", "Email ID", "User Principal Name".
15. 
16. That's all. Publish the app and see the magic.
17. If the text will be blank, it will fetch all users, otherwise, based upon the input, it will search the data.
18. 
19. 
20. This is how, you can fetch the users.

With this, I am concluding this post.

Happy Coding !!!

Will see you again with some new topics.

Stay Safe !

Stay Healthy !

PowerApps: Fetch Groups And Users

Hello Friends,

Welcome back with another post on PowerApps. Today, we will learn about fetching the Microsoft 365 groups created in AD and then it's members. So, let's start

1. Open the PowerApps maker portal and create a Canvas App.
2. 
3. Add-
1. Label - lblSearchGroupLabel
2. Text Input - txtGroupSearchText
3. Button - btnLoadGroups
4. DataTable - dtGroups
5. DataTable - dtGroupMembers
4. Initially, add Label, Text input, button.
5. 
6. Now, click on "Data" link from left navigation menu and the click on "Add data".
7. 
8. Here we will add "Office 365 Groups" connection. Search for "office 365".
9. 
10. Select the "Office 365 Groups" connector.
11. 
12. Now, on "OnSelect" property of btnLoadGroups, we will add below code to fetch Groups.

1. ClearCollect(
       collOffice365Groups,
       If(
           Len(Trim(txtGroupSearchText.Text)) = 0,
           RenameColumns(
               Office365Groups.ListGroups().value,
               "displayName",
               "Group Name",
               "id",
               "ID",
               "mail",
               "Group EMail ID"
           ),
           RenameColumns(
               Office365Groups.ListGroups(
                   {
                       '$filter': Concatenate(
                           "startsWith(displayName,'",
                           txtGroupSearchText.Text,
                           "')"
                       )
                   }
               ).value,
               "displayName",
               "Group Name",
               "id",
               "ID",
               "mail",
               "Group EMail ID"
           )
       )
   );
   

13. 
14. Run the app and click on button so that the collection get its structure.
15. Now, add one DataTable (as mentioned above) named "dtGroups'. Provide the collOffice365Groups as Data Source. Then click on "Edit Fields" link and choose "Group Name", "ID", "Group Mail ID". 
16. 
17. Now, we want to fetch the members of the group, which is selected by user in data table. So, for that, click on "ID_Column1" and choose the "OnSelect" property from the property dropdown.
18. 
19. Now update the logic as below-

1. ClearCollect(
       collOffice365GroupMembers,
       RenameColumns(
           Office365Groups.ListGroupMembers(dtGroups.Selected.ID).value,
           "displayName",
           "Member Name",
           "id",
           "ID",
           "mail",
           "EMail",
           "userPrincipalName",
           "User Principal Name"
       )
   );
   

20. 
21. Now, this code will work only if the user clicks on ID column cell. If the user clicks on "Group Name" or "Group Email ID" column, it will not work.
22. For that, select these columns and update the "OnSelect" property as below.
23. 
24. Now, save the app and play. Load the groups and click on one of the group ID from data table "dtGroups". It will load the data in collOffice365GroupMembers collection.
25. Now add another data table "dtGroupMembers".
26. Select Data Source as collOffice365GroupMembers. Then click on Edit Fields and then click on Add field. Choose "Member Name", "EMail", "ID", "User Principal Name".
27. Save the app and play it. click on Load Groups button then select any group from the dtGroups table.
28. 
29. The only problem is that when we click on "Load Groups" button, the dtGroups gets loaded but the members of the default selected group doesn't populate in dtGroupMembers table.
30. Don't worry, just copy the code written on "ID" column >> OnSelect property of dtGroups table and paste it at the end of OnSelect code of btnLoadGroups.
31. 
32. Save the app and play it again.
33. 
34. 
35. Now, the only issue you may face is that if the dtGroups is already populated with groups and you make a new search, the dtGroupMembers table doesn't get updated. For this, just clear the collOffice365Groups in the beginning of button click code.
36. 
37. That's all.
38. This is how, you can play with Office 365 groups and their members in PowerApps.

With this, I am concluding this post.

Happy Coding !!!

Will see you again with some new topics.

Stay Safe !

Stay Healthy !

Power Automate: Get Azure Active Directory Group Users

Hello Friends.

Welcome back with another post on Power Automate. Today, we will learn about How to get users from Azure Active Directory Group through Power Automate. Sometimes, there are the requirements that we need to send mails to some users that belongs to a particular AD group. Therefore, our approach will first to get all the users from that AD group and then perform activity (like sending email) as per the application requirement. Let's start.

1. Create a blank "Instant cloud flow" with trigger as "Manually trigger a flow". Give it a name - ExtractADGroupUsers.
2. 
3. Now, we need the ID of that AD Group for which, users need to extract. You may ask this ID either from the AD Admin or you can add that group in your SharePoint site and then click on that group, it's account filed will give you the ID of that group. The GUID after the "tenant|" is the ID of the group.
4. 
5. Now, go back to the flow and add an action "List group members" under "Office 365 Groups" category.
6. 
7. It will ask the Group ID. Input the ID we had copied from SharePoint discussed above.
8. 
9. Save it and Test it.
10. 
11. It will give us a JSON of all the users belong to this group. The attribute, which is important for us is "mail" and then "displayname". The primary is "mail".
12. Now, edit the flow again and initialize an array, in which you need to store the Email IDs.
13. 
14. Now, we need to use an "Apply to each" action to capture the EmailIDs and store in array. During this process, we will also check that EMail ID must not be null.
15. 
16. 
17. 
18. That's all.
19. If you wish to see, what all email ids have been captured, you may initialize another array and assign it with arrayGroupUserEMails array.
20. 
21. Now Test the flow.
22. 
23. 
24. As you can see from above screenshots, the flow ran successfully and we have extracted users belongs to the group.
25. This is the shortest and straight way to perform the activity.
26. However, there can be other ways as well to perform the same activity like-
27. First- use the Select action to get the Emails only
28. Then use "Apply to each" action to add emails in array.
29. 
30. Second- use the "Filter" action to filter out null emails items.
31. Then use "Apply to each" action to add emails in array.
32. 
33. However, the results would remain same in all the cases.

With this, I am concluding this post.

Happy Coding !!!

Will see you again with some new topics.

Stay Safe !

Stay Healthy !