Unanswered

Dynamic Excel Table calling

(0) Share

Report

Posted on by jaikumar_j22

If i hard code the table name using custom value then the below error is seen

No table was found with the name 'Semister'.
clientRequestId: 5cd7ac3d-a019-43bd-a05e-789ee960d573
serviceRequestId: 6bdd7514-82e3-4e04-8d81-052b15e53abb

If i refer the excel using SharePoint Get File Properties then the below error is seen

Action 'Process_Tables' failed -- Get tables is not displaying any table info even if the excel files contains tables

Can anyone provide solution for this issue.

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Sort by

lbendlin 8,690 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you confirm that you want to access tables that you have previously defined in the Excel file? Or are you trying to access ranges? or sheets?

Was this reply helpful? Yes No
jaikumar_j22 8 on at

Like (0)

Report
Copy link

Link copied!

Yes , as you rightly stated need to access tables that will present in the excel file but the excel files along with table will be created dynamically on a given period and once it is read this excel needs to be deleted .

Was this reply helpful? Yes No
lbendlin 8,690 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you provide a sample Excel file for testing?

Was this reply helpful? Yes No
jaikumar_j22 8 on at

Like (0)

Report
Copy link

Link copied!

Do let me know how to attach a table in this post i am not able to find one over here. Kindly assist

Was this reply helpful? Yes No
lbendlin 8,690 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can use one of the file services like OneDrive or Google Drive.

Was this reply helpful? Yes No
jaikumar_j22 8 on at

Like (0)

Report
Copy link

Link copied!

C:\Users\a874680\OneDrive - Atos\Leave - Global Automation Architects - Global Architects\Default.xlsx

do let me know whether you can download this file

Was this reply helpful? Yes No
lbendlin 8,690 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

That's the wrong (local) end of the OneDrive stick. And you probably don't want to use your work account for this anyway

Was this reply helpful? Yes No
jaikumar_j22 8 on at

Like (0)

Report
Copy link

Link copied!

I cannot share this file out from my official account as part of security reasons

Was this reply helpful? Yes No