web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / I am getting error in ...
Power Automate
Unanswered

I am getting error in upload excel flow

(0) ShareShare
ReportReport
Posted on by 145

HI All I am getting error as follows - 

 

The 'inputs.parameters' of workflow operation 'List_rows_present_in_a_table' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'drive'

 

My flow images I have added below- 

 

iAM_BA_0-1709012549232.pngiAM_BA_1-1709012585918.png

 

 

 

Error image -- 

iAM_BA_2-1709012621371.png

 

 

Please give me the solution.

Thank!

 

Categories:
I have the same question (0)
  • rzaneti Profile Picture
    4,456 Super User 2026 Season 1 on at

    Hi @iAM_BA ,

     

    Based on the images, it looks like you are creating a new Excel file and then referencing "drive" as table in a "List rows present in a table".

     

    If this is the case, you can follow the steps below to properly reference the Excel table in the created document. This is the flow overview:

    rzaneti_0-1709037939661.png

     

    In the "Get tables" action, reference your just created file. In your case, you will probably need to use the "Full path with extension" or "File ID" property in the "File" input:

    rzaneti_1-1709038007159.png

     

    Then you add the "body/value" of the "Get tables" into a "Filter array" action (the "Get tables" does not have an enabled filter query) and set the "name" property dynamic content in the left side input. On the right side input, enter your table name: 

    rzaneti_2-1709038100161.png

     

    Finally, in your "List rows present in a table" action, enter an expression to reference the "id" property of the first element of "Filter array" body:

    rzaneti_3-1709038176252.png

     

    In this case, we are using [0] to reference the first table returned by the "Filter array" (technically you cannot have more than one table with the same name in the file), and then using ['id'] to reference this property inside the table object.. 

     

    Output:

    rzaneti_4-1709038509822.png

     

    I will also let this article about integrating Power Automate and Excel tables for you or any future users that find this thread: http://digitalmill.net/2023/07/17/integrating-power-automate-and-excel-tables/ 

     

    Let me know if it works for you or if you need any additional help!

     

    -------------------------------------------------------------------------
    If this is the answer for your question, please mark the post as Solved.
    If this answer helps you in any way, please give it a like.

    http://digitalmill.net/ 
    https://www.linkedin.com/in/raphael-haus-zaneti/ 

     

     

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard