cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
babyjb123
Frequent Visitor

Can not open table in a Excel file

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?1.png

babyjb123_0-1660080343768.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
MarconettiMarco
Super User
Super User

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

View solution in original post

3 REPLIES 3
MarconettiMarco
Super User
Super User

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

Hi,

 

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

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?

babyjb123_0-1660143952870.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,708)