Answered

Filter users based on a group

(0) Share

Report

Posted on by Nilo_1792

I want the list of users to appear in my items property, which belongs to a specific group: "Remote"
This group exist in Office365, and I tried adding the office365Groups connector, however unable to filter it.
Currently it displays all the users, and allows me to search for any text. I need an extra filter to display only this group members.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Nilo_1792 ,

You could use this formula to list group members:

Office365Groups.ListGroupMembers(LookUp(Office365Groups.ListOwnedGroupsV3().value,displayName="Remote").id).value

Best Regards,

Bof
Nilo_1792 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, this gives me the list of Group members, but I also want to be able to search for name in the text value, and match with the list of members in this group.
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Nilo_1792 ,

Please try:

Filter(Office365Users.SearchUser({searchTerm:tbSearch.Text}),DisplayName in Office365Groups.ListGroupMembers(LookUp(Office365Groups.ListOwnedGroupsV3().value,displayName="Remote").id).value.displayName)

Best Regards,

Bof