Answered

Office 365 Groups - List group members

Like (0) Share

Report

Posted on 3 May 2024 00:44:44 by nagestiada

Hello guys, I am trying to get all the group members of my 25 Office 365 Groups and insert it as rows in SQL. Is there an easy way to get all in one object or is it one by one - 25 pcs of the image below?

I have the same question (0)

All responses (4)

Answers (1)

v-yetonggu-msft on 03 May 2024 at 01:02:27

Like (0)

Report
Re: Office 365 Groups - List group members

Hi @nagestiada ,

I recommend that you put all member ’ID‘into an array, and then use ‘Apply to each’ to loop through all ’ID‘ to find the member's information.

I did a test for your reference.

In my scenario:

[ { "ID": "100001" }, { "ID": "100002" }, { "ID": "100003" }, { "ID": "100004" }, { "ID": "100005" }, { "ID": "100006" } ] items('Apply_to_each')?['ID']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
nagestiada 504 on 03 May 2024 at 09:37:20

Like (0)

Report
Re: Office 365 Groups - List group members

I tried to add another column after ID so I can get the actual GID name before I insert into SQL but I am getting an error.

[ { "ID": "100001", "GIDName": "Admin" }, { "ID": "100002", "GIDName": "User" }, { "ID": "100003", "GIDName": "Super Admin" }, { "ID": "100004", "GIDName": "Bot" }, { "ID": "100005", "GIDName": "Dummy User" }, { "ID": "100006", "GIDName": "Test User" } ]

The variable 'GroupID' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable 'GroupID' only supports values of types 'Array'.

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on 03 May 2024 at 09:41:35

Like (0)

Report

Re: Office 365 Groups - List group members

Hi @nagestiada ，

Please check whether the type of your initialized variable is Array type:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
nagestiada 504 on 03 May 2024 at 11:06:52

Like (0)

Report

Re: Office 365 Groups - List group members

@v-yetonggu-msft , Yes it is Array

Was this reply helpful? Yes No