Unanswered

Adding Azure AD group members to a SharePoint list

(0) Share

Report

Posted on by SerialImpact

Hi,

I'm trying to build a power automate flow to add a list of a group members to a SharePoint list.

Currently we have a manually maintained A-Z contact list on our Intranet homepage that lists all staff members job title, managers, contact details etc. This has been maintained manually and I want to automate it based on the contents of our All Staff distribution list.

I have been following the solution described by @annajhaveri in this post: Solved: Re: Azure Group Members Sync to SharePoint List - Power Platform Community (microsoft.com)

But when I test the flow I receive the following error at the filter array step:

Here is a screenshot of my entire flow with all parameters visible for reference:

I also want to ensure that the the workflow is able to add other attributes of the current user such as their mobile phone number and teams number to other relevant columns in the SharePoint list - this current version seems like it would only add their email address?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

michael0808 304 on at

Like (0)

Report

Use "List Group Members" instead, and then pass the values of that result into an Apply to each. Then add the Get user profile action before creating your item in the list.

I am not sure if you are able to get the Teams phone number unless you manually insert it into the users profile in Azure/Entra.

Hope this helps.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@SerialImpact i see the issue with the Filter Array action, in right side of does not contain, you have select the output from dynamic content, however you need to select output item

Here is incorrect

Here is the correct

Was this reply helpful? Yes No