I have been creating flows in Power Automate Desktop for over a year. Despite some knowledge of the actions in PAD and how to troubleshoot issues, I'm completely stumped by the following situation.
I have a flow that creates two folders on our server for each file in an origination folder. The flow is supposed to copy each file from that origination folder to the associated two newly created folders. It's completely hit or miss as to whether the copying happens and I have yet to have it happen for both of the newly created folders for a file. To troubleshoot the issue, I have tried a number of different things. First, I wondered if there needs to be some delay between the act of creating the folders and the act of copying of the file to those folders. So, instead of copying the file right after (with a WAIT action in between) creating the new folders, I wrote the new folder locations to an excel spreadsheet and then I read the spreadsheet to identify those folder locations and try to copy the file to the read folder locations. That didn't help. I then simplified the process by only including a single file in the origination folder. I recreated a portion of the flow into a new PAD flow and set the two newly created folder locations on the server as variables in that new PAD flow. The new PAD flow runs perfectly. All the variable values are correct and this should work, but it doesn't. I am completely stumped.
The first image below is the flow where I read from the excel spreadsheet. The second image is the new PAD flow where I set the folder locations as variables. NOTE: The newly created folder locations CANNOT be statically set. These locations are determined for each file.
The flow for testing the above with the variables statically set.
