Power Apps StartsWith Filter to avoid Delegation with SharePoint Galleries and Comboboxes
HTML-код
- Опубликовано: 11 июл 2024
- The Power Apps StartsWith is a fabulous function you can use within your filter formula to provide some search capabilities without having Delegation issues. StartsWith is fully delegable to SharePoint, SQL, and Dataverse data sources. The video shows you how to use it with a gallery and a combobox while also including And and Or operators. Also, cameo appearnces by Trim and EndsWith. A must add to you data filtering and searching tool belt in PowerApps.
Power Apps Consulting and training at www.PowerApps911.com 
Наука
Absolute perfect timing with this video Shane. You're the only reason my apps work at all. Thank you!
Glad to help. 😀
You're always putting out quality content, Shane. Mad respect! Have a great Thanksgiving!
Thanks! You too!
Hello Shane, I like what you are doing now: outlining the formula/expression !!! superb content!
Awesome, thank you!
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!
Glad it helped. 🐶
Hi Shane, watched your latest vid on Delegation and going back through all your related - soooooooooooooooooo useful!!!!!!!!! Kudos to Juan!!!
Thanks Kermit 🐸!
Shane thank you, exactly what i was looking for !
Awesome possum!
Neat fix, thanks Shane and colleague.
Thanks for this Shane. This is what I needed.
You are welcome 👍
One more time , a great thanks to Shane, i was looking for a solution with delegation in my sharepoint list .
Happy to help!
This is perfect Shane :)
Thanks :)
Thanks for such a great trick!
You bet!
You are a lifesaver ❤
Happy to help
You're awesome!!!
Happy to help. Have a great day. 🐶
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 :/
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.
I use both a lot Mark. 😎 Big fan of the emojis. 🐶
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 :-(
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 ?
Thanks for the video...
Happy to help. Have a great day. 🐶
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.
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!
Everything is delegable for me, I think there have been some updates in Power apps !!
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?
Great video. Too bad this doesn’t work with Salesforce. What is the best source for information on what can be delegated to Salesforce?
Hi Shane, this doesn't seem to work for any copy/paste values when searching, any thoughts?
Perfect 👌
Thanks 🙏
Merci 😊
Great video! Does starts with can also be applied to dropdowns to filter data table?
Yes, I think so.
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
Hey Shane, How about contains operator ? Is it delegatable? Using the contains, will relevant/global search on all columns of Gaient work?
Not delegable 😑
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.
Agree but hopefully it is better than nothing. :)
@@ShanesCows absolutely
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"
)
Yes, and the Filter portion will delegate but the search portion will not. Believe it or not I have a video talking about exactly this ruclips.net/video/iG8SjWtX1yM/видео.html 😍
Does anyone know if this works with the "name" column in a document library?
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 ?
Yes, StartsWith is Delegable. 😎 You idea is exactly right.
Hey Shawn, what about shearching for a specific text within a registry?
Power Apps can’t do that.
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?
I don't. :( I don't think it is possible.
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?
CHeck out this video. Not the exact answer BUT it does show you all of the pieces you need to do what you want. ruclips.net/video/YYizaX6gXW0/видео.html
Grazie.
Thank you! I appreciate the support. 🤩
Shane, what if we want to filter a column Contains some value instead of StartsWith. With same delegation in picture
Yeah, contains causes delegation challenges.
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))
Try it flipped around. ilter(Names, StartsWith( txtSearch.Text, ChoiceName.Value)) Though I am not sure if StartsWith works with Choices or not.
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") ))
CountRows is not delegable 😑
@@ShanesCows ah bugger all good i tried without it and still got the same issue on my gallery with the following, i think i am just going to delete items as they are transient. Filter(Approvals, StartsWith(Status.Value, "App") && StartsWith(Approver.Email, User().Email))
@@ShanesCows got it all working used a flow for the counting instead, got rid of all my yellow triangles!
Hey Shane! Will it work with a List having close to 40,000 items?
Yes, my list had 35,000
@@ShanesCows will it also work for Excel online table instead of Sharepoint list? I am getting issues
Hi Shane, Any examples for the Person field with multiple values in each cell by using the data table filter or search?
You will need to use the In operator. I show the concept indirectly in this video ruclips.net/video/YYizaX6gXW0/видео.html
@@ShanesCows Thank you so much. Appreciated. Lots of love.
Tried using the below but none of them worked.
"AssignedTo" in (ComboBox6.Selected.DisplayName) || IsEmpty(ComboBox6.Selected.DisplayName) || IsBlank(ComboBox6.Selected.DisplayName)
"AssignedTo" in (ComboBox6.SelectedItems) || IsEmpty(ComboBox6.SelectedItems) || IsBlank(ComboBox6.SelectedItems)
@@mri3180 "AssignedTo" in ComboBox6.SelectedItems.ColumnName
@@ShanesCows Thank you
Great video, to bad there isn't a way (least to my knowledge) to search using IN without delegation issues.
Agree. Boo!
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.
The Search function does exactly that BUT it is not delegable 😔
@@ShanesCows Yeah. That is the "magic" we are looking for. To avoid the delegation issue. Without that it is not feasible to search only in the begining of the field. Thanks.
How can i use filter with sharepoint lookups with large data set?
I offer some filter/search combos in this video to help with delegation. ruclips.net/video/lYi24okXDPs/видео.html
I thought it will always limited with the 2000 items of the delegation?
No, StartsWith is Delegable against a SharePoint Text Column.
Combox Box Delegation resolved😃
It was a fun bonus tip. 🙃
Does it work with Contains?
Contains is not delegable.
How i can have a Sharepoint List with more of 5000 iTems?
SharePoint doesn't limit the number of items you can have. The more items you have the slower your app will be but there isn't really a limit.
@@ShanesCows Thanks!!!
It doesnt work anymore, it still gives a delegation warning
it works, but only on text
First
Congrats 😁