Retrieve user profiles from a collection of user emails

[jchen1]

I have a collection called userEmails that I have populated with every employee's company email address. I am trying to use the Office365Users connection to pull the User Profiles into a new collection called userProfiles. 

Currently my code is :

ClearCollect(
    userProfiles,
    ForAll(
        userEmails.Value,
        Office365Users.UserProfileV2(First(userEmails).Value)
    )
);

 I have tried UserProfile and UserProfileV2 and both ways just populate blank rows in my collection userProfiles. 

userEmails has 6 test email addresses in it and when I run the code, userProfiles populates to 6 rows with the correct headers for UserProfile but no data. Does anyone know the issue or a different solution to my task?

[Max44]

Will it be safe to assume that the users email address is stored in the AD? In that case you might use DirectorySearcher to query for a user.

[eka24]

Have you read this post:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Build-a-collection-of-user-profiles-from-O36...

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[v-yutliu-msft · Accepted solution]

Hi @jchen1 ,

Do you want to save user profile in a collection?

Could you show me your collection of userEmails?

Have you checked your emails in userEmails in your talent?

I've made a similar test and found that you need to make a little change on your original formula.

Here's my test for your reference:

1)create  userEmails collection:

ClearCollect(userEmails,["Phoebel@Wic....ft.com","Test5@W...rosoft.com"])

 2)create  userProfiles collection:

ClearCollect(
    userProfiles,
    ForAll(
        userEmails.Value,
        Office365Users.UserProfileV2(Value)
    )
)

First(userEmails).Value only represents the first email in useremail collection. You just need to use fieldname Value in Office365Users.UserProfileV2 function.

ForAll(collection,Office365Users.UserProfileV2(fieldname)) represents you will perform Office365Users.UserProfileV2(fieldname) one by one record.

Then I will get a collection with user profiles.

Best regards,

[jchen1]

@v-yutliu-msft 

Thank you! This worked great! 

My userEmails was a collection with a blank column (Result) and a column (Value) that looked just like the example you made. After changing my code to match what you had, userProfiles populated with every employee profile.

[paulewert]

Watch out. Being that UserProfileV2 takes a "User (UPN)" parameter described as "user principal name or email id" and User().Email may not return a value which matches that returned by UserProfileV2. This is particularly true for users with multiple registered SMTP values (these can be seen using Outlook client's Address Book search and then viewing the "E-mail Addresses" tab of the contact card). Thus, this action may not work as expected if you pass in the user's email address. In our environment, the user's username portion of their email address does not always match their user principal name. (Mine does not.) Without experimentation or better documentation, it's hard to know if UserProfileV2 is taking an email address or a user principal name + domain. I side-stepped the ambiguity and simply used the user's ID as returned from Microsoft365Users.MyProfileV2({'$select':"id"}).id.