Dealing with nulls when checking email format in a new column

Hi 83dons ,

You just need to add a simple null check to your existing formula to avoid errors. I hope this gives you the desired output.

Table.AddColumn(
    #"Replaced Value1",
    "Custom",
    each 
        if [Main Email Address] <> null 
            and Text.Contains([Main Email Address], "@") 
            and Text.Contains(Text.Range([Main Email Address], Text.PositionOf([Main Email Address], "@")), ".") 
        then [Main Email Address] 
        else null
)

Best Regards,
Muhammad Yousaf

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

LinkedIn