Answered

ClearCollect - Add "All" results

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I've added a dropdown to filter my gallery. Therefore, I created a collection with diyplays all the distinct results in my table. Now I also want to have one items which says "All" and shows every result in my list. I've tried the following:

ClearCollect(collectMonths; {Result: "All"});
Collect(collectMonths; Distinct(Statement; Month))

The Collect part is working fine but the ClearCollect function gives out an error saying that the function has invalid arguments.

Thanks!

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

I think you need to use , instead of ;

ClearCollect(collectMonths, {Result: "All"});
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@Mira_Ghaly

I was using the German version of PowerApps so that's not the issue.

I tried using both formulas separately and both of them work fine. Only together it doesn't work. Any idea on how to solve that? It seems like this ; after the first formula is the issue.

I've changed to the American version of PowerApps now, so my code looks like this:

ClearCollect(collectMonths, {Result: "All"}); Collect(collectMonths, Distinct(Statement, Month))
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Try

ClearCollect(collectMonths, {Result: "All"}); Collect(collectMonths, Distinct('Statement', Month))
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Mira_Ghaly

Makes no difference unfortunately.
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

So are you sure of your table and column name for the Distinct ?

Can you share the error message?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Mira_Ghaly
Yes, as I mentioned above. Both formulas individually work. Just together it gives out an error.
For both functions the error is that they have some invalid arguments and in the collect function it shows another error that it is an incompatible type to put into a collection.
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

From the error message it looks like you are appending different types so something like string and integer.
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

If you are trying to add an "All" to your list, you can do this without a collection (as it is a bit of unneeded overhead for your app, and just another thing to keep track of, and a pain to maintain).

You might be interested in my video on that subject.

As for the formula, you need to change the type of your Month (assuming it is numeric):

ClearCollect(collectMonths, {Result: "All"}, Distinct(Statement, Text(Month)))