Unanswered

Delegation Warning datatable search

(0) Share

Report

Posted on by PowerPete13

Need help solving another delegation issue... I built a powerapp that's connected to a SharePoint list that logs in shipments and notifies the user that they have been received. In the app, I also created Datatable (In Preview) for the user to see and search through all the records with a search box.

I am using the formula below on the Datatable items:

Search('Datasource', SearchInputShipping.Text, "TrackingNumber","Shipper","Carrier","Addressee")

which gives a delegation warning. It works, but I can see the log exceeding the delegation limit quickly and could use some advice on a better way to have a search feature.

Can anyone recommend a better formula for use with a sharepoint list?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
Hi @PowerPete13 ,

Quite simply, the Search function is not Delegable with SharePoint as a data source. The best you will do (in the absence of any other filters that may assist here) would be

Filter( 'Datasource', StartsWith( SearchInputShipping.Text, TrackingNumber ) || StartsWith( SearchInputShipping.Text, Shipper ) || StartsWith( SearchInputShipping.Text, Carrier ) || StartsWith( SearchInputShipping.Text, Addressee ) )

It will of course work if your data source numbers are under your (500 - 2,000) Delegation limit.

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

Was this reply helpful? Yes No
PowerPete13 76 on at

Like (0)

Report

Thanks for your input. Can't get it to work for some reason Warren. But I see the logic in the formula and it looks to be correct... Will keep trouble shooting why.

Was this reply helpful? Yes No