Case insensitive table.findtext across multiple columns

MStaford 

you can try this to create a new column to check.

= Table.AddColumn(Source, "Custom", each
[a=List.Skip(Record.ToList(_)),
b=List.RemoveItems(List.Transform(a, each Text.Lower(_)),{"true"}),
c=if List.Count(b) = 0 then true else false]
[c]
)

pls see the attachment below

Hi ryan_mayu 

Try this custom  column in the query editor. Use List.AnyTrue to return true if any of the values in the list  is true

let
    // Step 1: Define a list of values
    ColumnsAsAList = {[bla1], [yaba2], [daba3], [lama], [doo]},

    // Step 2: Convert each value in the list to a logical (true/false)
     ChangedType = List.Transform(ColumnsAsAList, Logical.From),
    // Step 3: Check if all values in the list are true. Use List.AnyTrue to return true if any of the values in the list  is true
    TrueOnly = List.AllTrue(ChangedType)
in  
   TrueOnly

Hi ,

The method ryan_mayu provided should be helpful.

Besides, you can also try the following formula to add the custom column.

if Text.Contains([bla1], "true", Comparer.OrdinalIgnoreCase) or
   Text.Contains([yaba2], "true", Comparer.OrdinalIgnoreCase) or
   Text.Contains([daba3], "true", Comparer.OrdinalIgnoreCase) or
   Text.Contains([lama], "true", Comparer.OrdinalIgnoreCase) or
   Text.Contains([doo], "true", Comparer.OrdinalIgnoreCase)
then "true" else "false"

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi danextian andryan_mayu,

Thankyou for your reply and suggested solutions. The minimum condition for true value to be the result is that atlease one col should have a true value and only if all appears false then the result should be false. Apologies if i was not clear in my notes above. Here is a quick sample..

AnonymousI have not tried your method but will give it a go and come back.