Excel file types

(0) Share

Report

Posted on by MW-08011449-0

Hi,

I am trying to use the 'Get row' action to link into an excel sheet. The excel sheet in question uses macros and is there for a .XLSM file.

When looking for the file in the action parameters I cannot find it but the .XLSX in the same folder is visible.

Are there limitations on the file types that can be used with the 'Get row' action block?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report

Hi MW-08011449-0

Power Automate Desktop supports interacting with macro-enabled workbooks.

Open the workbook. Extract the required data. Close the workbook.

This approach is more complex but allows for direct interaction with .XLSM files.

If your workflows frequently depend on .XLSM files, consider automating the process of saving or exporting the data to .XLSX format to maintain compatibility with Power Automate.

if you need more details, pls let me know. thanks

Was this reply helpful? Yes No
Suggested answer

rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

There is no limitation for spreadsheets with macros. Although the .xlsm files are not displayed in the file tree of Excel actions, you can manually enter their name in the "File" input (highlighted below):

The action will run successfully:

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MW-08011449-0,

I just want to confirm if you had a chance to test the solution recommended in my previous message.

If it's working properly and answered your question, please mark it as Accepted Answer, so other users with the same issue can find it easily in the future :)

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

http://digitalmill.net/

https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No