web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Magic Delegation worka...
Power Apps
Unanswered

Magic Delegation workaround: Could this truly work?

(0) ShareShare
ReportReport
Posted on by 71

Hi everyone

I have a canvas app with Sharepoint as datasource which will have a large number of items. I think I might have found a 'magic' workaround to delegation issues for sorting my gallery that also works for looking at text in a multichoice column (ie using 'in'). It seems too good to be true, so I'm reaching out to see if you think it actually works. 

 

This is the solution: in a hidden part of my app I have created a gallery (shadow gallery) with the full datasource in the items. I have added a label in the the gallery for each item with 'concat' and my multichoice field (called 'sectors'). I have done the same for a complex column as well. 

 

I have then set my main gallery's datasource as shadowgallery.allitems. This way I appear to be able to do filter, sort and even use 'in' without delegation problems. For the multichoice, I use 'in' 'sectors.text'.

It really seems to work, which seems too good to be true. 

 

Could this really be a solution? Thoughts? What bad things will happen to me if I go with this solution?

 

Categories:
I have the same question (0)
  • TheRobRush Profile Picture
    11,128 Moderator on at

    not all of the items in a list that exceeds items thresholds will all appear at the same time. So unless your user scrolls through that gallery until every item has loaded, and then runs their filter, no. Items will get left out.

  • Laura3 Profile Picture
    71 on at

    Thanks I knew it couldn't be as simple as that!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard