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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Import users

(0) ShareShare
ReportReport
Posted on by 4,131

Hi expert,

In D365FO, is it possible to provide a spreadsheet to the customer and import the users? My question is if the spreadsheet contains the email, name, userId, etc, will D365FO create the users and integrate with AAD?

Thanks,

I have the same question (0)
  • AJJAIS Profile Picture
    Microsoft Employee on at

    hello Yuji, Why do you not try- docs.microsoft.com/.../import-bulk-users. How are you trying to use Import by excel option?

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    305,182 Super User 2026 Season 1 on at

    Hi Yuji,

    This is possible with Power Automate or data management. There is a data entity for users available.

    You can read about using the User with Power Automate on my blog: How to setup demo users in Microsoft Dynamics 365 for Finance and Operations - Dynamicspedia. This is a different scenario, but it is using the entity for managing users (SystemUser).

    In another blog, I used an example to export and import users and security information using data management: Move all user and security settings with data entities - Dynamicspedia

    Can you explain what exaclty you mean with "integrate with AAD"? Is import of users enough or do you expect more like creating users in AAD?

  • Jorge_ Profile Picture
    on at

    Hi Andre Arnaud de Calavon

    To do the user import from AD in PowerAutomate, it is just creating a SystemUser record?

    Thanks

  • André Arnaud de Calavon Profile Picture
    305,182 Super User 2026 Season 1 on at

    Hi Jorge,

    Can you create a new question on the forum and explain what you want to achieve? Or do you have a follow up question on my reply? If so, please rephrase your question as I'm not sure what you are asking.

  • Jorge_ Profile Picture
    on at

    Thanks Andre.

    Got answer to my question, the action to import user in F&O can be done in Power automate creating a SystemUser record.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 699

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 582 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 493

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans