cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mccardj
Level: Powered On

List Rows Present in a Table Microsoft Flow

Hi all,

 

I'm trying to create a Flow where when selecting a PowerApps buttons, the "List Rows Present in a Table" action starts, but I'm unable to select the "Table" due to the following api error. 

"Could not retrieve values. Error executing the api"

excelerror.PNG

 

I'm using SharePoint site (which I'm an owner of) as the source but the same issue appears if I change it to my OneDrive for Business account.

 

The Excel file has a data connection to several SharePoint lists if that helps.

 

Any help would be much appreciated.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: List Rows Present in a Table Microsoft Flow

Hi @mccardj ,

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:5.JPG

Please check if you have formatted the data in your Excel file as a Table already.

 

There are some known limits within Excel Online (Business) connector, please check the following article:

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#known-issues-and-limitations

 

Please consider re-create a new connection to the Excel Online (Business) connector within your flow, then try your flow again, check if the issue is fixed.

 

Also please consider go to the "List Rows Present in a Table" action in your flow, change the value within the Location field from "SharePoint Site - Strategic Pursuits" to "Group - Strategic Pursuits", then try your flow again, check if the issue is solved.

 

You could also consider provide your Flow Run URL, then we could track where the issue occurs.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Dual Super User
Dual Super User

Re: List Rows Present in a Table Microsoft Flow

Hi @mccardj 

 

Can you confirm that you are selecting the excel file by clicking the folder icon and then selecting the excel file from the list that appears? If not, please note that currently dynamic mapping of excel files for the excel connector is not supported in flow and that could be areason no tables are showing up as the appropriate excel file is not pointed to. 

 

Can you check if the data in the excel that you are trying to connect to is formatted as a table? 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Community Support Team
Community Support Team

Re: List Rows Present in a Table Microsoft Flow

Hi @mccardj ,

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:5.JPG

Please check if you have formatted the data in your Excel file as a Table already.

 

There are some known limits within Excel Online (Business) connector, please check the following article:

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#known-issues-and-limitations

 

Please consider re-create a new connection to the Excel Online (Business) connector within your flow, then try your flow again, check if the issue is fixed.

 

Also please consider go to the "List Rows Present in a Table" action in your flow, change the value within the Location field from "SharePoint Site - Strategic Pursuits" to "Group - Strategic Pursuits", then try your flow again, check if the issue is solved.

 

You could also consider provide your Flow Run URL, then we could track where the issue occurs.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

mccardj
Level: Powered On

Re: List Rows Present in a Table Microsoft Flow

Thanks that worked for me!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,095)