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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Error when using "List...
Power Automate
Suggested Answer

Error when using "List rows present in a table" after new file trigger in Power Automate

(1) ShareShare
ReportReport
Posted on by 12

Hello everyone!

I currently have a Power Automate flow that works as follows: I trigger it manually, it reads data from a table inside an Excel file stored in SharePoint, and sends emails based on the columns NAME, DUE DATE, and EMAIL.

Now, I want to automate this process. The idea is that when a new Excel file is created in a SharePoint folder, the flow should be triggered automatically, read the data from the table, and send the emails.

The Excel file always follows the same format and already contains a properly formatted table.

The issue is: when I use the trigger "When a file is created (properties only)" and then try to use the action "List rows present in a table," the flow fails. It seems the file is not fully ready for processing at that point.

Does anyone know a reliable way to ensure Power Automate can access the table inside a newly created Excel file triggered via SharePoint?

Categories:
I have the same question (0)
  • Suggested answer
    MMcCloud Profile Picture
    393 Moderator on at
    Good Morning,
     
    Not 100% on this but, I think what you may be running into is when you are creating this if I am reading correctly, you are 
     
    1. Waiting for a file to be dropped (When a file is created action)
    2. It matches the schema of your other Excel files for this folder. So you go to grab it with "List Rows Present in a Table" action
    3. Send emails based off a said condition
     
    Your issue is between 1 and 2 so let's look to alleviate that.

    Try this first:
    I would add a delay of like 30 seconds to start and see if that has any impact, I am assuming it won't.
     
    After this try:
     
    1. Keep this action where you it is. When a file is created (Properties Only) action.
    2. Add a small delay just in case 10 to 30 seconds
    3. Select the same site collection and library with the "Get Tables" action for the file though put the ID dynamic value from step 1 our trigger.
    4. Then from "Get Tables" action perform your row evaluation.

    All its really doing is removing you pre-assigning your value you could also go into the ellipses for your action of "Get Tables" and do Settings -> Retry Policy if the delay is hit or miss needed.

    If you still need assistance, feel free to follow up. Have a good day!
  • w.p Profile Picture
    8,345 Super User 2026 Season 1 on at
    Where do you store the Excel file?  
    Can you share screenshots of the flow run output?

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 784

#2
Valantis Profile Picture

Valantis 581

#3
Haque Profile Picture

Haque 545

Last 30 days Overall leaderboard