Unanswered

Get a list of emails from an AD Group and populate a sharepoint list dropdown

(0) Share

Report

Posted on by Community Power Pla...

In a sharepoint list, is it possible to populate a dropdown list with users/emails from a specific group from AD?

I'm assuming this is not possible in the vanilla form editor but if I build a Power App form for this list how would I go about automatically pulling the user/email in a dropdown list?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

C-Papa 1,836 on at

Like (0)

Report

If you create a form from a SharePoint list that has a person choice field it will allow you to search all users in the organisation base on email / first and second name. you don't need to create a list of users within SharePoint as PowerApps can use the active directory.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yes, I'm aware of that. But the goal is to only have the ability to select a specific group of employees and all of them should be visible in the dropdown (without searching for their name).

Was this reply helpful? Yes No
C-Papa 1,836 on at

Like (0)

Report

Ok, so you could collect the users from the Office365.users connector into a collection and filter the users based on your requirements, this assumes that one of the fields in the active directory contains the information you would like to filter against. you then set you items property of your dropdown to your collection column that you want to display. If you cannot filter people from AD using the existing fields you would need to either add them when creating the collection or store the groups in a database somewhere.

Was this reply helpful? Yes No
Verified answer

v-albai-msft on at

Like (0)

Report
Hi @Anonymous ,
Do you mean Azure AD group?
If yes, two ways you can try to get all the members from a particular group.
1. You can use Azure AD connector. Add a dropdown control and set its Items property to below formula:
AzureAD.GetGroupMembers("cdd2bc5c-a5ac-4516-8ab9-740a2b8974a2").value.mail
If you want to show all the user name, you can use:
AzureAD.GetGroupMembers("cdd2bc5c-a5ac-4516-8ab9-740a2b8974a2").value.displayName
2. You can also use Office365Groups connector. Add a dropdown control and set its Items property to below formula:

Office365Groups.ListGroupMembers("cdd2bc5c-a5ac-4516-8ab9-740a2b8974a2").value.mail
If you want to show all the user name, you can use:
Office365Groups.ListGroupMembers("cdd2bc5c-a5ac-4516-8ab9-740a2b8974a2").value.displayName
Notes:
1. Add the Azure AD connector or Office365Groups connector first.
2. Replace to your group ID. You can get the group ID from below "Object Id" property:

Best regards,
Allen

Was this reply helpful? Yes No