Power Apps StartsWith Filter to avoid Delegation with SharePoint Galleries and Comboboxes 

Absolute perfect timing with this video Shane. You're the only reason my apps work at all. Thank you!

You're always putting out quality content, Shane. Mad respect! Have a great Thanksgiving!

Hello Shane, I like what you are doing now: outlining the formula/expression !!! superb content!

Great Video Shane! One short add to at least the text box search input: To avoid multiple search requests (limits etc.) it may make sense to set 'DelayOutput' to 'true'... Just my 2 cents. Thanks to your ongoing good support with your videos!

Thanks Shane! Delegation was a headache until this video!

One more time , a great thanks to Shane, i was looking for a solution with delegation in my sharepoint list .

Neat fix, thanks Shane and colleague.

Hi Shane, watched your latest vid on Delegation and going back through all your related - soooooooooooooooooo useful!!!!!!!!! Kudos to Juan!!!

Shane thank you, exactly what i was looking for !

Thanks for this Shane. This is what I needed.

You are a lifesaver ❤

This is perfect Shane :)

Thanks for such a great trick!

Shane, use [Windows Key] - V. Turn on, then store your clipboard history. You can pin frequently used snips or bring code back that you've cut [Ctrl]-X or copied [Ctrl]-C to your clipboard. [Windows Key] - . (period) is also fun.

You're awesome!!!

Thanks for the video...

Everything is delegable for me, I think there have been some updates in Power apps !!

Thank you! So helpful. I have a very large list of Locations that I put into a ComboBox with selectmlultiple set to false, I was able to fix the Items property to be Filter(Locations, StartsWith(Title, Self.SearchText)). The ComboBox, works and posts back to the SharePoint list, New/View forms work as expected. My issue comes when a user Edits a row, the Location shows the correct city from the data that was added to the list in the New form, BUT the form forces the user to re-add the location. The required setting on the location is called even though it is pulling the data from the list.

Great workaround. The downside I see on this solution is that the Search function looks for the text anywhere in the text field. This one only looks for the beginning of the string.

Thanks a lot for this video. One query but not related to the video. I am using List as backend. There is no transaction (commit/rollback). So what is the option available in Powerapp when we have to update multiple tables ?

Perfect 👌

Merci 😊

Hi Shane! This was so helpful. What would I do if I have multiple observations and I just want the unique observations? I know Distinct isn't delegable :/

Grazie.

Great video. Too bad this doesn’t work with Salesforce. What is the best source for information on what can be delegated to Salesforce?

Hey Shawn, what about shearching for a specific text within a registry?

Hey Shane, How about contains operator ? Is it delegatable? Using the contains, will relevant/global search on all columns of Gaient work?

How to get the top 3 highest values among 10 other columns ?? Which is best way to create it by calculated column or can it be done by power apps ?? Could you please help me on this

Great video! Does starts with can also be applied to dropdowns to filter data table?

Thank's so much ! Just one question. If I do one search in a filter, does it wok ? Search( Filter ( GIANT, StartsWith (Animal, TextInput1.Text ); TextInput2.Text, "Title" )

Shane, what if we want to filter a column Contains some value instead of StartsWith. With same delegation in picture

Does anyone know if this works with the "name" column in a document library?

Hello Shane, great video as always great explained but can it be that it does not work with document libraries. I wanted to use Startswith in a document library (200.000 entries/files) but I always get a delegation warning and not all entries are found ;-( Please keep up the good work with your videos! Thanks from Germany!

Thanks Shane for sharing. I am trying the same trick with a SharePoint calculated column but it stills throws the delegation warning. Any solution for delegation problems with calculated columns?

Hi Shane, this doesn't seem to work for any copy/paste values when searching, any thoughts?

This is awesome. Thanks a lot Shane! I have a sharepoint list 1 with 61K data (id, name, status columns) and I have another sharepoint list 2 which has id and name column that needs to be filtered from Sp list 1. In my PowerApps- I have Sp list 2 connected in the form and the when a user types the id or name on sp list 2, it should filter with the starts with function and auto populate the id and name for them. Instead of using a separate search box to search, I want to utilise the same text boxes in PowerApps with id and name from which a user typed either on ID field it auto fills the name and vice Versa. Can this be achieved?

This is great, thank you. However, how can you now also amend Gallery items so it shows only records that are from Combobox - multi selection? My datasource is well over 2,000 in SQL and filtering from ComboBox of multi selected items doesn't work :-(

Great video, to bad there isn't a way (least to my knowledge) to search using IN without delegation issues.

Hello, I'm from Brazil, if got this. May I use the function Filter ( data base ; Startswith .... ) to filter itens from a data base with more than 2000 itens ? Is that it ? Is it delegable ?

This is was great. Just one small question, might be stupid. Is there a way to filter gallery based on what is selected in combobox, given the combobox is multi-selected?

Combox Box Delegation resolved😃

Hey Shane - this sounds great - but i just tried and its not working i still get delegation warnings is it because i am using a choice column? CountRows(Filter(Approvals, StartsWith(Status.Value,"Pending") ))

Hi Shane, Any examples for the Person field with multiple values in each cell by using the data table filter or search?

Hey Shane! Will it work with a List having close to 40,000 items?

Hi, Shane thanks for your great videos they hepl a lot. I am a getting delegation error with a Choice column = Filter(Names, StartsWith(ChoiceName.Value, txtSearch.Text))

Hi. Any magic trick to search not limited to the begining of field? It would be nice to have a way to search anywhere in the field.

How can i use filter with sharepoint lookups with large data set?

Does it work with Contains?

I thought it will always limited with the 2000 items of the delegation?

How i can have a Sharepoint List with more of 5000 iTems?

It doesnt work anymore, it still gives a delegation warning

First