How to work with .XLSM spreadsheets - is it any way currently possible?

[younceb]

Hi everyone, I've been presented with the challenge of reading data from a .XLSM file to place in a SharePoint list. So far, I've been unsuccessful with pure Power Automate cloud attempts by trying to get file content and placing it into a newly created file - resulted corrupt. Furthermore, the input file does not have the data saved into a table.

I think I may have to ask the user to transform input data a bit before flow acts on it, but wanted to check if there is ANYTHING that might help get to the data. Potentially thought of maybe planting a spreadsheet in a SharePoint folder with an Office Script to act on another spreadsheet in the same folder, but the Office Script functionality seems limited as well.

Any feedback at all is valuable and would really appreciate it 

[GeoffRen]

I would recommend using an Office Script. They should be able to work with .XLSM files and you should be able to return the even non table data to Power Automate for use later in the Flow. It seems you tried using Office Scripts to do this a bit. What troubles did you have? 

[younceb]

I was able to talk with the business to change the file from a .XLSM to a .XLSX that allowed me to use an Office Script that is kind of working now. Thank you for the help

[younceb]

Use macro-enabled files in Power Automate flows - Office Scripts | Microsoft Docs