I've set up a Power Automate flow that uses two separate Excel files:
- The first file contains all the source data, in table form (several lines).
- The second file is a report template containing specific formatting for a single line of data.
Here's what the flow does:
For each line in the source file, the stream updates the table line in the report template with the new data.
It then makes a copy of the updated report file with One Drive Enterprise's Get File Content, which it adds to an array variable (intended to contain the files to be sent).
Once all the lines have been processed, the flow sends an e-mail with all the reports generated attached.
The problem:
The Excel is not up to date when it is copied, even if you add a 2-minute wait between iterations, as if One Drive keeps a copy in memory when the first action is taken on the Excel.
Knowing that I can neither create nor delete files and that I must use OneDrive, is there a solution to force the update?
that will either fix it and also make sure you have delays between any actions that interact with the files, it may take more than 1 since I cannot see the flow and everything its doing atm.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
