Email Format Validation Flag in Power Query M

Adds a boolean column flagging whether a text value looks like a valid email address.

Text TransformationsBeginneremailvalidationflagtext

Power Query M code

let
    Source = YourTable,
    AddedIsValidEmail = Table.AddColumn(Source, "IsValidEmail", each
        Text.Contains([Email], "@") and
        Text.Contains(Text.AfterDelimiter([Email], "@"), ".") and
        Text.Length([Email]) > 5,
        type logical)
in
    AddedIsValidEmail

Notes

This is a lightweight sanity check, not full RFC validation - it catches obviously malformed addresses.

Requirements

How to use this snippet

  1. In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
  2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
  3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Email Format Validation Flag.