cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lefty
Impactful Individual
Impactful Individual

Maximum number of items reached

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?

42 REPLIES 42
Lefty
Impactful Individual
Impactful Individual

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

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

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


Lefty
Impactful Individual
Impactful Individual

@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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,354)