My first logic app. Get group members from Azure AD and put them into a sharepoint list instead of manually downloading users every week :)

(0) Share

Report

Posted on by TerjeMonsen

Hi all,

Im trying to build a flow that will get all members from a group in AD and put them into a SharePoint list.

I have been able to Get the group members, its working. I connect to the list and that is working also. Now Im not sure how to inject changes to the list. I would like to remove users from the list if they are not members of the group anymore and insert new ones if they are not in the list from before.

Hope someone have time to help me getting this flow to work

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @TerjeMonsen,

I would suggest to have a look at the except method described by @DamoBird365 in one of his blogs:

https://www.damobird365.com/efficien-union-except-and-intersect-great-method/

Within this approach you could use the outputs of the two actions a filter if an item is not available.

Below is an example of that approach for your setup

1. Switch both Map fields to text mode with the button on the right side. This makes it easier to compare

2. Add two Filter Array actions. The first one will check for new group members. The second one will check which ones have been removed.

Below are the expressions

From - New group members

body('Select_Email_from_Group_Members')

Criteria - New group members

@not(contains(body('Select_Email_from_SharePoint_List'), item()))

From - Missing group members

body('Select_Email_from_SharePoint_List')

Criteria - Missing group members

@not(contains(body('Select_Email_from_Group_Members'), item()))

Alternatively, you could just delete all items from the list and just add the group members to the list. That would also work. Unless you have a specific requirement to keep track of changes and history.

Was this reply helpful? Yes No
TerjeMonsen 13 on at

Like (0)

Report
Copy link

Link copied!

Ok I have found out how to delete all rows in the SharePoint List. How do I add all again?

to the list

Was this reply helpful? Yes No
Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @TerjeMonsen,

Use a second apply to each and loop through the Group Members collection. For each item within that collection create a new list item with the Create Item action.

Was this reply helpful? Yes No
TerjeMonsen 13 on at

Like (1)

Report
Copy link

Link copied!

Thanks one million, It works now 🙂

Was this reply helpful? Yes No
TerjeMonsen 13 on at

Like (0)

Report
Copy link

Link copied!

Ahh another problem, It only gets the first 100 rows both in delete and add

How can I get it to remove all and add all? The Group has about 800 users

Was this reply helpful? Yes No
Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @TerjeMonsen,

Can you set the Top count field of the Get items action to 1000? If that does not work can you also enable pagination in the settings of the action:

https://sharepoint.stackexchange.com/questions/303692/what-is-the-default-number-of-items-that-are-retrieved-in-the-get-items-action-a

Same for the Get Group Members field. By default it will return 100 items. There is a Top field (under advanced options) which you can use and also Pagination.

Btw, if your data sets will get larger, over 5000 items I would suggest to look into Batch methods instead:

https://www.tachytelic.net/2021/06/power-automate-delete-sharepoint-items/

Was this reply helpful? Yes No