Forum Discussion

bmacman's avatar
bmacman
Frequent Visitor
3 years ago
Solved

Using the Text.Contains and List.AllTrue

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 C...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    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"

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

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's avatar
bmacman
Frequent Visitor
3 years ago

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