Add custom Column, Filter List values

[pmars]

Hi,

I found many things in the forum, but i guess i can't get it. So, here I am :

1. I've got a table which contains a column called checkName. Values of this column are nullable text (names). There's only one name max.

2. I have a list of names : {John,Jack,Jean,June}

I want a custom column added to get all values from my list which are not contained in the checkName Column

Example below :

Date	checkName	customColumn
today	John	{Jean,Jack,June}
tomorrow	Jack	{John,Jean,June}

Every attempt dropped me an error 'expression error" : "We cannot apply field access to the type Text"

Any help would be welcome!

Thank you!

[pmars · Accepted solution]

I think i ve found : List.RemoveItems(Names, Text.Split([checkName],";"))

thx