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

[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!

[v-yueyun-msft]

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]

@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]

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]

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:

[v-yueyun-msft · Accepted solution]

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]

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