Help: Pass a list as filter argument in Power Query

[Ikeumlaut]

Hey,

I need to pass a list as a filter argument in query editor to multiple tables. I have a list of Survey Ids in an excel file and I need to pass that list to multiple tables in query editor.

I've tried this but I cannot get it to work.

Thanks!

[stretcharm · Accepted solution]

Import the List.

Use a Merge each query with this using an inner join and it will remove items not in the list.

[Ikeumlaut]

Worked! Thank you!