web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Delegation Warning dat...

Power Apps

Unanswered

Delegation Warning datatable search

(0) Share

Report

Report

Posted on by PowerPete13

76

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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
PowerPete13 76 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Join the conversation