I have a label with Text set to:
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?
Go to Solution.
LookUp() only returns the first result. You want to use Filter() in this case.
View solution in original post
Thanks. I've used Filter 20 times now and I suppose I just had a brainfart putting this together.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand