Filter not working from collection. Only working for hard coded values

(0) Share

Report

Posted on by zmansuri

6,048 Super User 2024 Season 1

Code on Gallery:

Filter(
 BudgetTracker,
 Year.Value = drpYear_7.Selected.Value,
 Company.Value in ComboBox1_11.SelectedItems || ComboBox1_11.Selected.Value = "All",
 OfficeLocation.Value = drpOffice_6.Selected.Value || drpOffice_6.Selected.Value = "All",
 Month.Value in ComboBox1_3.SelectedItems || ComboBox1_3.Selected.Value = "All",
 Category.Value in cmbExpCat.SelectedItems || cmbExpCat.Selected.Value = "All"
 )

Code to make collection:

ClearCollect(
 colExpenseCategoryChoices,
 Choices(Expenses.Category)
);
Collect(
 colExpenseCategoryChoices,
 {Value: "All"}
)

When i use collection filter is not working. When i use hardcoded values it works. Also When i use Selected.Value Instead of SelectedItems it works for collection too.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok. This worked. But i don't know why. collection itself is table. Why do i need to write value
Verified answer

WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @zmansuri ,

You can probably tidy up the code with some distinct bracketing as below

Filter( BudgetTracker, Year.Value = drpYear_7.Selected.Value && ( ComboBox1_11.Selected.Value = "All" || Company.Value in ComboBox1_11.SelectedItems ) && ( drpOffice_6.Selected.Value = "All" || OfficeLocation.Value = drpOffice_6.Selected.Value ) && ( ComboBox1_3.Selected.Value = "All" || Month.Value in ComboBox1_3.SelectedItems ) && ( cmbExpCat.Selected.Value = "All" || Category.Value in cmbExpCat.SelectedItems ) )

and

Collect( colExpenseCategoryChoices, {Value: "All"}, Choices(Expenses.Category) );

but to answer your question, you still may need to specify the field you want to display

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.