How to use macro-enabled files in Power Automate flows
Power Automate flows support .xlsm files in the Excel Online (Business) connector. However, only the Run script action lets you select .xlsm files through the file browser. Other connector actions require you use the file ID.
Get the file ID with a Get File Metadata action from either the OneDrive for Business or SharePoint connectors. Use the ID dynamic content returned from the Get file metadata action as the "File" argument for Excel connector actions. Note that parameters such as "Table" in the Add a row into a table action won't automatically propagate a dropdown list of tables to choose. You'll need to enter the name of the table or other Excel object.
Important
The macros contained in the .xlsm files cannot be run through Power Automate. Only Office Scripts are enabled there.
Warning
Some .xlsm files, especially those with ActiveX or Form controls, may not work in the Excel online connector. Be sure to test before deploying your solution.
See also
Office Scripts