Skip to main content

11 posts tagged with "Power Query"

Power Query for Getting and Shaping Data, with Its Steps and M Formulas, in Power BI and Excel

View All Tags

How to Get the Email from a SharePoint Person Column in Power Query

· 6 min read
Jagdish Kumawat
Founder @ Dewiride

A SharePoint Person column doesn't arrive in Power Query as a name or an email. In the SharePoint Online list connector's implementation 2.0, it shows as [List] or [Table]: a structured value with the person's id, name, email and more. Expanding it gives you a plain email column. Here's how, for a column that holds one person and for one that holds several.