Power Platform Community Forum Thread Details

Hello, Team.
Is there any action that can be utilised to create a pivot table using Power Automate Desktop Flow?

Categories:

Power Automate Desktop does not have any native actions for building or modifying Pivot tables in Excel. What you can do, however, is use the Run VBscript action to call a VBscript that creates/modifies your Pivot table.

See this page for reference. This is part of the WinAutomation (predecessor of Power Automate Desktop) documentation, but the Run VBscript action works the same way and the script itself is valid.

https://learn.microsoft.com/en-us/previous-versions/troubleshoot/winautomation/process-development-tips/excel-automation/pivot-table-using-vbscript

It has a pretty detailed explanation, and also provides references for more details.

-------------------------------------------------------------------------

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.