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 :
Small and medium business | Business Central, N...
Suggested Answer

Dataverse Connection Sync "User" field error

(1) ShareShare
ReportReport
Posted on by 30
Hello, I am integrating data between dataverse and business central. I have a table named X includes /cr334_SystemUser/ lookup column (related systemuser table) in dataverse, also I have a table named X includes /User/ field with table relation to /User/ (system table). When I tried to sync these tables, it gives below error:
The data could not be updated because of the following error: Table User must be mapped to table CRM Systemuser to transfer value between fields User and cr334_SystemUser.
 
There is no sense mapping these tables because both are system tables and automatically includes data.
I added these tables to integration table mapping but I could not manage to couple records, so this time X table syncing gives another error like /This user record is not a coupled record in dataverse/.
 
Any ideas how to resolve this issue?
I have the same question (0)
  • Suggested answer
    Judy Profile Picture
    Microsoft Employee on at
    Hi, for the error messages, please go to the Integration Table Mappings form to map the fields user and cr334_SystemUser:
  • mertadsay Profile Picture
    30 on at
    thanks for your response but they are already mapped. Actually reason of the error is these fields are mapped. When I remove mapping sync works great, but I cant synchronize the user fields.
  • Judy Profile Picture
    Microsoft Employee on at
    Hi, thanks for your response.
    In the Resolve Deletion Conflicts and Resolve Update Conflicts columns, you can specify how Business Central will resolve conflicts that occur because records were deleted in tables in one or the other business application, or updated in both.
    The reference MS document:
    Hope it helps.
     
    Best Regards,
    Judy

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans