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!

[MichChrdk]

Maybe use powerquery to import table from xlsm to a xls file and use that as the flow source?

It does insert an additional file update, but you could work that into a macro in the xlsm file.

Set the flow to trigger on changes in the xls file.

process:

1: make changes in xlsm

2: makro in xlsm opens xls file and performs "updateall" - wait X seconds - save and close xls - return to xlsm file

3: flow triggers on changes in xls file and runs on the content of xls file