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?
Solved! Go to Solution.
LookUp() only returns the first result. You want to use Filter() in this case.
LookUp() only returns the first result. You want to use Filter() in this case.
Thanks. I've used Filter 20 times now and I suppose I just had a brainfart putting this together.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
175 | |
46 | |
46 | |
34 | |
33 |
User | Count |
---|---|
258 | |
87 | |
78 | |
68 | |
67 |