Power Platform Community Forum Thread Details

One of my colleagues has written a Power Automate script that populates an excel spreadsheet with some website URL's. At the end, it calls Power Automate Desktop to visit the URL's and download data, populating the same spreadsheet. We then have PAD import the spreadsheet to our task management system. So far so good.... at the end, we want to open the spreadsheet in PAD and delete the data, leaving an empty table, ready to be populated by Power Automate (web) next time it runs. The issue we have is that Poer Automate seems to be holding open the Excel file when it initially populates it, when PAD comes to delete the rows in the file it cant then sync the file and I get a OneDrive error. Is there something I can put in Power Automate Web to close the excel file before calling the Power Automate desktop script? BTW, I know it would have been easier to pass a data table from Web to Desktop rather than using an Excel file but they have built it this way, it works and its their first time using Power Automate so I dont really want to rip it all up and start passing tables between Web and Desktop unless it cant be helped!

Categories:

General topics