Anyway to read a xlsm file and copy content to a sharepoint list?

[shreymudgal]

I have a marco-enabled excel file in a share point folder. 

Would it be possible to create a flow that can get content of the file and update a list in sharepoint?



Thanks for the help!

[tfhegdbn]

I did the test, it seems that the Excel online action can only get the contents of the xls or xlsx files.

[v-yamao-msft · Accepted solution]

Hi @shreymudgal ,

As @tfhegdbn  suggested, Excel Online (Business) connector can only get contents of xls and xlsx files. Working with macro-enabled files is currently not supported yet.

There is a similar request on Flow Ideas Forum, please vote the idea at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/Enable-actions-on-macro-enabled-files/idi-p/59194#com...

In addition, I will help collect and report it as well. PGs will take hot ideas into consideration first in future releases.

Best regards,

Mabel

[scotth82]

Hi,

One possible solution is to use the OneDrive connector for converting the file to a new xls file and then use that file for the import into your list.

Thanks

Scott

[shreymudgal]

Hi @scotth82, How do i convert to xls, the only option I get is PDF. 

Thanks, 

[scotth82]

Ah I'd not tested it, my apologies.

[Jbotto]

Hi Scott,

We’re able to convert the file?

Thanks!