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.
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!
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.
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 :-(
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 ?
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.
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 :/
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. czcams.com/video/YYizaX6gXW0/video.html
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 czcams.com/video/iG8SjWtX1yM/video.html 😍
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?
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 ?
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?
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!
@@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.
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)
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") ))
@@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))
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
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))
Absolute perfect timing with this video Shane. You're the only reason my apps work at all. Thank you!
Glad to help. 😀
Hello Shane, I like what you are doing now: outlining the formula/expression !!! superb content!
Awesome, thank you!
You're always putting out quality content, Shane. Mad respect! Have a great Thanksgiving!
Thanks! You too!
Thanks Shane! Delegation was a headache until this video!
Glad it helped. 🐶
One more time , a great thanks to Shane, i was looking for a solution with delegation in my sharepoint list .
Happy to help!
Hi Shane, watched your latest vid on Delegation and going back through all your related - soooooooooooooooooo useful!!!!!!!!! Kudos to Juan!!!
Thanks Kermit 🐸!
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. 🐶
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!
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
Thanks for this Shane. This is what I needed.
You are welcome 👍
You are a lifesaver ❤
Happy to help
Neat fix, thanks Shane and colleague.
Shane thank you, exactly what i was looking for !
Awesome possum!
This is perfect Shane :)
Thanks :)
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 :-(
Everything is delegable for me, I think there have been some updates in Power apps !!
Great video, to bad there isn't a way (least to my knowledge) to search using IN without delegation issues.
Agree. Boo!
Thanks for such a great trick!
You bet!
Hey Shawn, what about shearching for a specific text within a registry?
Power Apps can’t do that.
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.
Grazie.
Thank you! I appreciate the support. 🤩
You're awesome!!!
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.
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 :/
Thanks for the video...
Happy to help. Have a great day. 🐶
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. czcams.com/video/YYizaX6gXW0/video.html
Hi Shane, this doesn't seem to work for any copy/paste values when searching, any thoughts?
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.
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 czcams.com/video/iG8SjWtX1yM/video.html 😍
Great video! Does starts with can also be applied to dropdowns to filter data table?
Yes, I think so.
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.
Hey Shane, How about contains operator ? Is it delegatable? Using the contains, will relevant/global search on all columns of Gaient work?
Not delegable 😑
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 ?
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?
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!
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.
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, 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 czcams.com/video/YYizaX6gXW0/video.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
Perfect 👌
Thanks 🙏
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!
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
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.
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. czcams.com/video/lYi24okXDPs/video.html
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!!!
I thought it will always limited with the 2000 items of the delegation?
No, StartsWith is Delegable against a SharePoint Text Column.
Does anyone know if this works with the "name" column in a document library?
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
Combox Box Delegation resolved😃
It was a fun bonus tip. 🙃
Does it work with Contains?
Contains is not delegable.
It doesnt work anymore, it still gives a delegation warning
it works, but only on text
Merci 😊
First
Congrats 😁