Unanswered

Import users from excel into Dataverse team

(0) Share

Report

Posted on by Nikhil-Airun

I'm required to add about 2000+ Users in a Dataverse Team, only way I see is to manually search each person by email id and add. That seems like a ridiculously large manual effort. Any creative idea to be able to automate this? Many thanks

Nov 23, 2022: Let me add more info (based on personal exploration) -

There are 2 tables in Dataverse - User and Teams. I already have folks in User table and also a Team created in Team table. What I'm looking for is, how to relate 2000+ selected users to specific team record. In Dataverse teams, I found there's a many to many relationship called teammembers_association created that stores the record relation between User and Team table records. I can't find a way to bulk define/upload this relationship between User and Team table records. For ex: I want to add Paul and Michael to Team1, How can I do that by uploading an excel somewhere which has Paul and Michael's email IDs and it should automatically add both to Team1 in Dataverse security. Hope it provides more clarity.

Another aspect is, let's say - even if I have manually done this with Advanced settings -> Security -> Teams -> Add users way, How do I move this association/related data to another environment?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

AhmedSalih 6,678 Moderator on at

Like (0)

Report

Hello, @Nikhil-Airun, check this solution for @dpoggemann https://powerusers.microsoft.com/t5/Microsoft-Dataverse/quot-Users-quot-table-in-Dataverse-for-Teams/td-p/1301547

Was this reply helpful? Yes No
Nikhil-Airun 11 on at

Like (0)

Report

Thanks @AhmedSalih for reply, but I think it is a different problem. I have updated my original post with more info, to provide more clarity on my problem.

Was this reply helpful? Yes No
Fubar 8,344 Super User 2025 Season 2 on at

Like (0)

Report

Not sure if it still works, but look at the NN Relationship Manager in XrmToolBox - allows you to update the intersect table by importing a file with values for both sides of the N:N

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @Nikhil-Airun ,

You should be able to create this association through a Power Automate flow, I just ran through a small test and it worked well.

The Bound Action is the following:

In my simple test I did the following:

1. Triggered flow manually and entered an email address

2. Found the users that matched this email address

3. Got the user record

4. Searched for and found the Team record

5. Got the team record

6. Used the bound action to add the user to the team. You will see a collection of a ton of fields on the system user but I just searched for systemuserid and then set the value (note, there is a parent_systemuserid as well so don't set the wrong one 🙂

This added my user to the team. You should be able to use this methodology in general to loop through your users and find your specific team and add them hopefully.

Was this reply helpful? Yes No