Share
Report
15Hello, I would really appreciate your help with this collection formula output issue. I want to create a new collection table based on filters the user chooses. I have three combo boxes that filter my dataverse data source called 'RestOp' and I have added my filter formula. How do I define the columns that will show up on in the collection? With the formula below only the choices from the combo boxes show up.
Collect( NewTable, Filter(
'RestOp',
And(
Or(
IsBlank(ComboBox2.SelectedItems),
IsEmpty (ComboBox2.SelectedItems),
Pace in ComboBox2.SelectedItems
),
(Or(
IsBlank(ComboBox7.SelectedItems),
IsEmpty (ComboBox7.SelectedItems),
Mode in ComboBox7.SelectedItems
)),
(Or(
IsBlank(ComboBox18.SelectedItems),
IsEmpty (ComboBox18.SelectedItems),
'State' in ComboBox18.SelectedItems
) )
)
)
)
Categories:
I have the same question (0)
All responses (
Answers (
