web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Need help importing Users through Excel

(2) ShareShare
ReportReport
Posted on by 4
Hello!
 
So i am new to Microsoft Dynamics 365 and Power Platform, and i have been going through some problems trying to import users. I created users in admin center and adding them one by one to power platform is easy (environments -> choose the environment -> add user). This works well, they are enabled and i can see that they have the Azure AD Object ID filled with the right value. But i needed to investigate how to add multiple users to admin center through excel (it was pretty easy too) and then how to add multiple users through excel on the power platform. For that, i used one of the templates provided for User. It has columns like bot provider, invitation status, email, name, etc. After filling the data, i went to environments -> marketing trial -> settings -> users -> Manage users in dynamics 365 -> import from excel. I uploaded the file, and imported it. The problem is that when i do it, the user is created as a stub user and when i go to check the User table in power apps, the user does not have the Azure AD Object ID filled. For this i just created a random Chris Green user in admin, and put all his info in the excel, so his info is correct however the import can not recognize him so it doesn't associate it with his Azure ID? I don't really know how it works and cant find it anywhere. I tried to put his Azure ID in excel, but in the review mapping before import, there is no option to connect that excel column to one of the available fields. Im really lost here and would appreciate some help.
 
Thank you in advance! 
Categories:
I have the same question (1)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Siv Sagar Profile Picture

Siv Sagar 93 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 80

#3
Martin Dráb Profile Picture

Martin Dráb 64 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans