cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

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!

View solution in original post

Highlighted
Community Support
Community Support

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

5 REPLIES 5
Highlighted
Dual Super User III
Dual Super User III

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!

View solution in original post

Highlighted
Community Support
Community Support

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

Highlighted

Thanks that worked for me!

Highlighted
New Member

The issue is because of Sharepoint Site and Excel user access rights issue. So please follow provide necessary access to the user.

 

1. Select the excel you are trying to use in Flow.

2. Then click on more options> Details> Manage Access and then provide user permissions and Site permission as per your requirement.

 

Highlighted

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

In scenarios where the table is uploaded by a user, Is there a way to dynamically select the following information in the power automate action?

  • file
  • first table available in a file

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,854)