Filter not working properly

Hi AlexTheGreat ,

Thank you for reaching out to Microsoft Fabric Community Forum.

You're using Azure Data Factory (ADF) to pull XML data into your database. The problem is: you want to exclude certain customers based on their CustomerID (Sap_ID) — because they don’t use your apps, so they aren’t needed in the report.

You tried filtering one CustomerID using:

@not(equals(item().Customer_SapID, 123456))

This works for just one ID, but you need to filter multiple IDs, like excluding 123456, 789012, and 345678. Also, ADF gave you an error saying “expects an array” because the filtering logic wasn’t using a proper list.

You can do a few workarounds:

1. Create a list of IDs you want to filter
   For example:
   ["123456", "789012", "345678"]
2. Pass it as a parameter or set it in a variable
   This is your exclusion list.
3. In your Filter activity, use this logic:
   @not(contains(variables('BlockedCustomers'), item().Customer_SapID))
   If you're using a pipeline parameter instead of a variable, just change it to:
   @not(contains(pipeline().parameters.BlockedCustomers, item().Customer_SapID))

This will filter out all items in your data that match the CustomerIDs in the list.

If you want to keep only certain customers, use:

@contains(pipeline().parameters.AllowedCustomers, item().Customer_SapID)

If you're passing your list as a text string like "123456,789012", just convert it to a list using:

@split(pipeline().parameters.CustomerIDs, ',')

Regards,

B Manikanteswara Reddy