Hello friends, hope you´re doing great.
I made a custom form in SharePoint list with Power Apps.
Context:
Client Contact Person - A SharePoint list with only 54 rows.
Company Name - A Lookup column.
I have a vertical Gallery, and I have this formula on its Items:
Filter('Client Contact Person','Company Name'.Id=ClientCompanyCombo.Selected.Id)
I keep getting this error:
"Delegation warning. The highlighted part of this formula might not work correctly with column "CompanyName.Id" on large data sets. The data source might not be able to process the formula and might return an incomplete data set. Your application might not return correct results or behave correctly if the data set is incomplete.
I clicked "Open monitor" hoping to get more insight as to why, because according to Microsoft, Filter () is a delegable function.
It is a small data set so I couldn't figure out why it won't delegate.
In a last-ditch attempt to understand/debug this, I simplified the formula even further:
Filter('Client Contact Person','Company Name'.Id = 1)
This is a snippet of the monitor:
"data": {
"context": {
"entityName": "MemberTableItems",
"propertyName": "Items",
"id": 13335,
"nodeId": 6,
"diagnosticContext": {
"span": {
"start": 0,
"end": 53
},
"dataOperation": {
"protocol": "local",
"operation": "filter",
"dataSource": "Client Contact Person"
},
"formula": "Filter('Client Contact Person','Company Name'.Id = 1)"
}
},
"info": "Formula not delegated. 54 rows scanned.",
"helpUrl": "https://aka.ms/pamonitordelegation",
"issue": "This function can be delegated but the selection formula used prevented the datasource from processing the query.It might not work correctly on large data sets and an incorrect result might be returned.The data row limit for non-delegable queries defined in the app settings is 500."
}
It still won't delegate.
I really would appreciate any help or suggestion; I'm a newbie and I've been stuck with this problem for several days now.
Thank you in advance! 🫶
