Showing results for 
Search instead for 
Did you mean: 
Continued Contributor
Continued Contributor

Add users to a team - Bulk method


I'd like to create a powerapps that can add bulk users to a team

The idea is as follows:

1. Select the team 

2 - Paste the email address of users

3 - Resolve the email address to upn

4 - add users to the team


Actually the apps is working for one user.


If i paste a email address, the resolving to upn is working and i can add the users to the team.



But if i add a second address, the resolving fails




It's a text input. My formula is 'Utilisateursd’Office365'.UserProfileV2(TextInput3.Text).userPrincipalName


If you have a tip to share ?

Thank you



Responsive Resident
Responsive Resident

Hi @ALP1 ,


Please clear the textbox before entering the second address. I propose displaying the users who have already been added to the team in a separate list box control for the specified team. Because ’Office365'.UserProfileV2 accepts only one email to validate. 

Continued Contributor
Continued Contributor

Thank you. Sometimes, some users in my company need to add 200 users at the same time. 

At first, i was thinking to use the plugin excel trigger but office store is blocked ! I can't download it. damned

I was hoping to use a comma or a semicolon to leverage the limitation of the office365 connector.


I need to find another way to do that. thank for your help

Responsive Resident
Responsive Resident

@ALP1 - How about we add names to gallery and then use ForAll to iterate items and add to teams in single shot. 

Continued Contributor
Continued Contributor

very interesting. I will give a try tomorrow

Helpful resources

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,700)