Finance | Project Operations, Human Resources, ...

Custom fields not syncing to Dataverse entities

(0) Share

Report

Posted on by sjsbls

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

All responses (5)

Answers (0)

Sort by

Alexandra Socea Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Sam,

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

Like (0)

Report
Copy link

Link copied!
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.
Suggested answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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 80 on at

Like (0)

Report
Copy link

Link copied!

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.
Community Member on at

Like (0)

Report
Copy link

Link copied!

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?