HELP! Error: Expression.Error: We cannot convert the value null to type Logical.

Question

Hi,&nbsp;I keep getting an error that states, "Expression.Error: We cannot convert the value null to type Logical. Details: Value= Type=[Type] when it runs the code for my custom column. The only commonality I can identify is that one of my columns ([Issue])are all null.&nbsp;My columns are ordered: [Issue Category], [Issue], [Date], [Error Code], [Report Type],l [C_Status], [D_Status]&nbsp;How would I get the custom column to result in "Review Needed" if any of ([Issue Category], [Issue], [Date], [Error Code], [Report Type]) are null/blank AND&nbsp;[C_Status], [D_Status] = "N/A" or "Completed"?

antrikshsharma · Accepted Answer

Anonymous&nbsp;Use this:let
    Source = Table,
    Result = 
        Table.AddColumn ( 
            Source,
            "Check",
            (CurrentRow)=&gt;
                let
                    CurrentRowList = Record.ToList ( CurrentRow ),
                    ValuesList = List.FirstN ( CurrentRowList, 5 ),
                    StatusList = List.LastN ( CurrentRowList, 2 ),
                    HasNull = List.NonNullCount ( ValuesList  ) &lt;&gt; List.Count ( ValuesList ),
                    HasNACompleted = List.ContainsAny ( StatusList, { "N/A", "Completed" } ),
                    Result = if HasNull and HasNACompleted then "Review Needed" else "Pass"
                in   
                    Result,
            type text
        )
in
    Result

Forum Discussion

Related content

[Expression.Error] cannot convert null value to Logical

Logic problem?

FX Conversion Logic

We cannot convert the value null to type Logical error

[Expression.Error] We cannot convert the value null to type Logical.