Answered

Having trouble using search/query between Office365Users and Office365Groups

(0) Share

Report

Posted on by sanju_bd

So, we are looking into some powerapps solution for the workplace but struggling with some search user query. The need is to be able to search Office365Users who belongs to some Azure AD Security groups (Office365Groups). But from what I understand the SearchTerms cant use anything like {groups : 'SecutiryUserGroupID'} and it only can search based on parts of name and username/email .. Essentially I have also tried generating a separate user list (email list) and used that in the search but that is darn slow. Any idea how can this be achieved ?? Thanks In advance

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @sanju_bd :

Could you tell me:

Do you want to search for users in a certain group?

If so,I suggest you use this formula to get all the members in the specified group, and then get the users you are looking for based on the returned result of this formula.

Office365Groups.ListGroupMembers('TheGroupID').value

Best Regards,

Bof
sanju_bd 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft Thanks for getting back. This is exactly what I had been doing. Generating a separate list based on the groups which seems to have only Email and some other field and not the full office 365 profile that we need. Beside that generating a list (of emails for example) based on the groups takes a while (30 - 40 secs) which is simply not acceptable.

Ideally, I have had been looking for a solution where I can search office365.SearchUser with GroupId can be used as one of the searchTerm.
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @sanju_bd :

I am afraid that the function you mentioned is currently not available. If you need this function, I suggest you post your ideal to this forum:

Power Apps Ideas

In addition,I suggest you try this formula as an alternative:

Ungroup( ForAll( Office365Groups.ListGroupMembers('GroupID').value As UserList, {Users: Office365Users.SearchUserV2({searchTerm: UserList[@mail]}).value} ), "Users" )

Best Regards,

Bof