Convert table to list and use that in function

Hi rbabu ,

Thanks for the update. We cannot convert the value '"Afghanistan","Albania",...' to type List.

It seems that CountryLOV2 is currently a text string, not a real Power Query list. Even though it looks like a list, Power Query still treats it as a single text value.

To fix this, you can convert the string into a real list using the Text.Split function. For example.

Then, you can  use:  List.Contains(CountryLOV2,[Country])

Helpful Docs:

Text.Split - PowerQuery M | Microsoft Learn
List.Contains - PowerQuery M | Microsoft Learn

If my response solved your query, please mark it as the Accepted solution to help others find it easily.

And if my answer was helpful, I'd really appreciate a 'Kudos'.