StartsWith in combination with &&& (and) filter

(0) Share

Report

Posted on by Rfla

252

The problem is SP lists with over 500 elements. And getting a result that show element 501 ->

This works: (without the second value in the filter)

SortByColumns(Filter(Source;StartsWith(Title;TextSearchBox1.Text)||StartsWith(Contact;TextSearchBox1.Text)||StartsWith(Customer;TextSearchBox1.Text)||StartsWith(Text;TextSearchBox1.Text));"Created";If(SortDescending1; Descending; Ascending))

This does not work: the search stops at element 500
SortByColumns(Filter(Source;StartsWith(Title;TextSearchBox1.Text)||StartsWith(Contact;TextSearchBox1.Text)||StartsWith(Customer;TextSearchBox1.Text)||StartsWith(Text;TextSearchBox1.Text);Status<2);"Created";If(SortDescending1; Descending; Ascending))

SortByColumns(Filter(Source;StartsWith(Title;TextSearchBox1.Text)||StartsWith(Contact;TextSearchBox1.Text)||StartsWith(Customer;TextSearchBox1.Text)||StartsWith(Text;TextSearchBox1.Text)&&Status<2);"Created";If(SortDescending1; Descending; Ascending))

SortByColumns(Filter(Source;And(StartsWith(Title;TextSearchBox1.Text)||StartsWith(Contact;TextSearchBox1.Text)||StartsWith(Customer;TextSearchBox1.Text)||StartsWith(Text;TextSearchBox1.Text);Status<2));"Created";If(SortDescending1; Descending; Ascending))

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

SinanE 174 on at

Like
a
(0)

Report
Copy link

Link copied!

I think this is happening because the '>' operator is not delegatable in Sharepoint, which results in running your query locally (in the 500 rows). Please see this post which lists all the supported delegatable predicates and functions for SharePoint.

https://powerapps.microsoft.com/en-us/tutorials/delegation-list/

Was this reply helpful? Yes No
ShantanuP Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Sharepoint doesn't support '<' operator in delegation. But it supports '=' operator in delegation. So if you change the expression to use Status = 2 then it would run on all the items in the list.

Was this reply helpful? Yes No
ShantanuP Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry didn't see that you have && operator as well there. This is also not supported by sharepoint yet in delegation. So using = operator in your case wouldn't help either. What you can do is that filter using only one condition (Using startswith or '=' operator) if that returns results less than 500 and then collect those values and then apply other filters on it.

Was this reply helpful? Yes No
SinanE 174 on at

Like
a
(0)

Report
Copy link

Link copied!

Actually, && is supported in delegation 🙂

Was this reply helpful? Yes No
ShantanuP Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Indeed it is supported. 🙂 Sorry for the confusion.

Was this reply helpful? Yes No
Rfla 252 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @SinanE and @ShantanuP,

Seems that changing the < to = (equal) did the trick.:-)
Next question: is it possible to use the equal in combination with Author.Displayname (lookup) = some text field.

Seems like that last equal is not supported yet? Lookups.

Was this reply helpful? Yes No