cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
younceb
Advocate I
Advocate I

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

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 

 

3 REPLIES 3
GeoffRen
Microsoft
Microsoft

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
Advocate I
Advocate I

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
Advocate I
Advocate I

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,423)