Power Platform Community Forum Thread Details

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-

Error image --

Please give me the solution.

Thank!

Categories:

General topics

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:

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:

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:

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:

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:

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/