hi @vffdd ,
On your button’s OnSelect property, add the following formula:
ClearCollect(
colFilteredStaff,
Filter(
Staff,
Status in cbStatus.SelectedItems.Value
)
)
If you encounter delegation warnings, which might happen if your SharePoint list is large, you might need to handle it differently. For example, by iterating through the selected values in cbStatus and collecting matching records:
Clear(colFilteredStaff);
ForAll(
cbStatus.SelectedItems,
Collect(
colFilteredStaff,
Filter(
Staff,
Status = ThisRecord.Value
)
)
);
Make sure the Status column in your SharePoint list and the items in cbStatus combo box have matching values.
