PowerApps Nested Data Functions and Delegation

[@chrisyleenz]

8:35 where the magic begins, this is the answer I've been looking for around 2 weeks, no one explained like you did, thank you

[@chrisyleenz]

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

[@ShanesCows]

Glad the videos are helping Chrisy. 🐶

[@francismacho9028]

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.

[@ShanesCows]

Awesome 🤩

[@MrUggeh]

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]

Nice idea. 😎 Bummer it is premium though 😂

[@MrUggeh]

@@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

[@chrisyleenz]

Thanks

[@ShanesCows]

A second one. You are too kind Chrisy.

[@jr713121]

Another great video. Thanks Shane.

[@ShanesCows]

My pleasure!!

[@cvkealey]

Thanks for demystifying this! I kind of knew a lot of this and have tried to explain it to my colleagues, but you do a MUCH better job of that!

[@ShanesCows]

Glad it was helpful!

[@srby.k]

That was really informative! Thank you so much for sharing your knowledge Shane!

[@ShanesCows]

Happy to help 🐶

[@aaronmartin9424]

This is very clarifying. Thanks!

[@ShanesCows]

Awesome 🤩

[@rayromych5534]

Thanks for another great video! But how did you manage to get more then 2000 records from SharePoint list into the gallery?

[@ShanesCows]

As long as your query is delegable. You can show as many as you want. This video talks a bit about it. kzbin.info/www/bejne/i5KlnomLht2SfM0

[@Alan-wt1vo]

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?

[@ShanesCows]

Nope. 😑

[@3kubo3]

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]

I think yes but please test.

[@3kubo3]

@@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.

[@jaimesca81]

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?

[@ShanesCows]

Those columns aren’t supported for delegation I believe

[@oluwatobiyusuf]

Thanks for this great video on delegation

[@robinerlacher679]

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 🤔😅

[@ShanesCows]

Making the user do it is always better. 😎

[@facun_OK]

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?

[@fadiahdab6995]

Hi Shane till now I can't get more than 2000 records even I change the datasource to SQL, I am right in this ?

[@ShanesCows]

Depends of the function is delegable or not. Did you watch the delegation video? kzbin.info/www/bejne/i5KlnomLht2SfM0

[@kirankumar3536]

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.

[@christianeyzaguirre6157]

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

[@vigneshravi6025]

Please do the video for delegation issue for DROPDOWN I used distinct function for filter my data actually I have 6000 more records

[@prismaerospace139]

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.

[@ShanesCows]

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?

[@prismaerospace139]

@@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.

[@marcelschliebitz4021]

😀How can a man be so good.

[@ShanesCows]

Thanks Marcel. 😁