You’re offline. This is a read only version of the page.
725
Hi everyone
I have a gallery that has been filtered by a combobox, but I am getting a delegation warning because of the StartsWith. I was wondering how to get around this as I'm confident my Sharepoint database will exceed 2000 records over time.
Combobox (which gets it's data from a collection)
Share
ReportSort(Distinct(Filter(IncompleteOrders,QuantityO<>QuantityRO),OrderNumO &" "& Title),Result,Ascending)
Gallery
SortByColumns(Filter(Sent_Orders,StartsWith(OrderNumO &" "& Title, ComboBox6.Selected.Result)),"Title")
I am not sure how that helps at all as I assumed the actual order number (in full) would be in the Combo Box selection anyway and it also does nothing to address the Delegation issue you are concerned about.
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.
Yes - Delegation is what it is - you may have already read this blog of mine, but you simply set it to 2,000 and manage what you can with Delegable filters. I have also just realised that using your filter <> (does not equal) is not Delegable either, so the With() statement here really does not help.
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.
So my in my Sharepoint list I have exceeded 500 entries and if I leave my delegation limit to 500 then my latest entries don't show in my gallery. If I set the delegation limit to 2000, Will I not have the same problem later when my database exceeds 2000?
Thank you for your time
Why did you lower the Delegation limit?
The With() Statement is still subject to the end result of the filter producing a data set of less than this number, so leave it as high as you need to for everything to work (2,000 will not hurt anything).
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.
Hi @Corissandageri ,
Firstly, Distinct is not Delegable either, so I have a suggestion for the first one
All responses (
Answers (
With(
{
wQty:
Filter(
AddColumns(
IncompleteOrders,
"OrderNo",
OrderNumO & " " & Title
),
QuantityO<>QuantityRO
)
},
Sort(
Distinct(
wQty,
OrderNo
),
Result,
Ascending
)
)For the Gallery, try this
SortByColumns(
Filter(
AddColumns(
Sent_Orders,
"OrderNo",
OrderNumO & " " & Title
),
StartsWith(
OrderNo,
ComboBox6.Selected.Result
)
),
"Title"
)
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.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
