Answered

searching Office 365 users by Group

(0) Share

Report

Posted on by insurin

I have a simple Gallery and Textbox. The gallery searches Office 365 users from the input in the Textbox. Code below. The gallery then displays the Photo, Business number, Office and Job title.

Filter(Office365Users.SearchUser({searchTerm:TextInput1.Text,top:999}),AccountEnabled=true)

This searches my entire tenant. Is there a way to search only users who are in a group (staff group) so it does not include any other users?

It can be groups based or based on a difference to the UPN. For example isNot otherUPN.

cheers

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

victorcp 2,350 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Hi,
Yes, you can get all the members of a group and to achieve that you have to use AzureAD connector, like this:
AzureAD.GetGroupMembers(<Group GUID>).value
and then filter whatever you want
Filter(AzureAD.GetGroupMembers(<Group GUID>).value, StartsWith(displayName,TextInput1.Text))
Hope it helps
insurin 46 on at

Like
a
(0)

Report
Copy link

Link copied!
thanks, where am I putting
AzureAD.GetGroupMembers(<Group GUID>).value
do I need to join the commands and enter the code on my gallery?
victorcp 2,350 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Yes