Unanswered

Get Excel table

(0) Share

Report

Posted on by ezequiel

Hi,

I have a simple flow that should read a table in Excel and send the data via email. I'm getting the following error when trying to get the table:

The excel is not a macro-enabled excel and it contains 2 worksheets. The Table is in one of those worksheets.

Any help to solve it?

Thanks

Ezequiel

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @ezequiel ,

Please have a look at this post

https://powerusers.microsoft.com/t5/General-Discussion/List-Rows-Present-in-a-Table-Microsoft-Flow/td-p/334654

Let me know how it goes.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
ezequiel on at

Like (0)

Report

Unfortunately not. I tried to recreate the connection, change the file from onedrive to a sharepoint, but I'm still getting the same error...any other idea?

Thanks,

Ezequiel

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @ezequiel,

Have you tried re-creating the connection of Excel, you can recreate the connection by clicking showed in the screenshot:
Or using an excel document that had some features that were unsupported by excel online. Removing these features to fix this issue.
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
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @ezequiel ,

Makes sure you have a table created in your Excel sheet.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No