How to set automation when excel file is created in Sharepoint folder to send out emails in the excel doc?

Question

[Moderator note: personal info removed] 

In PowerAutomate, I have a folder set in sharepoint where I have new excel documents being uploaded.
I want the workflow to look at the folder - Ready to Go

When a new file is uploaded into the folder, list the rows of the excel document, and send out an email to each of the emails inside of it.

It seems so simple to do, but I havent been able to get this to work.
When file is Created (Properties Only) -> I have a site address being the sharepoint folder, library name is Documents, and the folder is the Folder I have access to / want it to monitor

I set a delay because Copilot Recommended.

The get file metadata is to see what's being pulled from the File Created

List Rows Present should in theory grab the email in the uploaded excel document, but it can't cache anything, so I get a null.

Answer 1

Hi @COLAK, ALI, 

Welcome to the Microsoft Q&A forum.  

Thank you very much for sharing your experience regarding your Power Automate flow and the challenges you’re encountering when trying to read Excel files uploaded to a SharePoint folder. I truly appreciate you taking the time to provide such a detailed description of your setup. 

From what you’ve described, this behavior is commonly related to how Power Automate and the Excel Online (Business) connector handle newly uploaded files.  

When an Excel file is first uploaded to SharePoint, the file may appear in the folder immediately, but the system still needs a short amount of time to fully store, sync, and make the file’s internal structure available. During this period, Power Automate may be triggered before the Excel connector can reliably access the contents of the file. As a result, Excel-related actions may run too early and return no data. 

In addition, the “List rows present in a table” action has a strict requirement that the data inside the Excel file must be formatted as an Excel Table (using Insert > Table in Excel). If the data is only stored as regular cells or ranges, or if the table structure is not yet fully recognized at the time the flow runs, the action will not be able to locate any rows and may return null, even though the file itself exists in SharePoint. 

For additional information, you can refer to these articles: 

• Power Automate – Read table from any uploaded Excel in SharePoint 
• Power Automate: Office 365 Excel - List rows present in a table Action - Manuel T Gomes 

Please note that this information is being provided by the moderator solely for your convenience. The referenced sites are not managed or overseen by the moderator, and therefore we cannot guarantee the accuracy, security, or suitability of any software or content available there. We recommend reviewing all information carefully and ensuring you understand any associated risks before following suggestions from the provided link. 

In case you require more in-depth guidance or support for these steps, I’d recommend posting your query in the Microsoft Power Automate Community. This is a dedicated channel for Power Automate discussions. The reason I suggest posting a new topic there is that in the general Q&A Forum, resources and expertise on Power Automate are limited. In the Microsoft Power Platform Community Forum, you’ll find the most qualified group of respondents, and other partners who regularly read the forums can share their knowledge or learn from your interaction. 

I hope this information is helpful. Should you have any further questions or need additional assistance, feel free to reach out.    

Thank you again for your understanding and cooperation.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".  

Note: Follow the steps in our documentation to enable email notifications if you want to receive email notifications related to this topic.