web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Linked Dropdowns and D...

Power Apps

Answered

Linked Dropdowns and Distinct Function

(0) Share

Report

Report

Posted on by SG1990

15

I have 2 dropdowns, namely ddCompany and ddProperty.

ddProperty, shows all properties for the company selected is ddCompany.

However, when I successfully add the distinct function to ddCompany, the formula within ddPropery no longer works.

Formulas before distinct
ddCompany - SortByColumns('Property Information',"ClaimantCompany")

ddProperty - Filter('Property Information',ddCompany.Selected.'Claimant Company'='Claimant Company').'Property Name'

ddCompany formula with Distinct

Distinct(SortByColumns('Property Information',"ClaimantCompany"),'Claimant Company')

Please can someone advise a way to make the ddCompany dropdown only show unique values without affecting the ddProperty dropdown.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 155,675 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @SG1990 ,
See if this approach works - ddCompany
Sort( Distinct( 'Property Information', ClaimantCompany ), Result )
ddProperty
Filter( 'Property Information', ddCompany.Selected.Result = 'Claimant Company' ).'Claimant Company'

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.

Was this reply helpful? Yes No
SG1990 15 on at

Like (0)

Report
Copy link

Link copied!

Thanks Warren, works a charm.

Was this reply helpful? Yes No

Join the conversation