List: If something begins with a character, then the result is this

[mduntley]

Here is a example of a project that I am doing

If the List has a cell that start with B, then add a column with the text of "Color is good"

= #table({"Town", "Color"}, {{"New York",{"Red","Orange","Green"}},{"Boston",{"Yellow","Blue","Green"}}})[/CODE

Town	Color	Column1
New York	List
Boston	List	Color is good

 

[JGordon11]

let
    Source = #table({"Town", "Color"}, {{"New York",{"Red","Orange","Green"}},{"Boston",{"Yellow","Blue","Green"}}}),
    Result = Table.AddColumn(Source, "Column1", each if List.Count(List.Select([Color], each Text.Start(_,1)="B"))>0 then "Color is good" else "")
in
    Result