web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Performance Issue with...
Power Apps
Unanswered

Performance Issue with Large Datasets Using 'in' Function in Power Apps

(1) ShareShare
ReportReport
Posted on by 9

Hello Power Platform Comunity,

I am experiencing a performance issue in Power Apps when working with large datasets. Specifically, I am using the "in" function to filter records from a large data source. _CGAPPS_MP2_Elementi_DN is a sql view that has 300.000 elements other databases are always less than 2000elements.

 

Here is the current formula I am using:

 

Problem is in "UsedMaterials":

ClearCollect(temp1,Filter('Mala potreba',VkljucenovMP=true));//all elements included in MP
ClearCollect(DynamicRecord, Distinct(temp1,'Naziv projekta'.Value));//active projects

 

Clear(Test1);
ForAll('Mala potreba',
 Collect(Test1, {
 Ident: Ident,
 IdentNaziv: Naziv,
 IdentKrom: LookUp(_vBI_2MB_Profili,acIdent12=Ident).acIdent5150,
 Ident9001: LookUp(_vBI_2MB_Profili,acIdent12=Ident).acIdent5120,
 Ident9002: LookUp(_vBI_2MB_Profili,acIdent12=Ident).acIdent5130,
 Ident9010: LookUp(_vBI_2MB_Profili,acIdent12=Ident).acIdent5110,
 Ident1015: LookUp(_vBI_2MB_Profili,acIdent12=Ident).acIdent5140,
 UM: EM,
 UsedMaterial: Sum(Filter(_CGAPPS_MP2_Elementi_DN, acCostDrv in ["24/226", "24/227", "24/228"] && Ident=acIdentItem), anCalcQty) 
 }));
UsedMaterial: Sum(Filter(_CGAPPS_MP2_Elementi_DN, acCostDrv in DynamicRecord && Ident=acIdentItem), anCalcQty) 

 

 

 

DynamicRecord can have from 1-50 elements

How can I come around this. I want to filter like this but with DynamicRecord that I'm collecting one step before:

 

 

UsedMaterial:Sum(Filter(_CGAPPS_MP2_Elementi_DN(acCostDrv=Value1||acCostDrv=Value2||acCostDrv=Value3...)&& Ident=acIdentItem), anCalcQty) 

 

 

 

 

Thank you

Categories:
I have the same question (0)

Under review

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

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 421

#2
WarrenBelz Profile Picture

WarrenBelz 386 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 339 Super User 2025 Season 2

Last 30 days Overall leaderboard