Unanswered

Filter gallery by two SharePoint lists AND multiple choice column - is it even possible without a collection?

(0) Share

Report

Posted on by Community Power Pla...

Alright my dear Power Apps experts, I blame my Friday afternoon brain for this one, but I'm hoping there is a solution to a complex gallery filter problem I'm having. All my data exists as two SharePoint lists, each on a different site.

I have a gallery showing pieces of my master table from the 'Master Trial File Tracking' SP list. Simple one.

Screenshot 2022-08-12 124930-2.png Labels within this gallery contain LookUps for columns in the other SharePoint list ('2022 PDFT Trial Tracking'), which share "TrialNumber" as the join ID.

Screenshot 2022-08-12 131410-2.png

I filter the gallery with dropdowns based on columns in MY master list (Year and Group), but there is a filter I would like to apply with the other list's column called Portfolio (see screenshot 2). Worse yet, this is a multiple choice column!

I made a different gallery to get the filter result I'm looking for, from list 2, but I am obviously missing something when trying to apply this filter with the first gallery.

Screenshot 2022-08-12 131423.png

I'd rather avoid using a joined collection if possible, because I'd be bringing in so much data into a single collection that I'd be afraid performance would take a big hit. I'm not as worried about the row limit, but the sheer number of joined columns. These lists are updated daily at any given time. Is it possible to go about joining the lists and filtering a multiple choice column within a single gallery object? Appreciate the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

The easiest way is to use AddColumns to one list and using a LookUp on TrialNumber. I see you are using the in Filter already, so the additional Delegation issue should not be a problem.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Sometimes I do just need some help reframing the logic! Join TrialNumbers via LookUp, then AddColumns to bring in the other stuff, makes total sense. When I get back to the project this week I will give it a shot and post results. Thanks!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report
After figuring out all the syntax, this would be the solution that would give the correct results:
Filter(AddColumns('Master Trial File Tracking',"Portfolio2",LookUp('2022 PDFT Trial Tracking',TrialNumber='Master Trial File Tracking'[@TrialNumber],Concat(Portfolio.Value,Value,", "))),Year=DropdownYear.Selected.Year)
Using "Portfolio2" as the text vessel for the concatenated Portfolio multiple choice column label...If my SP lists were shorter than I expected, this would work. But, I didn't fully understand the delegation limits of AddColumns until today...and my sources are still too big to make this work.

Collections it is! As much as I don't like them! 🙂

Thanks @WarrenBelz for helping me get the right functions figured out.

Was this reply helpful? Yes No