Maximum number of items reached

[Lefty]

I have a lookup column on my canvas app form, trying to pull around 750 items from another SPO list,

At the bottom of dropdown2 I see 'Maximum number of items reached'.
I assumed by changing the settings of 'Data row limit for non-delegable queries' to 2000 would resolve my issue but I still do not see all the items, and they are around 750.

I also get a yellow warning (Delegation warning), which I'd like to avoid if possible, the data is not static and will change, and i'm pulling more than 1 column by using the Dropdown2 and then referencing it to pull other item data into other fields, so not sure if this is what the issue is?

[Lefty]

HI @iAm_ManCat 

You provided me with an excellent solution here, and sorry for reaching out on an already answered question (I can create a new one if required) but thought it was easier to ask here with all the info in this?

Is there anywhere I can search the gallery, via a search box as opposed to users scrolling down to items, which could be around 1000 items?

Thanks

[iAm_ManCat]

Hey @Lefty,

Absolutely!

You can use something like the following if you want it to search within one column, with ColumnName1 being that column:

SortByColumns(
              Filter(
                     'List 2',
                     Len(SearchTextInput.Text)=0
                     ||
                     Startswith( ColumnName1, SearchTextInput.Text)
              ),
              "Title",Ascending
)

Or you can expand it further using more || cases:

SortByColumns(
              Filter(
                     'List 2',
                     Len(SearchTextInput.Text)=0
                     ||
                     Startswith( ColumnName1, SearchTextInput.Text)
                     ||
                     Startswith( 'Column Display Name 2', SearchTextInput.Text)
                     ||
                     Startswith( ColumnName3, SearchTextInput.Text)
                     ||
                     Startswith( ColumnName4, SearchTextInput.Text)
              ),
              "Title",Ascending
)

You'll notice the first condition its checking is if Len (length) of the text is zero, this is so that if there is nothing searched then the gallery is not filtered, otherwise || filter by the following rules.

I've also added an example using the display name of a column into the second example so that you can use that if needed.

Let me know if you run into any issues when doing this, happy to help

Cheers,

ManCat

[Lefty]

@iAm_ManCat 

Amazing, this forum is brilliant, thanks to people like you.

I managed to figure out something that works, and its sort of what you have provided, but yours is by far better, so i'll look to implement yours