cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

sharepoint Filter StartsWith delagation large list warning

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

@DAVIDPOWELL

 

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."

 

View solution in original post

2 REPLIES 2
Super User III
Super User III

@DAVIDPOWELL

 

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."

 

View solution in original post

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

 

Thanks

again

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (81,122)