cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Dual Super User II
Dual Super User II

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

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
Dual Super User II
Dual Super User II

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

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

Thanks that worked for me!

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.

 

"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
News & Announcements

Community Blog

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

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (7,676)