cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
w1sd0m
Advocate II
Advocate II

Optimization: Filter Third Gallery based on AllItems in Second Gallery

Hello friends,

 

I have 3 galleries on one screen. 

 

Gallery A = Domain (dataverse table) 1-* 

Gallery B = Category (dataverse table) 1-*

Gallery C = Subcategory (dataverse table) *-1

 

If I select an item in Gallery A it filters all items in Gallery B; It also will filter Gallery C based on AllItems in Gallery B with this code:

Filter(
    Ungroup(
        ForAll(
            galCategory.AllItems.Category As P,
            Filter(
                Subcategories,
                ThisRecord.Category.Category = P.Category
            )
        ),
        "Value"
    ),
    !IsBlank(cr50e_Category)
)

 

 

Can this be done without the 5 functions? Is there a more efficient way to accomplish this filtering? It is kind of slow with only two items in there and filtering down to one.

 

w1sd0m_0-1636691418773.png

 


Thanks!

1 REPLY 1
imranfc
Frequent Visitor

Hello sir, 
  how to upload  and import Leaver Request app develop by Reza.
 my issue when i am trying to upload this app zip file the file upload normally but not appear in my app list 
 how to solve this issue kindly help about this topic ?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,694)