Power Platform Community Forum Thread Details

My gallery takes about 10 seconds to load, which is too slow. And there are only 20+ records.

I am not sure what I did wrong, could you please help to advise how to improve the performance?:

This is the Items property of the gallery:

DropColumns(
	SortByColumns(
		AddColumns(
		Filter(ProjectsList, OpportunityStatus.Value="Approved" && (StartsWith(Title,txtSearch_1.Text)||StartsWith(ProjectLead.DisplayName,txtSearch_1.Text)) && (ProjectStatus.Value in FilterComboBox_1.SelectedItems.Value || FilterComboBox_1.Selected.Value = Blank()
 ))
 ,"projectstatus_value",ProjectStatus.Value
 ,"projectpriority_value",Priority.Value
 ),
		varSortColumnPL,
		varSortDirectionPL
 ),
		"projectstatus_value",
 "projectpriority_value"
)

This is the declaration of ProjectsList in my App OnStart function. I used the collection to avoid delegation issues:

ClearCollect(ProjectsList,
 AddColumns(
 ContinuousImprovementProjects As CIProjects,
 "EarliestMilestoneStartDate",
 First(
 Sort(
 Filter(
 'CI Milestones' As CIM1,
 CIM1.ProjectID=CIProjects.ID)
 ,MilestoneStartDate,
 SortOrder.Ascending
 )
 ).MilestoneStartDate,
 "LatestMilestoneEndDate",
 First(
 Sort(
 Filter(
 'CI Milestones' As CIM2,
 CIM2.ProjectID=CIProjects.ID)
 ,MilestoneEndDate,
 SortOrder.Descending
 )
 ).MilestoneEndDate,
 "LatestCompletionEndDate",
 First(
 Sort(
 Filter(
 'CI Milestones' As CIM3,
 CIM3.ProjectID=CIProjects.ID && CIM3.MilestoneStatus.Value="Completed")
 ,MilestoneEndDate,
 SortOrder.Descending
 )
 ).MilestoneEndDate,
 "LatestRequest",
 First(
 Sort(
 Filter(
 'CI Requests',
 ProjectID=CIProjects.ID)
 ,RequestDesc,
 SortOrder.Descending
 )
 ).RequestDesc,
 "LatestRequestDate",
 First(
 Sort(
 Filter(
 'CI Requests',
 ProjectID=CIProjects.ID)
 ,Created,
 SortOrder.Descending
 )
 ).Created,
 "LatestUpdate",
 First(
 Sort(
 Filter(
 'CI Updates',
 ProjectID=CIProjects.ID)
 ,UpdateDesc,
 SortOrder.Descending
 )
 ).UpdateDesc,
 "LatestUpdateDate",
 First(
 Sort(
 Filter(
 'CI Updates',
 ProjectID=CIProjects.ID)
 ,Created,
 SortOrder.Descending
 )
 ).Created
)
);

Categories:

Building Power Apps