Answered

Having Problems with the Distinct Feature

(0) Share

Report

Posted on by jselman

I created a cascading drop-down from where the division selected determines the choice of branches.

My current formula works well Filter(AdminAndBudgetData, 'Division Abbreviation' = 'Originator Division'.Selected.Result).'Branch Abbreviation'

However, when I try to make the drop-down choice "Distinct" I get the following error message: "Invalid number of arguments: received 1, expected 2."

This is the formula I'm using. Distinct(Filter(AdminAndBudgetData, 'Division Abbreviation' = 'Originator Division'.Selected.Result).'Branch Abbreviation').

Does anyone have any suggestions? Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Joel CustomerEffective 3,224 on at

Like (0)

Report
Copy link

Link copied!
Distinct returns a single column list. the format should be
Distinct(datasource, field to return)
so instead of a period between your filter and field name it should be a comma
Distinct(Filter(AdminAndBudgetData, 'Division Abbreviation' = 'Originator Division'.Selected.Result),'Branch Abbreviation')

Was this reply helpful? Yes No
Verified answer

ganeshsanap 1,555 on at

Like (1)

Report
Copy link

Link copied!
@jselman, Distinct function expects 2 arguments, Table/Collection and Formula. Check below syntax:

Distinct( Table, Formula )

Table - Required. Table to evaluate across.
Formula - Required. Formula to evaluate for each record.
So, for your case you need to use it as:

Distinct(Filter(AdminAndBudgetData, 'Division Abbreviation' = 'Originator Division'.Selected.Result), 'Branch Abbreviation')

Documentation: Distinct function in Power Apps
Please click Accept as solution if my post helped you solve your issue. This will help others find the correct solution easily. 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
jselman 38 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much. This fixed my problem.

Was this reply helpful? Yes No