Hi there community,
As a result of my flow I get an overwritten Excel file, which I save on my desktop with a new name, and want to send via email as an attached file with the same flow.
The flows goes as planned, but I am not able to send this newly created Excel via email (Outlook), as I get "file not found" error in a final "send by email" step.
PAD asks me to provide a specific file path. However, this new file is being generated during the flow, so there's now way to indicate it before completion of the flow.
I tried to put the path of the original Excel and change the file name with a new name variable, but it gets lost. Interestingly, this is how I save the Excel file during the flow: I show the path and edit the final file name with a variable.
I also tried with entering new Excel variable, but then it says it must be a path to the file.
I checked whether Outlook can send any file, and there are not problems, so it's a PAD issue.
To sum up, it's a philosophical paradox of how to indicate a file's path before the flow, when said file is being created only during this flow:D
Many thanks in advance for any ideas!

Report
All responses (
Answers (