Delegation Issues

[boscarikn2]

Hello everyone,

I have a Power App where users can enter their priorities and accomplishments for the month to be seen by leadership where the backend data is stored in a Sharepoint List. I have a gallery that displays the user's recent entries (past 3 months) and their direct report's recent entries (past 3 months). I have hit my 2000 row item limit on my Sharepoint List and am now experiencing delegation issues. 

Image of the app for reference (blurred out data and names):

I tried to resolve this problem by creating a collection upon App Start. I wanted to make a subset of my larger dataset based on the entries being from the user or their direct reports using the following:

Filter('Priorities and Accomplishments', Email = Office365Users.MyProfile().Mail || Email in Office365Users.DirectReports(MyProfile().Mail).Mail)

However, "or" (||) and "in" are both non-delegable functions. 

I put in a band-aid fix in my Gallery Items code so that the Sharepoint List is sorted in most recent order because for now, the data needed will be within the 2000 most recent entries. Over time that won't always be true. Code here:

With(
{
BandAidFix:
Sort('Priorities and Accomplishments',
ID,
SortOrder.Descending)
},

Any ideas on how I can shrink this dataset down using delegable functions so that I can do further data manipulation in my gallery? I have been trying different solutions for weeks and still running into delegation issues. I would greatly appreciate any help.

[RogierE · Accepted solution]

Have you considered creating the collection in a few steps in stead of in one go? 

You could do something like this maybe in your OnStart ( I am using colMyCollection as a name for your collection, you might have named it differently): 

ClearCollect(colMyCollection,Filter('Priorities and Accomplishments', Email = Office365Users.MyProfile().Mail));
ForAll (Office365Users.DirectReports(Office365Users.MyProfile().Mail) As Report,
    Collect(colMyCollection,Filter('Priorities and Accomplishments', Email = Report.Mail))
)

So you first collect the direct prio's and accomplisments of the user, and then add anything registered by any of their reports. No more delegation warnings when I tested this!

Please like the reply and/or accept it as the solution if the answer is what you were looking for.

[boscarikn2]

Hi @RogierE ,

Thank you so much for sending that solution! It makes total sense to me and it should work. However, and I don't know why, but when I put this code into the app's OnStart, it returns no data. I reduced it down to the most basic element I could and still get no data, as seen in the screenshot below:

Are you not supposed to use Filter in the app's OnStart? Does the data not load yet for some reason? 

[RogierE]

Is this the full code that you put into your OnStart? 

Now you're filtering some data but not saying what OnStart should do with the outcome 🙂 

You should add some action to it, for example Set or ClearCollect. 

And two more things to know about OnStart: 

- it doesn't run if there is any errors in the code. (so that is why your preview is one reason why the preview is empty now

- it doesn't run automatically when you are Editing your App. After coding and debugging your code you should right-click the App in the tree view and choose Run Onstart in the quick menu: 

Please like the reply and/or accept it as the solution if the answer is what you were looking for.