Cannot select table when connecting to an Excel file

[itshouldwork]

I try to connect responsed collected in Forms to a visualisation in Power BI. To do this, it seems one has to use Power Automate. I tried to build the following flow but cannot select the correct "table" of the Excel file. The drop-down menue should list all sheets of the table. If entering custom values, I receive the below mentiones error. What am I doing wrong? Thanks for any hints!

The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "The requested resource doesn't exist. clientRequestId: (…) serviceRequestId: (…)", "error": { "message": "The requested resource doesn't exist." }, "source": "excelonline-we.azconn-we.p.azurewebsites.net" }

[Brad_Groux]

Please note, that there are multiple Excel connectors with hugely different capabilities: 

• Excel Online (OneDrive) - Connectors | Microsoft Docs
• Excel Online (Business) - Connectors | Microsoft Docs

Also, you will notice that each has their own extensive list of known issues and limitations:

•  Excel Online (OneDrive) - Limitations | Microsoft Docs
• Excel Online (Business) - Limitations | Microsoft Docs

First you should ensure that you are using the right connector, and that you are working within that connector's known issues and limitations. 

Second, because of these issues and limitations I'd highly recommend that instead of using a spreadsheet, that you'd migrate this workload to a SharePoint list if possible. SharePoint has a far more complete API, has more than 10x the API call limits, and has no file lockout issues like Excel.

With that said, if you want to continue forward with Excel, you should add a Get Tables action (OneDrive) / Get Tables action (Business) before the add a row to a table step.

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE.

[itshouldwork · Accepted solution]

It seems to have been a bugg. As soon as I connected to the origianl Excel file downloaded from Microsoft Froms (instead of an own Excel file which I used for testing), it worked.

[DanielRap]

Hey! @itshouldwork Could you explain how you solved that in more detail? I also have the problem, that even with working connections and empty sheets, I can not connect anything to the action. Error message I get once I manually type in the table name is: The dynamic operation request to API 'excelonline' operation 'GetTable' failed with status code 'NotFound'. Attached you can find the error message I get. Does anyone has an idea?