Power Automate

Get File Content action is Sending Empty Data Excel File from SharePoint stored file

(0) Share

Report

Posted on by VM-30071814-0

Hi Community,

I have a Power Automate flow that:

Collects responses from a Microsoft Form.
Adds the form data into a SharePoint-hosted Excel file (Table1).
Uses Get file content to fetch the updated Excel file.
Sends the file as an attachment via Send an email (V2).
After sending, a script deletes the row that was just added.

Complete Flow Sample :-

Within above flow the Get File Content Action is as -

Within above flow the Send Email action is as -

The flow runs successfully without any errors. However, the Excel file I receive in the email is completely blank—no data at all. This issue started on Sunday. Until last Friday, the same flow was working perfectly and the Excel file had the correct data.

in addition, the below One Drive file has data stored but still it is sending attached excel with Blank Row.

Has anyone else experienced this issue recently? Could this be due to a change in how Excel files are cached or locked in SharePoint? Or is there a delay in writing data that I need to account for?

Any insights or suggestions would be greatly appreciated!

Thanks in advance!

Categories:

Using flows

GMI Password Rese...

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

venturemavenwill 1,189 Super User 2025 Season 2 on at

Like (1)

Report

This is a common issue - when you write rows into Excel, there is a delay due to caching before the data is commited to the document. Since the flow runs the next action right after the previous one, the data hasn't been commited to the worksheet yet.

You have two options

1. Introduce a delay action in your flow, and wait 30 seconds before you send out the email.

2. Write an office script to refresh all data in all the tables in the worksheet, and trigger the office script using the Flow before you move onto the next step.

Hope this helps

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (1)

Report

@VM-30071814-0 Hi,

You mentioned that even the file contains data, you still got empty excel file ?

Can you add List rows present in a table and Compose the length before get file content ?

It will narrow down the debug scope.

If you do get the length =0, consider add do until step, use list rows, and length, until the length >0, continue other steps.

If you always get length >0, then something may happen between get file content and send email, need further analysis.

Was this reply helpful? Yes No