Get file content and sending it as email attachment is not sending the complete data rows

[JenVitug]

the flow inserts rows into an excel file.  after which, this file needs to be attached to an email.

1. Get file metadata, 2. Get file content   3. send email w/ attachment.  successful email sends the excel file as attachment but some rows are missing.  Why is this happening ?  It is sending the old rows prior to the insertion of the rows in the current run (for example, prior to running, there are 4 rows, then this current run inserts 2 rows, the file attached contains the old 4 rows, not including the 2 new rows).

here's screenshot of the flow.

[fchopo · Accepted solution]

Hello @JenVitug 

Could you add a "delay" step before getting the file content of about 30 seconds? Probably you have to wait a little bit before getting the updated contents.

Hope it helps!

Ferran

[JenVitug]

@fchopo   i'll try that and see if it works 🙂 🐶

[v-litu-msft · Accepted solution]

Hi @JenVitug,

I agree with @fchopo, the reason of the issue most likely due to the Excel file just inserted two rows hasn't updated in SharePoint, so you should add a delay action between insert rows action and Get file content action to wait for the file has time to update.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.