Microsoft Dynamics 365 | Integration, Dataverse...

Dual-write failing with “Unable to lookup values for entity teams” after new legal entity

(2) Share

Report

Posted on by JG-30051243-0

Dual-write fails with “Unable to lookup values for entity teams” and then cascades into reference data lookup errors (currency, groups).

All data exists in Dataverse. Issue started after adding a new legal entity. Followed Microsoft learn article to add a legal entity and sync data. Since the new legal entity set up - unable to use dual write from F&O > CE. From CE > F&O - there is no issues.

This issue is happening in all forms with dual write running - when trying to change something in F&O - different versions of the same error message. I believe this is stemming from the fact that my company (legal entity) team in powerplatform may have different owners? But I am not sure how to go about fixing this. Any assistance would be great!

Categories:

Power Platform integration

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Navneeth Nagrajan 2,538 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @JG-30051243-0,

A few questions:
1. Have you mapped integration keys or field lookups for entities like teams, currency or groups

2. Are you doing any transformation on the lookup fields?

3. Do you have a matching Company record that exists in Dataverse.

The error "Unable to lookup for entity teams" and subsequent data lookup fails often when,

1. The Legal entity in F&O needs to be mapped with the cdm_company in Dataverse.

2. The new LE in D365 F&O needs to be mapped with the cdm_Company in dataverse. The cdm_company needs to be mapped with the business unit in D365 CE.

3. The dual write connection set includes new legal entity and its associated business unit.

Was this reply helpful? Yes No
JG-30051243-0 9 on at

Like (0)

Report
Copy link

Link copied!

@Navneeth Nagrajan - thank you for responding.

Have you mapped integration keys or field lookups for entities like teams, currency or groups - There are intergration keys for company - but does there need to be others? -

2. Are you doing any transformation on the lookup fields? - No - we are not

3. Do you have a matching Company record that exists in Dataverse. - Yes - the company exists in Dataverse.

All was working well until we make two changes:

1 - installed project opertions

2 - created new legal entity to integrate with project operations

Your continued support is appreaciated.

Thank you!

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

HI,

The error is stating that the integration user needs to have read access to the table msdyn_globalproducts in Dataverse.

You will need to assign the default owning team to security roles having read access to this table. See also: Set up dual-write security roles and permissions - Finance & Operations | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No