web

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

News and Announcements icon

Power Platform CommunityForums Power Apps ADD "All" to Dropdown ...

Power Apps

Answered

ADD "All" to Dropdown using collection

(0) Share

Report

Report

Posted on by naidu1811

109

ClearCollect(

naiduc,

{ Result: "All" }

);

Collect(

naiduc,

Distinct(shoe_inventory, ProductCategory)

);

This is collection syntax OnVisible Property.

I want to use this collection in Dropdown filtering with ProductCategory along with "all". Give me syntax

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (3)

Report
Copy link

Link copied!
Hi @naidu1811,

Distinct returns a single column called 'Value'. In older blog posts / videos you may see 'Result' being mentioned as the output column used to be named 'Result' until early 2023.

In this case, adjust the initial ClearCollect column name to Value:

ClearCollect( naiduc, {Value: "All"} );

As a note, you can also use the code below directly in the items property of your dropdown instead of using a collection:

Table( {Value: "All"}, Distinct(shoe_inventory, ProductCategory) )

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No

Join the conversation