PowerApps Delegation and the 500 item limit
Ғылым және технология
In this video, you will learn about PowerApps Delegation. We talk about what is delegation, how it varies based on three different criteria, data source, function, and operator, and some tips to deal with it. Functions covered include Filter, Search, Collect, CountRows, Distinct, and more. Also, we use SharePoint, Azure SQL, and the Common Data Source to drive home the points.
Link to twitter thread / 1213158471140610049
Link to PowerApps documentation docs.microsoft.com/en-us/powe...
Link to Reza's videos • Power Apps Delegation ...
PowerApps Training training.PowerApps911.com
Пікірлер: 293
I hope you realize how many people you help, man. Thanks for the great videos. You carry a lot of businesses on your shoulders with these guides and we really appreciated you.
@ShanesCows
4 жыл бұрын
Thanks for the kind words Shaun. I am glad to do my part. 😀
@jlzpacheco
2 жыл бұрын
Exactly, and still make it fun! Feels like i´m talking to a funny expressive friend.
Again you made the things clear than some other youtube video over delegation... I think you're the only one that actually explained the meaning of delegate.. "to delegate to the datasource querying the data" with this simple sentence I understood everything. Many thanx
@ShanesCows
2 жыл бұрын
Glad to help Roberto.
Shane is awesome. His style of teaching is just superb. The facial expressions that he makes, keeps the audience glued to the video. Thanks a lot for helping me and the entire community.
@ShanesCows
2 жыл бұрын
Wow, thanks!
Good grief! The light bulb has been switched on. Every time I watch one of your videos, I lean something important. I had been ignoring that triangle because I couldn't quite get my head around what was going on. Now I have no excuses. Thank you as always, Shane.
@ShanesCows
3 жыл бұрын
🥰 Awesome. You got this.
😂I loved this video, I laughed so much. In a way Delegation is like the 5000 document limit in a SharePoint library, you can load 40,000 files into a library but you can't see them until you Index, which no one wants to do. People actually migrated 40,000 files into a library on an assignment I was on. I tried to tell them! Your videos are really helping me to get comfortable with PowerApps. Thank you!
@ShanesCows
Жыл бұрын
Thanks for sharing. 😀 so many silly things have been done with SharePoint 🤩
Woop Woop! Thanks Shane! We can always count on you.
@ShanesCows
Жыл бұрын
Happy to help!
"SharePoint's like "Nah baby, nah - I don't do that!"" Ha -- I love it! Thanks for another very informative (and entertaining) video!
@ShanesCows
3 жыл бұрын
Glad you enjoyed it! 😂
This is crazy helpful man!!!! Your content, your voice, your expression, that's super awesome. I watched entire a video without skipping!
@ShanesCows
2 жыл бұрын
Awesome, thank you!
I have really appreciated your videos, I have spent dozens of hours on this issue and have yet to find a solution for my particular use case. I don't feel like what I am trying to pull off isn't particularly complicated but for whatever reason there isn't a way to distinct my data without having delegation issues. This is a huge limitation of this platform, it seems like the entire point of powerapps is to be able to retrieve data with a user interface. I don't understand why this aspect of powerapps is so complicated.
@ShanesCows
10 ай бұрын
YEah, distinct just is not delegable. SOrry
This was so helpful. I never knew the consequences of letting that little yellow triangle hang out in my Power App. Now it all makes sense. Thanks!
@ShanesCows
3 жыл бұрын
Awesome 🤩 😎☺️
Wow.... Now we have so much work to do ! We have many collections working with delagation filters! 😭 Thanks alot Shane!! You’re the best!
@ShanesCows
4 жыл бұрын
You are welcome 🙏
Thx Shane... Just used your tips to remove "'stupid yellow triangles" from my prototype!
@ShanesCows
2 жыл бұрын
Awesome!
Another hit video!... Thank you!!!... Still breathless by keeping up the pace 🤠👍
@ShanesCows
4 жыл бұрын
More to come!
This is so good to know and your methodology of trying it in different scenarios helps a lot!! Thank you 😊
@ShanesCows
3 жыл бұрын
You're so welcome!
Still helpful after 3 years!
@ShanesCows
11 ай бұрын
This should be on my list to do again. 😎
this video is extremely helpful, I have been fighting the default license limitations and delegation issues. Thank you sir!
@ShanesCows
4 жыл бұрын
Happy to help Joe
Fantastic video. Your style is engaging, informative & entertaining. Thank you!
Again amazing Work. I'm losing a lot of my fear of PowerApps because of these great videos.
@ShanesCows
4 жыл бұрын
That is awesome 😎
Hi Shane. Just wanted to let you know that I found this video SUPER useful! Thank you so much
@ShanesCows
2 жыл бұрын
Awesome. Glad to help. 😀
You are such a great teacher Shane, thank for all your videos.
@ShanesCows
2 жыл бұрын
My pleasure!
Great content to get a hold on the delegation concept. Keep doing this great work.
@ShanesCows
3 жыл бұрын
Glad to help
Good video, very clear! Just started with PowerApps and I am amazed what you can do with it.
@ShanesCows
4 жыл бұрын
Thanks 😊
This video is extremely helpful and Shane you did an excellent job in explaining....
@ShanesCows
3 жыл бұрын
Thanks 😊
Thanks for sharing more insight on delegation around multiple data sources
Shane, Thanks this was really helpful, I had a dropdown box linked to another list, which as I now know only allows the first 500 items in a list (I currently have 999 and its growing. So I added a gallery for this list and added a text input box, for the main list identifier value to be typed in. This then allowed me to pull into my app five other referenced field values from my list, which weren't there originally. I also used the filter function elsewhere to show a specific image from a library in a form, which is used by people to verify a task (of which the picture of part of). really neat techniques.
@ShanesCows
3 жыл бұрын
Awesome Robert.
Genuinely one of my favourite ever videos from you, didn't want it to end! I'm glad it was a flex day here as I laughed out loud on a number of occasions! Also great shoutout to Reza, top man. Any thoughts on the 5k 'List View Threshold' in SharePoint and Indexing columns (from a PowerApps perspective) ?
@ShanesCows
4 жыл бұрын
Glad you enjoyed. Typically the SharePoint limits don’t hurt our apps but large lists do get slow. You can add an index up to 25k items I think that may help.
Thanks for this video, Shane. Really really helped!!!
@ShanesCows
4 жыл бұрын
Awesome. Glad to help.
excellent video... great job! i've learned ALOT by watching your videos.
@ShanesCows
3 жыл бұрын
Awesome 😎
Thanks so much! You just helped me remove two very annoying delegation warnings on my app!
@ShanesCows
4 жыл бұрын
Awesome!
Nice one .. Especially how you explained delegates. Was pretty easy
@ShanesCows
4 жыл бұрын
Thanks 😊
Awesome explanation on yellow triangle, Shane
@ShanesCows
3 жыл бұрын
Thanks 😎
Bro you are awesome. Literally my hero
@ShanesCows
Жыл бұрын
Thanks 😎🐶
Another AWESOME! Video Keep it up man.
@ShanesCows
3 жыл бұрын
Thanks! Will do!
Thank you Shane! I realize what I was doing wrong because of your explanation. I was using Distinct function for my dropdown with a sharepoint list of 23k. Thanks a lot Shane!!
@ShanesCows
3 жыл бұрын
Fantastic!
@Noah_Oye
10 ай бұрын
Hello. I think I’m facing the same problem at the moment and I can’t seem to figure it out
@mlm918
9 ай бұрын
@@Noah_Oye Hey Noah just saw your comment. If I remembered it correctly distinct function has to go thru the list up until the one your app is able to display, hence for a more specific dropdown try to help the drop down have all the list. In my case I made a unique new list and put it in my dropdown. I hope my explanation is clear ✌️
@Noah_Oye
9 ай бұрын
@@mlm918 yes it is Thank you👏🏾
Gracias por esta ayuda...!!! Greatings from Chile
@ShanesCows
3 жыл бұрын
Thanks Marco! 🐶
Great explanation, thanks.
@ShanesCows
Жыл бұрын
You're welcome!
Great video, thanks Shane!
@ShanesCows
3 жыл бұрын
Happy to help 😎
Fantastic video, thanks Shane.
@ShanesCows
3 жыл бұрын
Glad you enjoyed it
Great video! Thank you for this!
@ShanesCows
3 жыл бұрын
My pleasure!
Muchas gracias, por compartir tu experiencia y conocimiento!, me ha sido de gran utilidad
@ShanesCows
3 жыл бұрын
😊
Thank you very much for this, I've been deleting my sharepoint data everytime after reaching 2000 record. This saves me
@ShanesCows
3 жыл бұрын
Glad it helped!
this is really helpful. Thanks.
@ShanesCows
3 жыл бұрын
Glad to help. 😀
Wonderful demo !
@ShanesCows
4 жыл бұрын
Thanks George
Very helpful, thanks!
@ShanesCows
4 жыл бұрын
You are welcome 🙏
You're my powerapps hero :D
Your videos are very informative and you reply every single comment on your video I really appreciate it. Thank you so much for creating such a beautiful playlist. I have one doubt, As a developer while programming we use git for integration and branch creation so can we create separate branch for each developer in power apps so that developer can collaborate while developing?
You rock Shane!
@ShanesCows
4 жыл бұрын
Thanks Wendy 😻
Hi Shane, thanks for another great video. You show the text box with the countrows function to illustrate your point. My problem/question is trying to get that number to accurately represent the number of rows. I am trying to pull in an activity view from CDS/Dynamics to put into a graph. I did just what you did and used that text box in my graph formula. However, since that number isn't accurate... that method doesn't work. Any thoughts on achieving this. Literally just trying to pull in one number from dynamics and it's giving me a world of trouble. Thanks so much!!
Great Videos!!
@ShanesCows
2 жыл бұрын
Thanks 😊
You are awesome Man!
@ShanesCows
3 жыл бұрын
You rock!
Yes the Delegation maze! - Need to have a page with all the delegable stuff - yes the matrix
@ShanesCows
4 жыл бұрын
It is a pain for sure
Great video Shane. Any tips to get around the item limit on a dropdown or combo box?
@ShanesCows
3 жыл бұрын
No, I haven't really had requirements where they were an issue :(
Super helpful! Thx! How about when it comes to filtering users? We have over 1,000 and trying to filter by department isn't showing all results.
Thank you !
@ShanesCows
Жыл бұрын
You're welcome!
Love your videos and how on point they are with my problems. One thing I would like to ask. I have a sharepoint list with 10,000 items and a table with a filter that returns one day worth of data or about 20 items. I have a yellow exclamation symbol because there is a sort (of the 20 items filtered) by a field that's an option set which is not delegable (a drop down). Is that ok because the filter is delegable and returns 20 items which then are sorted by a non-delegable field? Again, thank you for your videos! SortByColumns(Filter('Daily Activity', EventDate = DatePicker2.SelectedDate), "Priorities")
@ShanesCows
3 жыл бұрын
Double check it, but yes, in my head you should be good.
Hi Shane, I'm a novice with making apps or with IT in general. You're video's are very useful and with them I can manage my way arround the easy parts of power apps. I want to know about what happens in the function bar. What does al the code mean? What are the commands that are available? When do i use what? Is there some kind of beginners guide to those codes? Thanks a lot!
Thanks for the wonderful video, the PowerApps tell SharePoint to get something example helped me to understand. Looking at the twitter thread and found more videos to watch. Why delegation has to be such rabbit hole! I simply want to countrows/countif to show how many records are in certain database. Is there an easy way to do that?
@ShanesCows
4 жыл бұрын
Nope. Sorry 😐
Thanks for this video, Shane... Question, when you need to filter any folder by path from a Sharepoint Document, how can i delegate on Sharepoint to request only records I need?
@ShanesCows
3 жыл бұрын
I don't know. I played with that one day for 10 minutes and I also go delegation warnings with all of my ideas :( and then I gave up. If you figure it out you would be a hero!
Wonderful video ! One question about the 500 item limit. I use an Excel file as the data source of PowerApps and there are 3 tables in this excel file. Does the 500 item limit refer to the number of items in each table or the the total? thanks
@ShanesCows
4 жыл бұрын
Each table
HI, great video once again, a question though, when you hit the delegation limit which 500 rows are returned? the last 500 created, the first 500 or just a random 500? if it's the last 500 created I can live with it, if not I've got to fight on!
@nicoletimmons2344
3 жыл бұрын
Go to the 7:30 mark where he answers this: it's the first 500 results.
@ShanesCows
3 жыл бұрын
Thanks Nicole. She is correct. It is the first 500
looking at this video now . Using sharepoint as a datasource is the wrost for big datasources/lists. You have to user Filter and starswith. The best for large data is Azure and maybe CDS
@ShanesCows
3 жыл бұрын
Agree. CDS is best but not everyone has the license for that.
Thanks for the explanation. So far, not an issue with my smaller SP Lists - but it will be with my next project. If I need to request our company allows either CDS, SQL, Azure, etc.. what would you recommend I ask for that will present the least amount of issues.
@ShanesCows
3 жыл бұрын
CDS is the best datasource 😀
Thank you for Shane your great video as usual, when ever I ran into a difficulty in powernaps your videos are the first thing which I look for the help and I get my answers in every situation , Here I have one question in continuation to this video, May i know if there is any best way to handle data source with about 10K items without having to use the premium connector. appreciate your response to my query
@ShanesCows
2 жыл бұрын
SharePoint is okay with 10,000 items you just need to be smart about how you present and filter the data. :)
Hi Shane, thanks for your great video's. I don't have delegation issues if I use SQL as a data source but I was wondering if I might run into delegation issues if I change my Power App Connectors to a Data Lake instead of querying SQL tables directly. I was hoping you would have had some experience in using Data Lakes as a data source with Power Apps. Any information you can share would be greatly appreciated. Thanks!
@ShanesCows
8 ай бұрын
You are going to just have to try it. Every data source is different when it comes to what is and is not delegable. Sorry, no quick answer here.
I worked out a way to use the 'in' operator to search for specific text in Gallery items from Sharepoint List, while avoiding delegation. First, set up a series of delegable filters that can narrow your list results directly from Sharepoint. While it's not absolutely essential, it's best if you can use a combination of delegable filters to narrow your Sharepoint List Gallery down to 100 items or less. Next, create a collection wherein the ClearCollect command is Gallery1.AllItems. Third, create a 2nd Gallery that has the Collection you just set up as the Data Source. It's then up to you to work out how you want this to function, but I have a search field that sits beneath my set of filters, and above my 1st Gallery. Upon selecting the search field, the OnSelect property of the search field has my ClearCollect('SearchResults', Gallery1.AllItems), and it turns the visibility of Gallery1 'off', and turns the visibility of Gallery2 'on' using a variable. The 2nd gallery sits on top of the first gallery, so as far as the user is concerned, they are searching the same gallery, unaware of my magical swapper-roo. The limitation I currently have is that Collect will only grab the first 100 items from the 1st Gallery, unless a user scrolls down the list as far as they can go prior to searching. But you are free to use the 'in' operation on a collection, as the data is stored within the app itself. The only thing to be careful about is to avoid making the collection too large. I get around this by disabling the search field until at least a couple of filters have been selected. EDIT: Thanks to Shane and this video for providing the inspiration to accomplish this! This was the last must have feature of my app, and we're rolling it out in my company this month! Hoorah!
@ShanesCows
4 жыл бұрын
Congratulations and thanks for sharing
Ok thanks, i do now understand why, and i know either i've got more work to do ;) but i've got a question about the forms, does it mean it is preferable to use patch function on a sharepoint list wich contains more than 500 or 2000 lines? Because you charge the list on the phone to complain it.
@ShanesCows
4 жыл бұрын
Delegation doesn’t affect writing data. Mostly just filtering data
Hi Shane, Thanks for all of your help. Is it possible to first filter and then search?
@ShanesCows
9 ай бұрын
Yes Power Apps Search and Filter Function with SharePoint + Workarounds kzread.info/dash/bejne/no2dlJaom7uqgNY.html
@khrystinameier2981
9 ай бұрын
Thank you so much!!@@ShanesCows
I'm trying to display employee names from a combobox in Dataverse table that has more than 2000 names. Any tips to retrieve this data?
Hi thanks for nice information about delegations. I have one question if we user excel spreadsheet as data source can we filter more than 2000 records in this situation without any loading everything in memory?
@ShanesCows
4 жыл бұрын
Filter doesn’t have issues with delegation usually so should be okay
Hi Shane, What's the best data source to use with power apps, SharePoint lists or SQL database. Best in the sense performance, efficiency.
@ShanesCows
2 жыл бұрын
Sql works better but requires a premium license. If you don’t have a premium license then SharePoint is the best.
Can you create a search where you might enter into the search something like State, County, zip code (so it would look like this TX, Travis, 78748) and then have the search bring up all companies that are in Texas in Travis County in the 78748 zip code? Does that make sense? By the way your videos are amazing thank you for doing them they have helped me so much, this is my first time using Power Apps and definitely my first time creating an app.
@ShanesCows
2 жыл бұрын
Hi Amy - Give this video a look for some ideas. kzread.info/dash/bejne/no2dlJaom7uqgNY.html I don't think you are going to do exactly what you want but maybe you can get some ideas of ways to do better. :)
Hi Shane, I'm getting close to the 2000 limit and my users are used to having a search box. I'm using a Search as one of two Filter terms, currently have the warning triangle. Filter(Search(AAAAA,TextSearchBox1.Text,"BBBB"),CCCCC=Dropdown1_1.SelectedText.Value) Is there a correct way of organizing this so that the search function only operates on the filtered results?
@ShanesCows
3 жыл бұрын
Search(Filter(AAAAA,CCCCC=Dropdown1_1.SelectedText.Value) ,TextSearchBox1.Text,"BBBB") 😀
Thanks for great way you communicate everything in your videos. I am trying to increase the delegation limit from 500 to 2000. All references to do this point to File -> Advanced Settings etc. What is the mechanism when using Power Apps in a browser? I must be missing something big time because I can't even find the means to use a desktop version which would have the File option. Any pointers gratefully received.
@richardhubbarduk
3 жыл бұрын
Ignore me - I have found what I was looking for - couldn't see what was right in front of me.
@ShanesCows
3 жыл бұрын
Glad you got it figured out Richard.
Hi Shane. I watched the whole video, thank you very much for the explanation. I wanted help. I need to use the sum function, but it is not delegable, the dreaded triangle appears :( I found several places talking to use the Filter inside the sum, but I didn't understand how. Currently my formula looks like this: Sum (Powerapps_relat_mov_ibc; DT_Etapa.Value = "Decontamination" And Status_temp = "PauseDescont"). How do I use the filter? Thanks
@ShanesCows
3 жыл бұрын
Sum(filter(datasource, chewy=“dog”), age)
@Straiderox
3 жыл бұрын
@@ShanesCows Thank you Shane. Just one more doubt. The age part, is where will you save? a label for example? I've seen similar formulas, but I couldn't understand what comes after the filter, what do I put there?
Excelent video! thanks. I am very newbie and just follow your tips in many situations. I have done tests with First(Filter(SharepoinList, ID = MyVariable))... I always get the nasty triangle, but all my tests have work fine on larger datasets... should I worry for a future colapse?
@ShanesCows
3 жыл бұрын
Replace First(Filter with LookUp( instead. 😀
@alwayswalter
3 жыл бұрын
@@ShanesCows I am going to check that... thanks a lot!
@alwayswalter
3 жыл бұрын
@@ShanesCows Oh my... now I got confused, as my scenario relies on multiple Patch(SharepointList, First(Filter(SharepointList, ID = Variable)), {somefield: something})... but as I can read LookUp may return a value, not a record as patch will expect... please feel free to hammer me if I am getting this wrong... :S
@alwayswalter
3 жыл бұрын
I wont bother you anymore I promess (for a while at least). Just let me know if is it fair to replace my First(Filter(SharepointList, ID = Variable)) with {ID: Value(SomeGallery.Selected.ID)} for example. I mean is it ok to "construct" the base record this way or will I get delegation problems? Again my test worked fine in a 2800 items list...
Loved the analogy of power apps being lazy and only able to compute 2000 non delegable records
@ShanesCows
3 жыл бұрын
Thank Kyle. Me too. Just makes it resonate so much better.
Hi Shane. Is there a limit in the drop-down lists? I don't have all my recordings in my drop-down list while there is everything in my gallery ? Thank you !
@ShanesCows
3 жыл бұрын
I haven't ran into it before but I think i heard 500 items? Not sure though. Sorry
I need to filter out empty dates in SharePoint list so i need a substitute for IsBlank() and Not() functions, Filter( [List Name], Not(IsBlank(Column Name)) )
@ShanesCows
4 жыл бұрын
ColumName = Blank() is delegable. 😀
Hi Shane Young, I am from Guatemala and I started watching your videos, they are very interesting. I would like to know if you can help me... I am creating a data post form in Power Apps for a Sharepoint database. I have used a combo box where I make the data call in a sharepoint list, in this list I have more than 500 rows and when I show it in the combo box it does not show me everything. It only shows me 500 records. How can I fix that? I would like to see in my combo box more than 700 records. Thank you.
Great video. Have a question, filters child drop-down based on parent drop-down values. Data source is dynamics 365 and function is filter and operator is '='. I got error message like object reference not set to an instance of object. Can you help me on this
@ShanesCows
4 жыл бұрын
You probably aren’t doing Dropdown.selected.columnname
I have a NewForm for a sharepoint list item (not a gallery) where I am getting the yellow triangle. There is only one record in the list for testing. The warning directs me to Item: If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@TechnicalReviewRequests]),SharePointIntegration.Selected). Is this a potential problem that will bite me in production? Thanks for all your hard work on these videos.
@ShanesCows
3 жыл бұрын
Nope. That is just some code they did to make the form show data in studio. You can ignore.
Great content Shane! I saw another video for a workaround delegates, wanted to know your thoughts about it. Using With: With( {wFilter: Filter( 'Data Base', Month=varSelected.Month ) }, CountRows(wFilter) ) What do you think about this solution?
@ShanesCows
11 ай бұрын
With is not delegable. It doesn't give you the warning but if you test it you will see it is not delegable. Sorry. This video does have some things to help work within the rules of delegation more creatively. kzread.info/dash/bejne/no2dlJaom7uqgNY.html
@reinacp140
11 ай бұрын
oh my! here I was so happy that I didn't have the triangle anymore! but you're right, I set my maximum delegation limit to a lower value than my data rows and did not work... I have watched that video and many more, but im basicacly stuck trying to countrows and sum multiple columns. What do you sugest? building a powerautomate flow that does for me?
Love double blue underline on the video image 😭
@ShanesCows
4 жыл бұрын
Thanks 😊
Thanks for the video. Considering And is not delegable, Is there any way to combine two conditions while filtering and still keep it delegable?
@ShanesCows
4 жыл бұрын
And is delegable
@parulgarg90
4 жыл бұрын
@@ShanesCows Even for sharepoint list? Cause powerapps keeps giving me error that it is not
Hey Shane, do you know a way to better handle negative queries? and Not arent delegable to Sharepoint. But when one wants to exclude all records with a specific choice field for example, you have to filter positively by each and every other choice available, just to exclude the one. Any ideas ?
@ShanesCows
2 жыл бұрын
Vincent sadly I don't have a better, delegable idea :(
Is there a way to get the count for the entire dataset without a gallery? So if we wanted to see that there are 8000 red records out of the 25K - is there way to do this?
@ShanesCows
3 жыл бұрын
Not that I can think of. 😐
Hi Shane. Does this error: "Server Response: An error has occurred. Object reference not set to an instance of an object." have anything to do with the amount of data in data source.=? I can't seem to get around it.
@ShanesCows
4 жыл бұрын
It shouldn’t. I don’t see that error often. Maybe start a new app, add a galley, then add that data source. Start simple and see if you can figure out where it breaka
Thanks for the very informative video. In my case, I am trying to filter out a gallery items on the basis of the label (True/False) associated with it. I want to created another filtered gallery where I can have all the contents of Gallery A having Label “True”. I am able to write formula for this but the issue is my filtered gallery is only showing the items when my original gallery is scrolled down till bottom manually. Can you please help me out?
@ShanesCows
3 жыл бұрын
You can’t use AllItems this way without that exact issue. Maybe replace it with your filter formula.
Hello Shane, what if I want to filter by column which is not blank/empty? Is there a way to workaround !isBlank or !isEmpty ?
@ShanesCows
Ай бұрын
Not that is delegable that I can think of.
When you say "Azure SQL", are you talking about SQL Managed Instances?
@ShanesCows
4 жыл бұрын
SQL database as a service. But all sql is the same.
Hello Mr.Young. Not getting into delegation problem. I am looking for a gallery to display more than 100 records without scrolling to the bottom every time. Is there a way to do that ? Because I got a little less than 200 records :) Thank you !
@ShanesCows
2 жыл бұрын
Only idea I have is you could collect the 200 items and then show the collection in the gallery. I don't know how to change the 100 item limit directly though.
thanks nice one...can I create a function to filter by ID Greater than and that should be Delegate one ?Filter(MoreThank5KRecords, ID > Value(txtId.Text)) this is not returning item more than 500 limit.
@ShanesCows
4 жыл бұрын
Hmmm I would of that would work but if you are seeing it doesn’t then boo. Check putting a number in place of the value function just to see if that matters
Thank you so much Shane. The Company where I'm working on , asked me to develop a full free app therefore I'm using excel as Datasource (it is my Database :-( ) . If I have understand corretly, the Collect sentence, is able to go over 2000 rows. In my app I'm filtering the Database by week to give the user to modify the data in that specific week, in case the filtered week is situated in a row that is more than 2000, can the user modify it?
@ShanesCows
3 жыл бұрын
Collect will not get more than 2000 rows back without some craziness I don't recommend. You can modify items in a collection but that just modifies them in the collection, not the data source. If you want to change the datasource you will need to modify it using a form or Patch for example.
@robertomancino1975
3 жыл бұрын
Thank you so much Shane. In reality I saw the possibility to add row over 2000 and because I’m filtering by week it seems that all is working properly. Let me cross my fingers an thank you again 👍🏼👍🏼
Great vid!! I seen that 'in' cant be used when the data source is SharePoint (delegation waning will appear). Is there any alternatives to this? My function is trying to check if the logged in user email is within a muti-person column in Sharepoint.. LookUp(Staff_List,userEmail in Manager.Email)
@ShanesCows
4 жыл бұрын
I don’t think that is ever going to be delegable 😑 Need to think about a different approach. Maybe store usernames also in a text field?
@marcmontgomery5374
4 жыл бұрын
That's what I ended up doing in the end. For future projects I will make sure to use databases over SharePoint haha. Thanks for the help :)
How for datasource SQLServer filter works : collectionValues IN MyKeyField >> Eg Filter ([dob].[Giant], ("01","04","07" in MyKeyField) Please help
@ShanesCows
3 жыл бұрын
Not sure
hi, how do you collect a filtered sharepoint library into powerapps? I want to only collect recently created files by creating a calculated duration column and using Collect(Collection, filter(Library, Duration < 14). I still get a delegation warning, any advise? thanks.
@dbschenkersingapore5542
3 жыл бұрын
I only want the recent items as the library has more than 2000 items
@ShanesCows
3 жыл бұрын
Interesting. I don't have a quick answer here. What if instead of using hte calculated column you wrote your filter to figure out the items itself? Or maybe a flow that calculate and write the duration to a number column when the item in SharePoint is edited?
Maybe you have a good suggestion for this. I need to exclude some items from my SharePoint data source so they don't show up in the gallery. The option I am using is giving me the ugly delegation warnings. I am using value of a SharePoint lookup column: Status.Value "Discarded". From what you have said and Reza said AND the documentation, this shouldn't be giving me the delegation warning.
@ShanesCows
4 жыл бұрын
What if you do !(Status.Value = "Discarded")
@julireid9574
4 жыл бұрын
Shane Young same thing except the blue lines are now under the !. I even tried using the .id = 4 and got the same thing.
Hi Shane Thanks for the video. I am getting a delegation error on the Item formula created by PowerApps, that selects the first item in the list - for the SharePoint form. It does not like First as it can't be delegated. I have tried even creating a blank OOTB list and it still does it. Have you seen this and logically does it matter? If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@'LitstName']),SharePointIntegration.Selected). I don't intend to use PowerApps for searching as I am using SP library views to access the Edit form as I am using a filtered SP view. Do you mind commenting?
@ShanesCows
4 жыл бұрын
I don’t think it will matter. 😀
Does ForAll(Filter()) work in the similar way to Collect(Filter())? i.e., Filter() will find ALL the qualifying items and return the first 500 to ForAll()? so as long as we are sure the Qualifying items are less than 500 we can just ignore the delegation warning?
@ShanesCows
3 жыл бұрын
ForAll( Filter doesn’t cause delegation by itself. Maybe your filter has a delegation challenge? But yes, should work the same as Collect
@pggg5001
3 жыл бұрын
@@ShanesCows I trying to patch a collection to a SP list all in one click, where I'm doing Filter(SPlist.id=collection.id)
Hi Shane, I am using SQL server as a data source, the table contains around 4000 records so I created View & restricted the data by adding filter condition inside View. So, If the user added comments in comments box in Power Apps, Can we store the comments data in View based on Click on Save button in Power Apps?
@ShanesCows
2 жыл бұрын
No, you have to write to a SQL table with a primary key, then you could have that table feed the view, but you can't write directly to a view.