Unanswered

"No items" when browsing for exel file in item location

(0) Share

Report

Posted on by Community Power Pla...

If I start in Excel, open the Flows add in, continue to "for a selected row," I select the correct Sharepoint Site in the Location field, the correct document in "Document Library," but then in the "File" field it lists "no items" and cannot find my Excel file.

I am new to the power automate world, so I'll share a few things that may or may not be helpful to know. The Excel file

is just under 2MB
uses macros
has 7 tabs
one tab has 12,000 rows (the tab which has the table I want to use has under 2,500 rows).

My company has OneDrive for Business.

Why does Power Automate not even see my Excel file in its folder?

Thank you for your help!

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

Hi @Anonymous,

It's unfortunate that Macro-enabled files are not supported in Microsoft Flow for now.

If you like this feature and want it could be added to Excel connector in the future, you could go to vote for this idea:

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

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks @v-litu-msft,

That's what I needed to know. I went and voted for this feature through the link you provided.

e_shepherd

Was this reply helpful? Yes No