Extracting Email Addresses from a Table Column Based on a Person Data Type

Hello ronaldwanat,
Thank you for reaching out to the Microsoft Fabric Community Forum.

I’ve reproduced your scenario using Power BI Desktop and simulated a SharePoint List Person-type column that allows multiple people per row. Since such columns are internally structured as nested tables (or JSON when accessed through certain connectors), there’s no direct “Parse JSON” or “To Table” option in Power Query UI. However, this can be solved using Power Query M code.

Steps Used:

Parsed the JSON in the Approvers column using:

Json.Document([Approvers])​

• Expanded the list to rows.
• Expanded each record to extract Name and Email.

Grouped by ID and used:

Text.Combine([Email], ", ")​

I’ve attached the working .pbix file demonstrating the entire transformation from source to final output.

Output :

Best Regards,
Ganesh singamshetty.