Showing results for 
Search instead for 
Did you mean: 
Not applicable

Does the prospect to cash scenario works as planned?

What do I mean?

We are using the common data model to feed other system with the "When a record is updated"-trigger in Logic Apps.
We are getting data into the CDS with the prospect to cash scenario (synchronise data between D365fO and the CDS).
So far so good.


My expectation is:

  1. When I change in D365fO one record, after synchronisation CDS mark it as modified
  2. When I dont change records in D365fO, after synchronisation CDS information aren't updated (not modified)

What really happens:

Everytime I start the sync all CDS records will be mark as modified, but I haven't changed them.


This leads me to the question.. I misunderstand the common data model/service?



Kind regards,


Community Support
Community Support

Hi @Anonymous,


Can you share your detailed configuration of the Flow triggred by the app?


Also, you cannot actually synchronise data between D365fO and the CDS as this is 2 way thing but flow can only do it one way.




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable

Hey @v-monli-msft,



I agree with you that the CDS can only "export" data via flows, thats clear so far.

The foreign/third party system would e.g. generate a new record directly on D365fO (via OData), so next sync would push the data into CDS.

But my message was about the export trigger "When a record is updated" itself, which mark existing record in the CDS as modified when the synchronisation is running. But I don't change any record on D365fO side.


My setup:



What I additonally can say the modified timespamp in the data view of the vendor entity, was set to the time of sync.
That implements that the trigger would run for each record although no one record was modified in D365fO.
So I would give you some overviews of the logic app and the execution but this stupid project killed my whole MSDN credit for Azure.

If you need a more detailed description let me know.

Thank you for your feedback, Mona!

Kind regards,

Not applicable

I got a response of the PRINCIPAL PROGRAM MANAGER of Microsoft in another forum:
"Prospect to Cash uses bulk APIs to upload data. So, it avoids the trigger logic by default. We can enable this but have not currently done so."

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,914)