Hey Shane, you are a saviour. I was in the middle of revamping my entire application. Considered rewriting the application in Django which I am more comfortable writing and then I landed on this video.
16:40 double filter or filter within filter, answered my question as well, thank you! And I also learned I could refresh the data source not by pressing F5 to reload my powerapp, lol, that's what I've been doing. Got so much from this one video
I gave up with all these limits a long time ago and just use flow to query sources and pass data back to powerapps, from my testing there is no limit on rows returned into powerapps collections, once it's in a collection you can do whatever you want with it. A video showing this would be excellent for others. It's a really short flow with 3 steps (or more if you have optional filters) but it does use the premium http response connector.
@@ShanesCows yep, I only use a single 'service' account for SSO access, and use an alternative user authentication method for in-app logins. The SSO account has access to premium and runs the requests in the background for any/all users
Hi Shane, Thank you for your videos. I am about to throw in the towel with using this platform. Isn't this whole thing supposed to be about accessing data? So why hasn't Microsoft been able to incorporate a comprehensive solution to this. You have gone to great lengths to explain delegation, but I haven't seen a solution to being able to display categorized items using distinct which I believe is the ultimate objective for many of us. This limitation renders all the other features in powerapps essentially unusable. Not being able to execute a distinct query beyond 500/2000 max is pretty unimpressive. I have a couple hundred hours sank into this project between dataverse data entries, and building the interface, again as mentioned the delegation limitation and the lack of viable solutions to it makes this platform disappointing to say the least.
I am sorry. I wish I had a magical answer for you. Could you maybe use a flow or other back end automation to do the grouping so you could query smaller data sets with Power Apps?
@@ShanesCows You're awesome man. Please don't let my frustrations with PA reduce my appreciation for all of your hard work. That being said, I am looking to accomplish my desired result with a one to many relationship from an index table down to subchapter tables. A bit of extra grinding but it will probably yield the interface I need. Thanks for replying. That alone keeps us weary hackers going.
As long as your query is delegable. You can show as many as you want. This video talks a bit about it. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UaBmVUQx_Fk.html
thanks! delegation is a big reason, why i'm switching to cds as backend data source instead of sharepoint 😊 .. only bad thing with cds is the security part .. i forget to assign the sec role to new tables all the time 😅 .. still thinking how i can somehow automate or outsource that to the users 🤔😅
Excellent, thanks Shane!!! I guess that just works with a single line of text column, what about in a calculated column which results are in single line of text?
Great video, was wondering about this. I would like to know if its possible to sort records as well before using non-delegable function to get the latest records instead of oldest. I will need to do some testing :)
@@ShanesCows yes, sorting also works :) This has made delegarion much easier for me for some situations where latest 2000 records will do just fine as oppose to first 2000 records.
Great methods for getting around the delegation limit. is the delegation limit in an app available as a variable that can be displayed or used as a check?
Hi Shane, great video! I just have this question based on these examples given... so we now know how to combine formulas to fix the delegation warning but if after nesting all these formulas I exceed the 2k PowerApps limit (or these "red cows" results) will not be able to resolve it; right? The only workaround is to keep adding more formulas to reduce the data received?
Hi Shane, I have excel template file which i need to upload into document library with data. But we have multiple clients they can upload files with latest data. Once the file uploaded I need to show the data on powerapps gallery from uploaded excel. - how can i differentiate the each client files in document library and fetch data into powerapps gallery each time. can anyone suggest me how can I proceed on these scenario. Thanks in advance.
you could use the "created by" column to filter the data for each user. Or if there are several users of the same company, you could create a list that associates the names of each user with their respective company