Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filter and distinct data from collection in dropdown

(0) ShareShare
ReportReport
Posted on by 102

Hi, 

 

I have dataset with 10K+ rows, so I am pulling them to collection.

Dataset has Class, Code, Description and other fields.

 

Dropdown1 is distinct value of Class - I have done this.

Dropdown2 is distinct values of Code within Class chosen by Dropdown1. - I am struggling with this, I want to reduce items shown here by first filtering by Class, but my codes give nothing.

 

I am going to filter gallery based on combination of two outputs from Dropdowns - I have done this as well.

 

Can someone help me with Dropdown2 code?

Thanks!

Categories:
  • Verified answer
    Dulat Profile Picture
    Dulat 102 on at
    Re: Filter and distinct data from collection in dropdown

    Distinct(
    Filter(
    col_main_table,
    field_1 = Filter_Line_class_1.Selected.Value), field_5
    )

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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard