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

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Dataverse User Table Sync

(1) ShareShare
ReportReport
Posted on by 2
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. :)
I have the same question (0)
  • Suggested answer
    Dengliang Li Profile Picture
    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
     
  • Dengliang Li Profile Picture
    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?
     

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade 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 92

#3
Martin Dráb Profile Picture

Martin Dráb 67 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans