Display on a combobox/dropdown the Members of a specific group in SharePoint

(0) Share

Report

Posted on by Lym

Is it possible to display on a combobox or dropdown the members of a specific group in SharePoint?

Thanks in advance.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

If it about displaying office365 groups, then watch this video:
https://youtu.be/d0Ra0qr29JM?t=11
------------

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.
Verified answer

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lym ,

There is no direct way we can read the list of users added in SharePoint groups however yes you can read all the users added as part of Office 365 group using Office 365 group connector as below:
Office365Groups.ListGroupMembers("<< Office 365 Group Number >>")

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
v-yutliu-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Lym ,

Do you want to list all the group members of one specific group?

If so, you need to use Office365Groups.ListGroupMembers function. Just as @eka24 said, but I want to add some words.

Firstly, you need to connect with office365 groups connector.

Secondly, set your drop down's Items:

Office365Groups.ListGroupMembers("group object id").value

Do not forget the ".value" part, or else you will get error.

What's more, you could find a group's object id in azure admin center:

https://portal.azure.com

Here's a doc about this connector for your reference:
https://docs.microsoft.com/en-us/connectors/office365groups/#list-group-members

Best regards,
jut 6 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi Everyone,

This post is a little old, but it helped me through my issue. There is one change I would make to using:
Office365Groups.ListGroupMembers("group object id").value
I had an issue when I inputted the ID of the Team. The 'groupID' never changed in the URL no matter which Team I selected. So I got members from a Team I didn't want.

To fix this (and more inline with displaying Users within a specific SharePoint), you can actually pull the members of a permission group on a specific Teams permissions group (owners, members).
If you go to the SharePoint of the Team, Settings(Gear), Site Permissions, Advanced Permissions Settings. Click the group you would like to grab the ID of. The ID you're looking for is:
Account c:0o.c|*******|99999999-0000-aaaa-bbbbccccdddd

If you use this ID in the 'ListGroupMembers' above, you will get a better list members.