Delegation warning on gallery data

(0) Share

Report

Posted on by Lefty

1,625

Hi,

I have a view containing information about a user, profiles and other items.

I have a SQL table containing profiles.

I have Gallery1, displaying data related to users and currently applied profiles to the user.

Gallery2 (it is not nested) containing all profiles and I have been trying to display only those profiles which have not been applied to the user.

Wondering if there is a workaround to the delegation warning I am getting on the Not part of the formula, as it does do what I need it to and only displays profiles which are not assigned to the selected user as part of the first gallery, but will come to a big blocker when the data goes over 2,000 records, which it will very soon.

GroupBy(
 
 Search(
 Filter(SQLDataSource, Not(Profile exactin Gallery1.AllItems.Profile)), 
 TextInpSearchProfile.Text,
 "Profile"), 
 "Profile", "ProfileX", "ProfileGroupedDATA")

Any suggestions to over come this?

Thank You

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WiZey 3,023 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @Lefty ,

I believe you can store more than 2 000 records in a collection, and delegation warning are only issued if you're working on an external datasource, so...

My suggestion is collecting your datasource in a collection, then apply the "Filter()" on the collection instead of the datasource.

Hope this was helpful to you.

Was this reply helpful? Yes No
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WiZey
This creates an unexpected issue, you may be able to help.
I have created a collection on App OnStart:
ClearCollect(colProfiles, SQLDataSource);

I have changed my original code to point to colProfiles on the Items property of my gallery

But I have checkboxes which oddly are throwing errors after I did the above 2 actions:

OnCheck and OnUnCheck I had the following:
Collect(colRoleToProfileChkBx, ThisItem)// OnCheck Remove(colRoleToProfileChkBx, ThisItem) //OnUnCheck
The error states The function select has some invalid arguments. Invalid argument type.
I'm unsure why this would break by using a collection on my items property in place of my SQL data table?

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

My guess is "colRoleToProfileChkBox" is populated elsewhere with a different structure.

Here, I'm guessing you "Collect()" an item from "colProfiles". Are you perhaps using other items from other sources to add/remove items in "colRoleToProfileChkBox"?

My other guess is... What function "Select()"? Are you using "Select()" somewhere?

Was this reply helpful? Yes No
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!

No idea, why it played up when I wrote my message, without changing anything (probably closed and re-opened) I no longer get any errors.
Thanks for your suggestions

Was this reply helpful? Yes No