web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Office365Groups email ...

Power Apps

Unanswered

Office365Groups email address from SecurityGroupID

(0) Share

Report

Report

Posted on by Yakimo

91

Is there any way to get email address having SecurityGroup id?

I know I can get GroupMembers using

>Office365Groups.ListGroupMembers(SecurityGroupID).value

but how to get Email address of that group out of SecurityGroupID?

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Try the Azure AD (GetGroup) connector instead. The Office365Groups connector deals with O365 groups only, if I remember right.

Hope that helps,
Bryan
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Yakimo

In this example,
MembersInDevelopmentGroup is the list of users with full details
Collecting the members from "Development" group
You can add yours

ClearCollect( AllADGroup, AddColumns( Distinct( GroupIDs, Value ), "GroupName", AzureAD.GetGroup(Result).displayName ) ); Clear(MembersInDevelopmentGroup); ForAll( AllADGroup, If( GroupName = "Development", Collect( MembersInDevelopmentGroup, Office365Groups.ListGroupMembers(Result).value ) ) );

Note: AzureAD and Office365Groups connectors used
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Yakimo

This gets name , id and email of Group

ClearCollect( colAllADGroups, ShowColumns(Office365Groups.ListOwnedGroups().value,"id","mail","displayName") );

and this gets group members for "Development" group
Clear(MembersInDevelopmentGroup); ForAll( colAllADGroups, If( displayName = "Development", Collect( MembersInDevelopmentGroup, ShowColumns(Office365Groups.ListGroupMembers(id).value,"id","mail","displayName") ) ) );
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Yakimo

Sample(s) from the above code

Join the conversation