Answered

Office 365 Groups - List group members

(0) Share

Report

Posted on 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?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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 at

Like (0)

Report
Copy link

Link copied!
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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 at

Like (0)

Report
Copy link

Link copied!

@v-yetonggu-msft , Yes it is Array

Was this reply helpful? Yes No