Hoping someone can help me with my issue. I am trying to filter a large Sharepoint list by utilizing tabs, combo boxes and a text search box. I am able to filter between my tabs, but can not get my other filters to work with them. I have a very large Sharepoint list so the more filters the better. My formula in Items is this:
Switch(
ctxTabs,
"Vendor1",
Filter(
'SharepointList',
Supplier2 = "Vendor"
),
"Vendor2",
Filter(
'SharepointList',
Supplier2 = "Vendor2"
),
"Vendor3",
Filter(
'SharepointList',
Supplier2 = "Vendor3"
)
)
Where do I add the other filtering in? Am I even using the correct method? Help!

Report
All responses (
Answers (