Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Custom fields not sync...
Finance | Project Operations, Human Resources, ...
Suggested answer

Custom fields not syncing to Dataverse entities

(0) ShareShare
ReportReport
Posted on by sjsbls 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,271 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.

  • Alexandra Socea Profile Picture
    Alexandra Socea on at
    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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans