web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / AccessDenied in "List ...
Power Automate
Suggested Answer

AccessDenied in "List Rows Present in a Table action" in power automate

(1) ShareShare
ReportReport
Posted on by HM-09031744-0 2
I am getting access denied error message on the "List Rows Present in a Table action".  I have verified, that:
 
all the chain leading to the file is has full control access permissions, including file, the parent folder, and Root
 
also, checked that the connection reference have the same user Id as the flow itself.
 
Has any body seen this bug?
AccessDenied.docx
Categories:
Using flows
I have the same question (0)
  • Suggested answer
    Sunil Kumar Pashikanti Profile Picture
    Sunil Kumar Pashikanti 2,318 Moderator on at
     
    AccessDenied in “List rows present in a table” almost always means the Excel file cannot be accessed by the connector, even if permissions “look correct.”
     
    Common causes:
    The Excel sheet is protected, and Graph API blocks the operation. Unprotecting the sheet or allowing AutoFilter often fixes it.
    The file is read‑only, locked, or opened by someone else. Ensure the file isn’t open and is fully editable.
    The connector connection is broken or doesn’t have access—even if it shows “Connected.” Re‑authenticate or rebuild the connection.
    File permissions are missing or inherited incorrectly. Confirm the account can manually open/edit the file in SharePoint/OneDrive.
     
    Most common fix:
    Unprotect the sheet (or allow AutoFilter), ensure the file is editable, and refresh your Excel connector connection.
     
     
    ✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
    👍 Feel free to Like the post if you found it useful.
  • Suggested answer
    11manish Profile Picture
    11manish 3,333 on at
    Yes, this is a fairly common issue with the Power Automate action “List rows present in a table” from the Excel Online (Business), and it’s usually not actually a permission problem, even though the error says AccessDenied.
     
    Troubleshooting 
    Check these in order:
    • File stored in SharePoint / OneDrive
    • Excel data is inside a Table
    • File not open in Excel desktop
    • Connection re-authenticated
    • File path reselected
    • Pagination enabled if large table

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans