web

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

News and Announcements icon

Power Platform CommunityForums Power Apps ClearCollect returning...

Power Apps

Answered

ClearCollect returning one of 90 items

(0) Share

Report

Report

Posted on by notj

782

I have a label with Text set to:

CountIf(FacAppCapBudget, budgetYear="2019")

Result: 90

I have a button OnSelect set to:

ClearCollect(CurrentFacilityBudgets, LookUp(FacAppCapBudget, budgetYear="2019"))

Result: 1 item, which would be the first item alphabetically.

What am I doing wrong here?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

LookUp() only returns the first result. You want to use Filter() in this case.
notj 782 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks. I've used Filter 20 times now and I suppose I just had a brainfart putting this together.

Join the conversation