cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dhinesh28R
Post Prodigy
Post Prodigy

How to get O365 group members in power automate using Json?

Hi,

In my app i need to send mail for O365 group members.

So i need to get o365 group members mail id.

 

How to get o365 group members mail is using json only?

 

 

Thanks,

Dhinesh

1 ACCEPTED SOLUTION

Accepted Solutions
eric-cheng
Solution Sage
Solution Sage

Hi @Dhinesh28R ,

 

You don't need to parse the output JSON.

 

You can either:

 

1) Send an individual email to each group member

 

ericcheng_0-1629709231856.png

 

2) Send an email to all members at once

ericcheng_0-1629709806400.png

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

 

 

 

View solution in original post

9 REPLIES 9

@Dhinesh28R 

 

Not sure what you mean, what is the original data format? Is it an Output from Get Users Office 365 Action? Or is it something else entirely? What is an example of the kind of the data you are trying to get the e-mail ID from?

Hi @poweractivate,
It is getting from List group members connecter.

How to get a email of O365 group members mail id using parse json?

 

This is what i need.

 

Thanks,

Dhinesh

 

eric-cheng
Solution Sage
Solution Sage

Hi @Dhinesh28R ,

 

You don't need to parse the output JSON.

 

You can either:

 

1) Send an individual email to each group member

 

ericcheng_0-1629709231856.png

 

2) Send an email to all members at once

ericcheng_0-1629709806400.png

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

 

 

 

Hi @eric-cheng,
Am getting one or more recipients are invalid error in a Send email To address.

reperr.JPG

 

How to solve this issue?

 

Thanks,

Dhinesh

eric-cheng
Solution Sage
Solution Sage

Hi @Dhinesh28R ,

 

I am assuming you went with option 2.  Can you output the string to a compose action and check.  It should be separated by a semicolon e.g. user1@email.com;user2@email.com

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

 

Hi @eric-cheng ,

 

Yes. The To value is not seperated by ';' Properly. 

Am giving a Varible in a To Address.

 

A variable is like User@user.comUserDemo@user.com;Demo@user.com;User@demo.comDemoUSer@demo.com

 

How to separate a variable with ';' like User@user.com;UserDemo@user.com;Demo@user.com;User@demo.com;DemoUSer@demo.com

 

How to separate by ';'?

 

Thanks,

Dhinesh

 

 

Hi @Dhinesh28R ,

 

In the append to string, add a ;

 

Screenshot_20210823-195950_Chrome.jpg

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Hi @eric-cheng,

Already i added a ';' in Append string.

But still its shows one or more recipients are invalid.

In my variable i have two mail ids like. That's where i found an issue. Now its working fine man.

 

I have another doubt.

In my initialized variable i have a mail id User@demo.com .  And also same mail id in O365 group.

So now what am facing an issue means User@demo.com two times in a To address.

How to eliminate one duplicate value in To address?

 

Thanks,

Dhinesh

 

eric-cheng
Solution Sage
Solution Sage

Hi @Dhinesh28R ,

 

You can add a condition for your append to string where the string variable not contain email before appending

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (3,714)