Can not open table in a Excel file

[babyjb123]

Hi all,

I am trying to use an Excel file to populate a Word template. On the first step, it is stuck. The Excel file I am using is very simple one in the OneDrive, when I want to select Table, there is No Item. What's wrong with my file?

[MarconettiMarco · Accepted solution]

Hello @babyjb123 ,

is your excel range already formatted as a table? Otherwise, Power Automate isn't able to grab it.

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[babyjb123]

Hi,

Thank you for your reply! I tried to convert the Excel file from range to table, it still doesn't work.

[babyjb123]

Hi MarconettiMarco,

The Excel table was grabbed after converting from range to table. But new issue pops up:  value in Excel can not be grabbed?