Sync lookup field from Business Central to Dataverse

(5) Share

Report

Posted on by Hagru

311

Hello!

I have set up a Standard Integration between Business Central and Dataverse. I managed to add a sync between a custom table in BC, to a custom table in Dataverse, and it worked well when testing a few fields.

However, I stumbled upon an issue when I tried to map a field that contains the customer, as I get the following error when trying to map the field:

The field is just like the "Sell to Customer No." from Sales Orders for example, just a lookup to the Customer table, and it contains the code value of the No. of the customer.

My reason for mentioning the Sales Order, is there is a mapping between the Sales Order customer and the account in Dataverse. Same with the Item on Sales Order Lines. They're just lookups to a different table, just like my field.

How can I map this field to a field in Dataverse?

Categories:

Power Platform integration

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Hagru 311 on at

Like (0)

Report
Sync lookup field from Business Central to Dataverse

I figured this one out myself, and it was a lot simpler than I thought it would be.

Every other guide or documentation I followed only mentioned standard text fields, but never explained how to sync FlowFields.

The first time I added a new field, I followed this guide : https://bccaptain.com.au/2023/07/18/crm-integration-add-custom-field-to-existing-crm-table/

And I remembered adding event subscribers to add the fields, but again, they were only text fields.

I figured I would try it either way, but I didn't have a Codeunit to subscribe to, so I just added a button to the Integration Field Mapping page instead to generate the mappings. It worked perfectly, and it syncs to CRM, where it is also related to the customer account in Dataverse.

'NPX_CONTRACTHEADER' is the name of the table mapping I had set up.

pageextension 55000 IntegrationFieldEXT extends "Integration Field Mapping List" { actions { addfirst(Processing) { action(AddMapping) { ApplicationArea = All; trigger OnAction() var IntegrationFieldMapping: Record "Integration Field Mapping"; NPXContract: Record "NPX Contract Header"; CRMContract: Record "CDS new_e_npxcontractheader"; begin IntegrationFieldMapping.CreateRecord( 'NPX_CONTRACTHEADER', NPXContract.FieldNo("Source No."), CRMContract.FieldNo(new_e_SourceNo), IntegrationFieldMapping.Direction::ToIntegrationTable, '', false, false ); end; } } } }

Was this reply helpful? Yes No