Hello All,
I built a canvas app with a data connection to SharePoint list which has 18 columns and 63 rows. I connected this data source to my canvas gallery and i am pulling 16 rows and all rows. I have also setup multiple filters so that users can filter based on four categories.
I noticed that when i select the first filters it takes about 2-3 seconds for it to work. Also when I do vertical scrolling this gallery takes about 1-2 seconds. Because of the lag i tried using a collection but there was no performance improvements
Here is my on start rule :-
Concurrent(
ClearCollect(
Masterdata,
'2021 Worldwide RA Milestone Dashboard'
),
Set(
Currentuser,
Lower(Office365Users.MyProfile().GivenName)
)
);
If(
Or(
Currentuser = "amber",
Currentuser = "vineet"
),
Set(
ReadEditcontrol,
DisplayMode.Edit
) && Set(
AdminView,
true
),
Set(
ReadEditcontrol,
DisplayMode.Disabled
) && Set(
AdminView,
false
)
)
Here is my gallery item formula
Filter(
Masterdata,
IsBlank(FranchiseComboboxFilter_1.SelectedItems.Result) || IsEmpty(FranchiseComboboxFilter_1.SelectedItems) || Franchise in FranchiseComboboxFilter_1.SelectedItems,
IsBlank(RegionFilter_1.SelectedItems.Result) || IsEmpty(RegionFilter_1.SelectedItems) || Region in RegionFilter_1.SelectedItems,
IsBlank(CountryFIlter_1.SelectedItems.Result) || IsEmpty(CountryFIlter_1.SelectedItems) || Market.Value in CountryFIlter_1.SelectedItems,
IsBlank('RA Contact Filter_1'.SelectedItems.Result) || IsEmpty('RA Contact Filter_1'.SelectedItems) || 'RA Contact' in 'RA Contact Filter_1'.SelectedItems
)
Would appreciate any help 🙂
Thank you in advance !!
