Collection not filtering correct?

(0) Share

Report

Posted on by TimmyBoy

997

Hello,

What are we doing wrong?

It shows all the data from colMyList2

Instead only the one with ShowNotification = true

ClearCollect(
 ColNotificationList;Filter(colMyList2;ShowNotification = true);
 ShowColumns(
 colMyList2;"ID";"ShowNotification";"ShowNotificationDate"
))

I have only 1 with shownotification = true

And he shows 330 records?

Any help please.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Ethan_009 4,838 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @TimmyBoy ,

1st check if the logic is correct then filter columns

ClearCollect( ColNotificationList; Filter(colMyList2; ShowNotification = true); );

If this works, then instead of filter, go with putting ShowColumns(Filter() )

Hope this helps

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,419 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @TimmyBoy ,

Try this format

ClearCollect( ColNotificationList; ShowColumns( Filter( colMyList2; ShowNotification ); "ID"; "ShowNotification"; "ShowNotificationDate" ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
TimmyBoy 997 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Ethan_R
That works

Was this reply helpful? Yes No
TimmyBoy 997 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
Thanks, just what i needed 😉
Thanks guys, you are the best

Was this reply helpful? Yes No