Unanswered

Filtering Dropdown options based on used values

(0) Share

Report

Posted on by James_Anderson

Hi Team, I have a small power app that displays a gallery based off a dropdown selection of the primary category it is in.

Not all categories are in use and I am wanting to hide the ones that aren't against an item in the list.

The Dropdown uses this FX and works but I need to add a filter to it. There is for example 50 categories but only 30 are currently assigned to items in the sharepoint list.

With({lclChoices: Choices('Core Tool Matrix'.'Primary Category')}, ForAll(Sequence(CountRows(lclChoices)+1), {Value: If(Value=1, "All", Last(FirstN(lclChoices,Value-1)).Value)}))

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
If you want to only show the categories already assigned within your dataset as the Items in your dropdown,

Sort( Distinct( Core Tool Matrix','Primary Category'.Value ),Result )

Was this reply helpful? Yes No
James_Anderson 33 on at

Like (0)

Report

How do I wrap that sort/distinct around the formula already in there?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
@James_Anderson

Try

With({_items:ForAll(Sequence(CountRows(Choices('Core Tool Matrix'.'Primary Category'))+1), {Value:If(Value=1, "All", Last(FirstN(lclChoices,Value-1)).Value)})) }, Sort(Distinct(_items, Value),Result) )

Was this reply helpful? Yes No
James_Anderson 33 on at

Like (0)

Report

Gave it a go, it gave an error saying "invalid number of arguements. Received 1 expected 2"

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@James_Anderson

Could you post a screenshot with the error message and the formula please?

Was this reply helpful? Yes No
James_Anderson 33 on at

Like (0)

Report

Had to take a photo as the error on hover doesnt show if you push the screenshot shortcut keys

IMG_0074.jpg

IMG_0078.jpg

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
@James_Anderson

Basically, what I did was try to create a table from your own formula in the "With" then apply Sort() and Distinct() on it. I rarely if ever work with Choice type fields, so it might not work but that is the concept.

With({_items: ForAll(Sequence(CountRows(Choices('Core Tool Matrix'.'Primary Category')+1), {Value: If(Value=1, "All", Last(FirstN(Choices('Core Tool Matrix'.'Primary Category'),Value-1)).Value)})) }, Sort(Distinct(_items, Value),Result) )

Was this reply helpful? Yes No