Technology With Imagination & Inspiration: Active Directory

Thursday, September 8, 2022

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-

Add a blank screen named "ScreenADUsers".
Now Add below controls-

Label - lblSearchUserLabel
Text Input - txtSearchUserText
Button - btnLoadUsers
DataTable - dtUsers

Initially, add Label, Text input, button.
Now, click on "Data" link from left navigation menu and the click on "Add data".
Here we will add "Office 365 Groups" connection. Search for "office 365".
Select the "Office 365 Users" connector.
Now, on "OnSelect" property of btnLoadGroups, we will add below code to fetch Users.

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

Run the app and click on button so that the collection get its structure.
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".
That's all. Publish the app and see the magic.
If the text will be blank, it will fetch all users, otherwise, based upon the input, it will search the data.
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 !

Friday, May 13, 2022

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.

Create a blank "Instant cloud flow" with trigger as "Manually trigger a flow". Give it a name - ExtractADGroupUsers.
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.
Now, go back to the flow and add an action "List group members" under "Office 365 Groups" category.
It will ask the Group ID. Input the ID we had copied from SharePoint discussed above.
Save it and Test it.
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".
Now, edit the flow again and initialize an array, in which you need to store the Email IDs.
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.
That's all.
If you wish to see, what all email ids have been captured, you may initialize another array and assign it with arrayGroupUserEMails array.
Now Test the flow.
As you can see from above screenshots, the flow ran successfully and we have extracted users belongs to the group.
This is the shortest and straight way to perform the activity.
However, there can be other ways as well to perform the same activity like-
First- use the Select action to get the Emails only
Then use "Apply to each" action to add emails in array.
Second- use the "Filter" action to filter out null emails items.
Then use "Apply to each" action to add emails in array.
However, the results would remain same in all the cases.