Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

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:
MDFI - Datasource operation.PNG

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.

Thank you all


Helpful resources

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,480)