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...
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
    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
    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…

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
iampranjal Profile Picture

iampranjal 41

#2
Martin Dráb Profile Picture

Martin Dráb 36 Most Valuable Professional

#3
Satyam Prakash Profile Picture

Satyam Prakash 35

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans