Using the Text.Contains and List.AllTrue

[bmacman]

Hi ALl,

I am not getting the results from the Text.Contains to work at all. I am trying to use it as part of the List.AllTrue string. Does it work or any suggestions?

if List.AllTrue(
{[Delay Catergory]="Planned Down"}) then "7"
else if List.AllTrue(
{[Delay Catergory]="Planned Down",
Text.Contains([Description], "Plant",Comparer.OrdinalIgnoreCase)=true
}) then "71"

else if

This is just giving me a the eresult of 7, never the 71.

Thanks in advance.

Cheers

Brad

[wdx223_Daniel · Accepted solution]

if List.AllTrue({[Delay Catergory]="Planned Down",
Text.Contains([Description], "Plant",Comparer.OrdinalIgnoreCase)
}) then "71"
else if List.AllTrue({[Delay Catergory]="Planned Down"}
) then "7"

[bmacman]

Thanks. I have restrucutred so I am not looking for the same Text.Contains under different delay catergories. 

It works just not quite fully as easily informative, have to have a lot more else if