It looks like colShowNames.Value is a table, but Show_Name in col_Event_Data_Collection is a single value. The "Can't convert this data type" error happens because Power Apps can't compare a single value to a table.
Possible Issue:
The Checkbox inside Gallery2 doesn't store just a single value but contributes to a collection (colShowNames).
The collection (colShowNames) might have been created incorrectly, storing the entire record instead of just the Value field.
You might need to extract values properly from colShowNames.
Fix:
Instead of:
col_Event_Data_Collection.Show_Name in colShowNames.Value
Try:
powerapps
Copy
Edit
col_Event_Data_Collection.Show_Name in colShowNames.Value
Replace it with:
col_Event_Data_Collection.Show_Name in colShowNames
or explicitly extract values:
col_Event_Data_Collection.Show_Name in ShowColumns(colShowNames, "Value")
Additional Debugging Tips:
1️⃣ Check how colShowNames is stored
Before filtering, check what colShowNames contains:
ClearCollect(colShowNames, Gallery2.Selected.Value)
If colShowNames is storing records instead of just Value, modify it:
ClearCollect(colShowNames, ShowColumns(Gallery2.AllItems, "Value"))
Then use ShowColumns(colShowNames, "Value") in your filter.
2️⃣ Ensure 'OnCheck' is correctly adding values
Your Checkbox OnCheck should be adding selected items properly:
powerapps
Copy
Edit
Collect(colShowNames, { Value: ThisItem.Value })
And OnUncheck should remove them:
RemoveIf(colShowNames, Value = ThisItem.Value)
