Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Dataverse User Table Sync
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Dataverse User Table Sync

(1) ShareShare
ReportReport
Posted on by Bahalzamon
I have an open environment, meaning that all users are automatically within the environment.
I see some fields are just auto synced from Azure.
 
I am wondering a few things:
  • Is there a way to add additional fields to sync?
  • Is there a way to detect additions/modifications to azure users that can trigger a flow to update some additional information within Dataverse?
 
Best case scenario I would like to pull down the Department and Office Location. :)
  • Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Dataverse User Table Sync
    Hi,
     
    Has the issue been solved?
    Have there been any updates? Please feel free to ask me if you have any questions!
    If it has been resolved, can you mark the response as an answer?
     
  • Suggested answer
    Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Dataverse User Table Sync
    Hi,
     
    For the first question.
    You can create a Power Automate Flow to get the user's information from Azure AD to update the user table record.
    Take updating this user as an example.

     
    The GUID of the record can be retrieved via Xrm.Page.data.entity.getId(); 
     
    The Department field and the Office field need to be added to the users table in advance.
     
    The run is successful, and the Department and Office fields are automatically populated for this user.
     
     
    For the second question.
    Changes to users can be seen within Azure.
     
    You can create a Power Automate Flow to monitor the user entity record changes.
     
     
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
    If you have further questions, please feel free to contact me .
     
    Best Regards,
    Dengliang Li
     

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans