sharepoint Filter StartsWith delagation large list warning

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a searchbox-textbox

I have Radio button with 3 choices

I have a gallery with the items set to below

The sharepoint list contains 4,888 rows

If(rdo_SearchFields.Selected.Value = "Escalation Id", Filter(t_pricing_escalation_master,StartsWith(Text(PRICING_ESCALATION_ID),txt_SearchText.Text)),
rdo_SearchFields.Selected.Value ="Account Name", Filter(t_pricing_escalation_master,StartsWith(ACCOUNT_NAME,txt_SearchText.Text)),
rdo_SearchFields.Selected.Value ="Account Number", Filter(t_pricing_escalation_master,StartsWith(ACCOUNT_NUMBER,txt_SearchText.Text)))

Getting a delagation alert because of the Startswith function ?

Can this be re-written to get around the issue

Dave

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

Actually, STARTSWITH is delegation friendly. The problem is you are using the TEXT function.

Instead of doing this:

StartsWith(Text(PRICING_ESCALATION_ID),txt_SearchText.Text))

Do this:

StartsWith(PRICING_ESCALATION_ID,txt_SearchText.Text))

And SET your variable as Text elsewhere in your app:

Set(PRICING_ESCALATION_ID, Text(your_formula_here)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks I keep copying and pasting old code and forget to delete that part !

Thanks
again

Was this reply helpful? Yes No
rbunge 165 on at

Like (0)

Report
Copy link

Link copied!

Hi Matthew-

Not sure if something's changed, but I was under the impression Filter with StartsWith would be delegable... However, in trying to query a list with 5200 records, and setting the delegation limit in PA to 1, I only get one record.

List column is Single line of text:

This is my Items property for the list box control in the canvas app:

Filter(SupplierLookup,StartsWith('Supplier Name',TextInput1.Text))

I get back only one result, corresponding to the delegation limit I set to 1 (do this when coding apps to be sure I'm not running afoul of it, as MS doesn't always warn properly).

According to the delegation table in the MS docs for SP data source, it should be delegable.

Any ideas?

Was this reply helpful? Yes No
rbunge 165 on at

Like (0)

Report
Copy link

Link copied!

Following up to see if anyone might have any ideas... does it make any difference that it's the internal Title column (renamed to Supplier Name), perhaps?

Was this reply helpful? Yes No