How to configure dataverse in D365 for finance and operations

(0) Share

Report

Posted on by krishna.rao@dax

Hi Team,

We need to configure dataverse in D365 for finance and operations(D365FO), for below actions.

1. Once we configure dataverse in D365FO, we can see the data in dataverse in power platform portal, in tables - this contains data from D365FO

2. We will build power apps such as model driven, canvas by referring dataverse of D365FO in power platform - this contains data from D365FO

Please guide me how to do this configuration..

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (11)

Answers (1)

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @krishnapwa

There are quite a few options and mechanism to acheive that and this touches the overall solution architecture of your organization which needs careful analysis. However here are guides to the out-of-the-box option. Suggest to take the time to go through these links:

https://docs.microsoft.com/dynamics365/fin-ops-core/dev-itpro/power-platform/overview

https://docs.microsoft.com/dynamics365/fin-ops-core/dev-itpro/power-platform/admin-reference

Hope this helps!

Was this reply helpful? Yes No
krishna.rao@dax 42 on at

Like (0)

Report
Copy link

Link copied!

thanks for the prompt response.

please feel free to share blogs/articles on these configuration

Was this reply helpful? Yes No
krishna.rao@dax 42 on at

Like (0)

Report
Copy link

Link copied!
While doing health check in D365FO, prompted below error
'
Dataverse can connect to Finance and Operations apps
Before you can enable dual-write, you must grant access to the apps to connect to each other.
App user with ID: 6f7d0213-62b1-43a8-b7f4-ff2bb8b7b452
App user with ID: 2e49aa60-1bd3-43b6-8ab6-03ada3d9f08b'\

Please find below screenshot for reference..

Can someone please,, guide how to fix this error.

Was this reply helpful? Yes No
krishna.rao@dax 42 on at

Like (1)

Report
Copy link

Link copied!

the above issue has been fixed.

While syncing data entity 'payment days' getting below error, I am not sure why , it's a standard entity by the way. noticed that it's happening for every entity.
'Project validation failed. [DIPV1002] SourceEntitySchema: Payment days CDS has a primaryCompanyField set to DataAreaId and DestinationEntitySchema: msdyn_paymentdays doesn't have primary company field set. Dual-write only supports mapping between cross-company entities or company-specific entities from both sides.'

find below screenshot for the reference.

Can anyone please guide here..

Was this reply helpful? Yes No
Nitesh Sharma 2 on at

Like (0)

Report
Copy link

Link copied!

I am also getting same error,
Entity doesn't have primary company field set. Dual-write only supports mapping between cross-company entities or company-specific entities from both sides.

Any luck to fix this error.

Was this reply helpful? Yes No
Verified answer

RK800-1 34 on at

Like (0)

Report
Copy link

Link copied!

I figured it out yesterday. Firstly I recommend you to run a dual-write with a cdm_company (I hope you have this in your dual-write list, I had it - Picture 1). Then you should go to your msdyn_paymentdays table in PowerApps and create a row with a "Lookup" data type and link it with the Company table (Picture 2). The final step is to define this row in integration keys (Picture 3).

I hope this helps. I spent a day trying to resolve the same problem and it helped me.

Was this reply helpful? Yes No
RK800-1 34 on at

Like (0)

Report
Copy link

Link copied!

I solved this problem, check the answer above

Was this reply helpful? Yes No
abhisc 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @RK800-1 ,

The new company lookup row created doesn't show up in Integration Keys.
Should we create a Keys in Powerapps?

Was this reply helpful? Yes No
RK800-1 34 on at

Like (0)

Report
Copy link

Link copied!

Hi @abhizc
Yes, it is better to create all keys in Power Apps, however You can also create them in Dual write manually.

Was this reply helpful? Yes No
abhisc 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @RK800-1

We tried adding the keys but still facing the same error. The following are details:

Scenario 1:

In F&O:
Table: Fixed Asset V2, FixedAssetNumber is the Key

In PowerApps:
CustomTable: EX_FixedAsset Table,
Column1: New lookup to Company(cdm_company)
Column2: FixedAssetID

Key: fixedassetid

In the Integration Keys if we select the AssetID

We face the above mentioned error
or

Scenario 2

If we select,
Company.cdm_companycode in Integration Key

then there's an error for missing company field mapping
Even if we map to some other field it throws an error as the key fields are nor mapped

Was this reply helpful? Yes No