Power Platform Community Forum Thread Details

Hello,

i have created a flow, excle file is in the share point and has pivot talbe. its done via Power automate.

now i wanted to send pivot table via email. kindly suggest how to send it.

Categories:

Hi @ CU19020903-0,

If you want the pivot values inside the email body (not the full file), you can’t directly read the Pivot Table from Power Automate as far as I know. It doesn’t understand pivot objects.

My suggestion is, in the same Excel file, create another sheet.
Reference the pivot result area using normal formulas. Basically flatten the pivot output into a normal grid.

Then convert that range into a proper Excel Table since Power Automate can only read structured tables.
In the flow, Use List rows present in a table, then use Create HTML table, Put that output into the email body.

That way you are not touching the pivot itself. You are just reading a normal table that mirrors it.

If this helped solve your issue, please mark it as ✅ Accepted Answer.
If you found it useful, a 🩷 Like is always appreciated.

Thanks,
Tharusha