I am wondering if anyone has done a filter a SP List and used a variable, say from a With statement, as the column name to filter for certain criteria (and gotten it to work). Something like:
With({FilterCritera:DropDown1.Selected.Value},
ClearCollect(colEvidenceCollection,
Filter(SPListName, FilterCriteria = "Yes")))