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 :
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
    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
    300,928 Super User 2025 Season 2 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
    300,928 Super User 2025 Season 2 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

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 512 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 291 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans