Can you provide workbook, please?
The error means that the field you want to filter on (target field) is not present in sheet 2 (source sheet). Selected fields for action filters must be in both source and target sheets.
The error message below can be resolved by placing [Row ID] somewhere suitable in Sheet 2, like the Row shelf, Column shelf or Details card.
Hope this helps.
I can't match the two sheets withouth showing the fields? The view became horrible!