Delegation Warning - Excel Sharepoint

(0) Share

Report

Posted on by jayceeb

Hi please help,

I just transferred all my excel file from sharepoint and change my connection from Onedrive to Sharepoint.

however the delegation errors appear and in addition the Or operation is not supported.

Sum(Search(Filter(
BreakageT,
DateValue("Date") <= DatePicker2.SelectedDate,
DateValue("Date") >= DatePicker1.SelectedDate,Radio1.Selected.Value = "All" || Section=Radio1.Selected.Value,'Report As'="Breakage"),TextSearchBox.Text,"DESCRIPTION","ITEM CODE","Section","Location","Report As"),'Total Count')

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,922 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jayceeb ,

There is no issue with Or, but Sum and Search are not Delegable - try this

With( { wList: Filter( BreakageT, DateValue("Date") <= DatePicker2.SelectedDate && DateValue("Date") >= DatePicker1.SelectedDate && ( Radio1.Selected.Value = "All" || Section = Radio1.Selected.Value ) && 'Report As' = "Breakage" ) }, Sum( Search( wList, TextSearchBox.Text, "DESCRIPTION", "ITEM CODE", "Section", "Location", "Report As" ), 'Total Count' ) )

but note that the top filter needs to return record numbers under your Delegation limit to get the correct result.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
jayceeb 94 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks I'll try this one.

how about the combo box issue? it's not working also.the search function is not searchable due to same connection to sharepoint?

Was this reply helpful? Yes No
WarrenBelz 155,922 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@jayceeb ,

You did not mention the Combo Box code - what is the issue with it ? What is not working with the Search ?

Was this reply helpful? Yes No
jayceeb 94 on at

Like
a
(0)

Report
Copy link

Link copied!

It's working fine in onedrive but when it comes to excel sharepoint it shows this error.\

Was this reply helpful? Yes No
WarrenBelz 155,922 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@jayceeb ,

The code that is causing that error and where it is being used would help greatly.

Was this reply helpful? Yes No
jayceeb 94 on at

Like
a
(0)

Report
Copy link

Link copied!

I used combobox and the source is ItemCode. now I want to search items for Description and Item code. in my search field I used ["DESCRIPTION","ITEM CODE"] however it does not work and gives me an error but when I used my current app its working fine. any idea please

Was this reply helpful? Yes No
WarrenBelz 155,922 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@jayceeb ,

What is the Items of the Combo Box ?

Was this reply helpful? Yes No
jayceeb 94 on at

Like
a
(0)

Report
Copy link

Link copied!

the items are " CART, GLASSES, WINE + 394 items etc..

Was this reply helpful? Yes No
WarrenBelz 155,922 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@jayceeb ,

I need the actual Items property of the Combo box

Was this reply helpful? Yes No
jayceeb 94 on at

Like
a
(0)

Report
Copy link

Link copied!

Oops. I did not use choices code. Is it required?

Was this reply helpful? Yes No