Skip to main content

Notifications

Dynamics 365 Community / Forums / Human Resources forum / Custom fields not sync...
Human Resources forum
Suggested answer

Custom fields not syncing to Dataverse entities

Posted on by 80

Hello,

We have deployed a set of custom fields on the Worker entity on both test and production environments - which are then referenced in PowerApps. These PAs use the Worker dataverse table (cdm_worker - not the virtual worker table) as a data source. For this, we have exposed the custom fields to said entity.

However, something is breaking down so that a set of fields flat out refuse to be added to the DV table. Other fields have made it, but others haven't - with the only difference being the name/labels of the fields. The main entity from the HR POV we're publishing to is cdm_worker/CDSWorkerEntity but we've even tried applying the field to all other tables to no success.

Is there something within Dataverse/D365HR that will allow us to force these to be synced? I've tried going through the DV config page on HR and syncing the table but nothing appears to have changed - over 24 hours after applying the changes/syncing.

Thanks,
Sam

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Custom fields not syncing to Dataverse entities

    Hey Sam,

    We ended up running into this once too. I have a question, did you make any changes to the table in the dataverse? I know for me, I ended up making the DV table related to another table which stopped the sync. Do you think there have been any changes to the DV table?

    Additionally, and I am sure you did this, but does your field show up when you Generate Mapping?

    (Data management --> Entities --> [Your Entity, hcmWorker...] --> Modify Target Mapping --> Generate Mapping

    Afterward, when you sync to the DV is there any error? When you try and Sync/Generate the DV Table? 

    Lastly, if you type in the search Process Automation, and then you go to Background Processes, are there any errors?

  • sjsbls Profile Picture
    sjsbls 80 on at
    RE: Custom fields not syncing to Dataverse entities

    Hi Parag,

    Unfortunately the entity in question has the maximum custom fields on, however this is occuring for multiple of them, not just the Tuesday WFH field mentioned previously.

  • Suggested answer
    Parag Chapre Profile Picture
    Parag Chapre 12,250 Most Valuable Professional on at
    RE: Custom fields not syncing to Dataverse entities

    Hi Sam,

    It looks strange to me. If one field can sync with the database and other then it is weird. Did you try to create any kind of test field for example Test123 or Demo123 and custom field setup +  sync with dataverse. Is it working?

  • sjsbls Profile Picture
    sjsbls 80 on at
    RE: Custom fields not syncing to Dataverse entities

    Hi Alexandra,

    Field that has synced:

    • Prefix: blsSundayWFH (blsSundayWFH_Custom)
    • Type: Checkbox
    • Label: Sunday WFH
    • Entities:
      • AadWorkerIntegrationEntity
      • CDSWorkerBaseEntity
      • CDSWorkerEntity
      • DimAttributeHcmWorkerEntity
      • EssWorkerEntity
      • HcmBIWorkerNameEntity
      • HcmEmployeeEntity
      • HcmWorkerEntity
      • HcmWorkerPersonalDetailEntity

    Field that hasn't synced:

    • Prefix: blsTuesdayWFH (blsTuesdayWFH_Custom)
    • Type: Checkbox
    • Label: Tuesday WFH
    • Entities:
      • AadWorkerIntegrationEntity
      • CDSWorkerBaseEntity
      • CDSWorkerEntity
      • DimAttributeHcmWorkerEntity
      • EssWorkerEntity
      • HcmBIWorkerNameEntity
      • HcmEmployeeEntity
      • HcmWorkerEntity
      • HcmWorkerPersonalDetailEntity

    No help text on any of the fields.

  • RE: Custom fields not syncing to Dataverse entities

    Hi Sam,

    Can you share with us an example of a field that was synced to DV and one that has not?

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

News and Announcements

Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans