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?