Hi everyone,
Looking for a solution to my issue. I am using a combination of Power Automate (web) and Power Automate Desktop to help me convert documents using a python script. I've managed to get a solution to the premium lock, however I am not in a predicament and wondering if anyone has a better solution.
1st Flow Power Automate (web)
Uses a Power App to submit attachments to a sharepoint list. Uses a sharepoint list trigger to start the flow. As part of this flow it creates the files on my onedrive for business account. I also use a create file function to add a .txt file to a specific folder which is used to trigger Power Automate Desktop.
2nd Flow Power Automate Desktop
As mentioned above the .txt starts the flow (I have used an infinite loop to ensure the PAD runs continually and waits for this file to be created). This then runs a python script (using a .bat file) and then converts the files moved onto my onedrive in the 1st flow to a different file format. At this stage it transfers them to a new folder and deletes the .txt file which is used to start the flow.
It also creates another .txt file which is used to trigger the 3rd flow.
3rd Flow Power Automate (web)
The .txt file is used to trigger this flow. It then transfers the converted files for the 2nd flow, and puts them into a sharepoint location for the original user who submitted the form to access their newly converted files.
My problem is currently at the 3rd Flow. Whilst the .txt file is used to trigger, it also doesnt take as long to sync this file. This means that it starts the flow but there are no files to upload to the sharepoint (seeing as they have not been synced in time).
Is there a way I can adjust this process to ensure that the files get picked up everytime? The only solution I can think of is to create a delay, whether at the beginning of the 3rd flow or at the end of the second flow.
Any help greatly appreciated!
