Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Multi-select SP Column Overall Options as Drop-down to Filter Gallery

Posted on 12 Nov 2024 03:30:49 by 39
I have a SP list with a multi-select column. In-app, that allowed me to limit user submission by item. For example:
Item1 categoryA; CategoryC
Item2 CategoryC
Item3 CategoryA; CategoryB
 
So when users are submitting a form for item3, the drop-down is limited to Categories A and C. This works great. 
 
Problem_1: 
 
I now have another form that connects to a different list. (The first is the core database, the second is a transaction log, essentially.)
 
In form 2 (linked to list 2), I'm trying to allow the user to use a single selection drop-down or combo box to filter a gallery. To do that, I need a dropdown that provides a list of all distinct categories for the entire list 1 (Categories A,B, and C), but it seems to only pull options for one item, but I'm not trying to base it on another selection or limit this to one item.  This is utilizing the Choices function. 
 
Problem_2:
 
Dropdown.Selected.Value doesn't yield any value (I was using it to filter a gallery, but also tried a text label and variable value to test). So, even though the drop-down only allows one selection and I turned multi-select on the combo box off, my gallery is empty when trying to use:
 
GalleryItems:tion 
Filter(DatasetA, Dropdown.Selected.Value in c
CategoryColumn). I know this is not delegable.
 
What am I missing?
 
Thank you in advance!
  • ronaldwalcott Profile Picture
    ronaldwalcott 800 on 27 Nov 2024 at 18:20:53
    Multi-select SP Column Overall Options as Drop-down to Filter Gallery
    I maybe misunderstanding your design but do you have a list of categories?
    If you do, why did you use a multi-select column instead of using a lookup column to the categories list?
     
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 984 on 27 Nov 2024 at 17:34:52
    Multi-select SP Column Overall Options as Drop-down to Filter Gallery
    Pls try the following:
     
    Use Concat and Distinct: Distinct(
        Split(
            Concat(List1, CategoryColumn.Value & ";"), 
            ";"
        ), 
        Result
    )
     
    Set the Dropdown’s Items Property:
    Assign the above formula to the Items property of the dropdown.
     
    Update the Filter Formula for the Gallery: Filter(
        DatasetA,
        Dropdown.Selected.Result in CategoryColumn.Value
    )
     
     
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,137

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,813

Leaderboard