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?
Solved! Go to Solution.
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?
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
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!
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
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!