Hi @Robert_ ,
You have two fundamental non-delegable elements there - Search is simply not Delegable (so any query with it included is not Delegable) and also AddColumns is a Delegation Limitation on the record number output. The best you will do here is if this core query
SortByColumns(
Filter(
Requests,
Email = varUserEmail
),
"ID",
SortOrder.Descending
)
returns records less than your Delegation limit (or more specifically if the newest (limit) records contain the items you need, then this should work
With(
{
wData:
SortByColumns(
Filter(
Requests,
Email = varUserEmail
),
"ID",
SortOrder.Descending
)
},
Search(
AddColumns(
Filter(
wData,
StatusFilter.Selected.Value = "All Requests" ||
ReqStatus = StatusFilter.Selected.Value
),
"ReqID_Text",
ReqID,
"ExpenseType_Text",
ExpenseType.Value,
"Chartfieldl_Text",
Chartfieldl,
"ID2",
Text(ID)
),
SearchUserRequests.Text,
"Merchant",
"ReqID_Text",
"ExpenseType_Text",
"Chartfieldl_Descr",
"Chartfieldl_Text",
"ReqStatus",
"ID2",
"Justification"
)
)
Also please remember to post your code in Text also - this was OCR'd so watch spelling.
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.
MVP (Business Applications) Visit my blog Practical Power Apps
