Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Dynamic Excel Table calling

(0) ShareShare
ReportReport
Posted on by 8

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.

 

 

  • jaikumar_j22 Profile Picture
    jaikumar_j22 8 on at
    Re: Dynamic Excel Table calling

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

     

  • lbendlin Profile Picture
    lbendlin 7,597 on at
    Re: Dynamic Excel Table calling

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

  • jaikumar_j22 Profile Picture
    jaikumar_j22 8 on at
    Re: Dynamic Excel Table calling

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

     

    do let me know whether you can download this file 

  • lbendlin Profile Picture
    lbendlin 7,597 on at
    Re: Dynamic Excel Table calling

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

  • jaikumar_j22 Profile Picture
    jaikumar_j22 8 on at
    Re: Dynamic Excel Table calling

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

  • lbendlin Profile Picture
    lbendlin 7,597 on at
    Re: Dynamic Excel Table calling

    Can you provide a sample Excel file for testing?

  • jaikumar_j22 Profile Picture
    jaikumar_j22 8 on at
    Re: Dynamic Excel Table calling

    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 .

  • lbendlin Profile Picture
    lbendlin 7,597 on at
    Re: Dynamic Excel Table calling

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard