Bad Request Error in "List rows present in a table"

(1) Share

Report

Posted on by LE-09050954-0

I have a Power Automate flow that is triggered when an Excel bulk file is uploaded via Forms and placed in a SharePoint Document Library. This setup worked correctly when I initially designed and tested the flow using my personal account.

However, after copying the flow to our organization’s shared Power Automate account and updating the connections to link to other SharePoint lists and libraries, I am now encountering a "Bad Request" error on the "List rows present in a table" action. I have checked and adjusted the connections and settings, but the issue persists.

I would appreciate your assistance in identifying the cause and providing a solution.

This is the flow and error:

This is the actoin List rows present in a table

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

David_MA 14,499 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Based on how you have the List rows present in a table action, I don't understand why it is in the Apply to each 1 action. Move it outside of the apply to each and see if that resolves the error.

You may also want to blackout your site URL for data privacy reasons. There is no need for anyone to know the URL of your tenant. It may seem rather innocuous, but I am pretty sure I can figure out where you work and are located just from that piece of information.

Was this reply helpful? Yes No
Suggested answer

LE-09050954-0 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your suggestion. I tried moving the List rows present in a table action outside of the Apply to each 1 loop, but I received the following error message:

From what I understand, this is likely due to the use of the dynamic content Full Path in File. Let me know if there's a recommended workaround for handling this. As mentioned, the flow worked perfectly fine when I tested it using my personal account.

Was this reply helpful? Yes No
stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LE-09050954-0 Hi,

If you can manually choose the file rather than assign it with variable , will that work ?

Was this reply helpful? Yes No
LE-09050954-0 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the suggestion! Unfortunately, manually selecting a file isn’t an option in this case, as the flow is triggered by a new Excel file being uploaded. The file path is therefore dynamic and needs to be retrieved automatically from the trigger or from the “Get files” action. That’s why I’m using the dynamic content “FullPath”. But I suspect the issue might be related to the dynamic content I'm using?

Was this reply helpful? Yes No
David_MA 14,499 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
I don't think I will be able to help you with this, but let me see if I understand your process:

Your trigger, when a file is created, is related to the spreadsheet where you need to get the rows?

If yes, what is the purpose of the Get files action since the trigger is the Excel spreadsheet you need to work with?

If no, I don't understand your process as you've explained it. The path isn't dynamic since it comes from the trigger action and is thus known.

If the trigger is the Excel file you need to list the rows from, then I would suggest this:

First, you need to add some logic to make sure that the file that is created is a spreadsheet. What prevents this flow from triggering on any other type of file created?

Then once you've validated that the new file is an Excel spreadsheet, I would use the list tables to get the tables in the spreadsheet.

You can then use the data from this action to list the rows in the table(s).

I think what you want to do is shown in this post: List rows present in a table action; how to define tables when - Microsoft Community

Was this reply helpful? Yes No