Power Automation flows provides Excel connectors to help connect Excel files with rest of your organizational data/apps such as Teams, Outlook, SharePoint, etc.
However, one of the limitation is that macro files cannot be selected in the file drop-down. See the screen shot below. ' One way to get around this issue is by including "Get File Metadata" action (OneDrive or SharePoint) and use the ID property in the "Run Script" action as showin in the second screenshot.
Note: Some XLSM (esp. the ones with ActiveX/Form controls) may not work in Excel online connector. Be sure to test before deploying your solution.
Hope this helps!
No XLSM in Excel Online connector
Use XLSM Macro file in Excel Online Run Script actinon
