Fail to list Excel Online tables retrieving values

View products that this article applies to.

Symptoms

Creating an Excel trigger flow using, for example, the "request approval for a selected row" template, browsing to the workbook in OneDrive works but the template does not list the tables in the excel file, but gives an API error "could not retrieve values, error executing the API".

↑ Back to the top

Cause

This error may occur due to OneDrive IP permissions.

↑ Back to the top

Resolution

To resolve this issue:

Check permissions in OneDrive
Make sure to use OneDrive connector for OneDrive and OneDrive for Business connector for OneDrive for Business
If permission error is received while running the flow, change IP restrictions in OneDrive
Move the file to another group folder
If unable to run the flow but table picker works, create the flow from scratch and try running it again.

See the following for more information:

Control access based on network location or app

Power Automate - Limits and Configs, IP Address Configuration

OneDrive for Business Connector

OneDrive Connector

See related article:

Unable to Find Excel Online Table in Microsoft Flow

↑ Back to the top