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
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.