Forum Discussion
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 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
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"
2 Replies
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"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
