Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Power Platform integration forum
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Reduce Datasource size for Modeldrivenformintegration Object in Embedded Canvas App

Posted on by

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

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans