Reduce Datasource size for Modeldrivenformintegration Object in Embedded Canvas App
Hi all, We are having a rather specific scenario in our embedded canvas app in Dynamics 365 Sales Opportunity form.
The embeded app is always working only in the context of ONE opportunity at time, i.e. the user will work in the same opprotunity in the app as in the main form. Modeldrivenformintegration.Datasource = [@Opportunities] The embedded canvas app is on a tab of Opportunity main form. We are struggling with the app performance and one of the biggest hiccups is the time the app is getting rows form Opportunity:
I tried using an Opportunity view in the Datasource to reduce the number of rows but it seems it is still loading all the rows and only then the filter is applied...
The point is that in our scenario we always only need one specific row from the Opportunity entity, but it is to be a dynamic value based on the main form opportunity id. Is there any trick or workaround how to avoid loading the whole entity? I wonder if anyone has come across any similar scenario.