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 

 

2 REPLIES 2
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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,870)