Sharepoint file not updating after succesful flow, unless opened online

Question

Hello,

I know that this horse may have been already beaten to death, however I was not able to find anyone with an exact same issue.

I have built a flow that is supposed to trigger when specific e-mail with an attachment lands into my inbox. Said attachment (an *.xlsx file) should then overwrite an already existing Excel file in a specific Sharepoint library, say Master file or whatnot.

All is working fine up until that point.

The next step would be to create a table in a specified range within newly updated master file (A2:R50). For that purpose, the flow in it's whole looks something like this:

The problem is that, although flow runs successfully, the table fails to be created unless I open master file in Excel online. Performing any other operation on said file clearly shows, that the table has not been created (further flows, Power Query). Opening it in Excel app confirms no table exists within the file.

However, navigating to file directory through Sharepoint online and opening it in web version of Excel, magically updates the data and presents it in table format.

Any suggestions would be deeply appreciated.

Answer 1

Adding a slight delay solved the issue, thanks.

Answer 2

Hi @Jarosław Zabłotowicz ,

I test the flow in my SharePoint Online, it run successfully. Without opening the newly created excel file in the browser, I see the table has been created in the excel file from Details.

You could go to Details to check whether the table has been created.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.