Hi All,
I built a Power Automate Desktop Flow which, among other things, opens an Excel template file on a SharePoint, writes a data table into the Excel template, saves the file with a different file name and then closes Excel. When running the flow in attended mode on my PC everything is fine and the Excel template file remains unchanged, just as it should be, because the Excel file with the data table is saved with a different file name so that the Excel template file on the SharePoint is not changed/overwritten.
Now comes the strange part: When running the very same flow on a virtual machine in unattended mode (scheduled execution), the Excel file with the data table is also saved with a different file name but at the same time it overwrites the original Excel template file on the SharePoint. So it does both - creates a new file but also overwrites the Excel template file.
I cannot figure out why it does that in unattended mode, because, as mentioned before, the flow is identical to the one that I execute in attended mode on my PC. Has anyone experienced similar behavior and can suggest a solution to this issue?
Many thanks in advance.
