Update Excel & Copy File for PDF

[KD99]

I am using Update a row with Excel Connector.

Then I am copying the file to Onedrive to create PDF of the updated document.

However, when I make a copy it shows old information instead of updated data in previous step.

Does Excel update feature not support dynamic changes during Flow Execution?

Is there a work-around to resolve the issue?

I need to update Excel document to create PDF to attach in multiple Approval process.

I have create pseudo-table to use Key to update Template Values in Excel documents.

If above method does not work, is there a way to replace certain values in Excel Template I prepopulated to obtain updated values?

Thank you.

[v-litu-msft · Accepted solution]

Hi @KD99,

After you update the Excel, you should add a delay to wait for the file update in the OneDrive, such as 1 minute.

Then use the Get file content action to get file content again to get the last version.

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.