Good Afternoon and Happy Friday!
Recently, I created a Power Automate Web Flow that automates the following steps:
- When a user completes a Microsoft Form, the input is saved in an Excel document in my OneDrive for Business Account.
- The final step of the Power Automate Web Flow is to initiate a Power Automate Desktop Flow that takes the information saved in step 1 and uses browser automation to create a user account for our web-based LMS.
- The Power Automate Desktop Flow starts by providing me (in attended mode) a message asking if they want to automate the account's creation or stop the bot.
Everything works like a charm.
However, recently (this week), the first step has been working without issues. Nevertheless, when the Power Automate Desktop Flow is triggered, it fails if the OneDrive file (the Excel workbook) isn't finished Syncing. The file size is only 14 KB, so there's no reason why the file wouldn't be finished Syncing. I'm on 1 Gbps Up and Down Fiber. It's designed to replace row 1 (Row 0 contains the headers) whenever users submit their information from the Microsoft Form from Step 1. So, when it isn't appropriately synced, it accidentally presents the prior user's data instead of the new user's data from the Microsoft Form.
Can I create a logical check to ensure that the Excel File in my OneDrive for Business is properly synced before the Power Automate Desktop Flow runs? With that same idea in mind, I should be able to create an "IF" statement that would stop the Flow from running if the file isn't synced.
Has anyone else experienced this issue?
