How to add individually add multiple email addresses in array to a security group

(0) Share

Report

Posted on by jharville

Hello all!

I have a flow that currently has an array named 'Joined Active Users' ~ this is how I created it:

The contents of the array currently look like:

How would I add each of those emails to a security group? I figured I'd have to use the 'Apply to Each' with an 'Add User to Group' action inside (Co-Pilot confirmed this decision), but I'm having issues every time I test the flow.

This is what's currently inside the 'Apply to Each 1' and 'Add User to Group' sections:

Any help at all would be greatly appreciated! Best of wishes and happy new year!

Categories:

General topics

All responses (6)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @jharville
According to your screenshot , your action "add user to group" return error code "Bad Request".
As test in my side , you need to pass the User Id in this action instead of the User Email.
So you can add a Get user profile (V2) action before your "add user to group" action to get the Id of the user.
This is the result for this flow:
And for this action if current user have existed in this group, it will return an error code and it do not influence the flow, you can just ignore it .

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you. If this reply can help you , you can click mark this reply as solution, thanks in advance!

Best Regards,
Yueyun Zhang
jharville on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yueyun-msft

Hello and thank you so much for your response. Earlier in my flow, I already did use the 'Get User Profile (V2)' ..

but after that I use the 2 opposite below 'append to variable' functions to split the results into:
1) users that are in our tenant
2) users that are *not* in our tenant

--------------------

My question would be how would I reference the 'Outputs' of only the users that are found in our tenant (which is all of the email addresses in the Joined_Active_Users array ?
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @jharville
As my above reply , we can suppose the compose action is your Joined_Active_Users array:

As we need to use the Id field return by the "Get user profile V2" action instead of using the user Email in your Joined_Active_Users array.
So you need to Apply to each your Email array in your side .

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you. If this reply can help you , you can click mark this reply as solution, thanks in advance!

Best Regards,
Yueyun Zhang
jharville on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-yueyun-msft

So if I understand correctly, I can keep the previous 'Search for Users (V2)' that I used earlier on in the flow ... but later on in my flow I have to add an 'Apply to Each' inside of a 'Condition' .. and inside of that 'Apply to Each' is where I place the 'Get User Profile (V2)' ?

I tried doing that but I don't see an option for 'Current Item' to put inside the "UPN" of 'Get User Profile'

---------

Since I didn't see the option for 'Current Item' to put inside of 'Get User Profile (V2)' .. I just put the following for testing purposes:

... and the following error came up:
Verified answer

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi , @jharville
You can just Apply to each your "varActiveUsers" variable and you do not need to join them.
Apply to each action we need to pass a array instead of string type.
And if you do not have "current item" in dynamic content , you can just use the Expression here:
items('Apply_to_each')
The Apply_to_each is the action Name in my side. The space need to replace by '_'.

Best Regards,
Yueyun Zhang
jharville on at

Like
a
(0)

Report
Copy link

Link copied!

Works perfectly as intended now, thank you so much for your help!