cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sommes
Level: Power Up

Update CDS entity records when updated a record in D365 FinOps by using data integration project

Hello guys,

 

I've created a entity for project hour journals in CDS, which gets the data from Dynamics 365 F&O by using a data integration project. 

The first run takes all records of the entity, but if I change a record (e.g. the description), the data integration project try to create a new record on my CDS entity. It still tells me, that there is already a record with the same value in JournalBatchNumber.  

The CDS entity has got  an index, which is the JournalBatchNumber and DataAreaId (same as AX entity JournalTables).

Change tracking for the entity in AX is set for primary table. Also in my CDS entity.


How can I tell CDS or the data integration project that this records aren't new ones, rather they are update of existing records?

1 ACCEPTED SOLUTION

Accepted Solutions
Sommes
Level: Power Up

Re: Update CDS entity records when updated a record in D365 FinOps by using data integration project

Hey guys,

 

after some time I figured it out.
Apparently, the integration keys were no longer set properly. After they have been reset, the update has worked.
Nevertheless many thanks to you.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Update CDS entity records when updated a record in D365 FinOps by using data integration project

Hi @Sommes ,

Could you tell me how do you update data?
By using the patch function or submitform function?

If you use the patch function, modify record and create new record is a little different.

Modify:

Patch(table,the item that you want to modify,{...,...})

Create:

Patch(table,Defaults(table),{...,...})

 

Here's a doc about it for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sommes
Level: Power Up

Re: Update CDS entity records when updated a record in D365 FinOps by using data integration project

Hey guys,

 

after some time I figured it out.
Apparently, the integration keys were no longer set properly. After they have been reset, the update has worked.
Nevertheless many thanks to you.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (4,719)