Delegation Test on SharepointList

[SGavoux]

I make an simple application from a online 365 Sharepoint List but when i test this with data row limit 10 or fewer records (from advanced settigs) delegation function Filter (with '=') and startwith() dont work property. This is ok or my app will be has problem after 2000 records on delegation ? 

Online Sharepoint List support delegation or not?

Thanks Community

[R3dKap]

Hi @SGavoux,

Delegation issues can appear even if you only use '=' or 'StartsWith'. Indeed, it alos depends of the data type of the columns you use in your Filter function. All complex types like Lookups, Choices, ID column, etc. lead to a delegation issue.

What's the content of your filter function ?

Emmanuel

[SGavoux]

I use default HelpDesk Template - and yes this has ID and Choices in Sharepoint List Field that is the problem ???

here my code from Gallery Object->Items

If(isAdmin,Sort(AllTickets,Created,Descending),Sort(Filter(vAllTickets,'Created By'.Email = MyProfile.Mail || 'Created By'.Claims = MyProfile.UserPrincipalName),Created,Descending))

When i use filter or startwith() after short funtction dont work

[R3dKap]

No, having ID and/or choices columns in your list is not the problem.

But, using ID and/or choices columns in a Filter function generates a delegation warning. This will not be a problem if you have less than 2000 records in your list, but if you ever get more, the results of your Filter could be wrong.

About your formula, I would change it to:

Sort(If(isAdmin,AllTickets,Filter(AllTickets,'Created By'.Email = MyProfile.Mail || 'Created By'.Claims = MyProfile.UserPrincipalName)),Created,Descending)

I remove the "v" letter in the "Sort(Filter(vAllTickets," part of your formula because I guessed it was a typing error...

But before you try the formula above, please try filtering on the mail only first (because I'm not sure about Claims having the same content than UserPrincipalName), and please add a Lower function to make sure that emails comparison will be cases independant:

Sort(If(isAdmin,AllTickets,Filter(AllTickets,Lower('Created By'.Email) = Lower(MyProfile.Mail)),Created,Descending)

I suppose your MyProfile variable was filled using the User() function.

Waiting for your reply,

Emmanuel

[SGavoux]

I try this very simple code 

SortByColumns(Alltickets,"Title", Descending)

but not work 😞 

IF Found something..

My big problem is use of collection (Alltickets) when replace this code with name of sharepoint list app works. Me old original code still not working 😞

[v-xida-msft]

HI @SGavoux ,

Could you please share a bit more about your scenario?

Do you want to test the Delegation row limit within your app?

Based on the needs that you mentioned, I have made a test on my side, and don't have the issue that you mentioned, the "Data row limit for non-delegable queries" functionality works well.

The "Data row limit for non-delegable queries" functionality would take effect when there is some Delegation issue within your formula. In addition, you need to re-publish your app to force this functionality to take effect.

O your side, please consider take a try to re-generate a new app based on your SP list data source, then set the Items property of the Gallery to following:

If(
   isAdmin,
   Sort(AllTickets, "Created" ,Descending),    /* <-- Please type "Created" rather than Created. The Created column should be wrapped with double quotes ("")*/
   Sort(
         Filter(AllTickets,'Created By'.Email = MyProfile.Mail || 'Created By'.Claims = MyProfile.UserPrincipalName), 
         "Created" ,
         Descending
   )
)

then change the "Data row limit for non-delegable queries" option to 10 or lower value within the Advanced settings of App settings of your app, save (or re-publish) your app. Run your app again, check if the "Data row limit for non-delegable queries" functionality takes effect.

Best regards,

[SGavoux]

Ok i procces...

this part of code work ok for admin 

If(isAdmin,Sort(HelpDesk,Created,Descending))

/*SortByColumns(Filter(HelpDesk,'Created By'.Email=MyProfile.Mail),"Created"))*/

The problem (blue line) is on Created By'.Email

i still searching.......

[v-xida-msft · Accepted solution]

Hi @SGavoux ,

Currently, within PowerApps, the Complex type columns (e.g. Choice, Lookup, Person or Group, Task Outcome, External Data, Managed Metadata) in SharePoint list data source could not be delegated.

Please check the following article for more details:

https://docs.microsoft.com/en-us/connectors/sharepointonline/#powerapps-delegable-functions-and-oper...

The 'Created By' column is actually a Person type column in a SP list, so it could not be delegated in SharePoint list data source.

More details about Delegation in PowerApps, please check the following article:

Delegation

Best regards,

[SGavoux]

To the point!

But i need a field with creator of a ticket. How can i get this value and insert that in sharepoint list with submit form ?

Thank you for help