Hi All,
I have a flow that will copy an Excel template file from a SharePoint folder to another SharePoint folder (for clarity, the file is actually an .xlsx file not an .xltm file). After copying the template, I fetch a SharePoint List item and update a data row in the new (copied) Excel file. Once that is complete, I add the new file to an array, add the SharePoint item attachments to the array and use the array as attachments to an email.
All of this works, however, I need to include a Delay between the Update Row action and the Get Content action that fetches the new file. If I don't add this delay, the new file content is that same as the original template.
So the flow looks like this,
As I say, this works, but I don't like a hardcode delay. Is there are way to force the new SharePoint file to update, or is there a way to know when it is ready? If neither, then how long is a safe delay for all cases?
Thanks for looking.
Kevin
