Answered

No items found in The action 'List Rows present in Excel Table ' of Excel Online (Business)

(0) Share

Report

Posted on by AlwasyMKT

Hi,

I trying to import the data from excel into SQl server database which using action 'List Rows Present in Excel Table' of Excel Online (Business), but there is no items found on the dropdownlist table.

In excel I already named "Jan 2019" , "Feb 2019", "Mar 2019" as sheet name. Is the sheet name suppose to list down on the table dropdown list?

Please advise. Thanks you for any help, that's appreciated

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-bacao-msft on at

Like (1)

Report

Hi @AlwasyMKT ,

It seems that you posted two identical questions, please refer to another post:

https://powerusers.microsoft.com/t5/I-Found-A-Bug/No-items-found-in-The-action-List-Rows-present-in-Excel-Table-of/m-p/274491#M4278

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
Kavya1 54 on at

Like (1)

Report

Hi @AlwasyMKT ,

What was the solution you found way back then because I am having same error now and the above link mentioned is giving me Access Denied.

Was this reply helpful? Yes No
PeterO_82 48 on at

Like (0)

Report

Me too... Did you find a solution, @Kavya1 ?

Was this reply helpful? Yes No
Kavya1 54 on at

Like (1)

Report

Hi @PeterO_82

I created a Table inside Excel and copied the data inside, save. Then while using 'List Rows present in Excel Table', it shows the Table name in the dropdown. For me it was Table1.

Hope it helps.

Was this reply helpful? Yes No
PeterO_82 48 on at

Like (0)

Report

Thank you! Yes, I got confused about the difference between the names of the Table and the Sheet. Somehow I never realized there could be more than one table per sheet. 😳

Was this reply helpful? Yes No