Hello,
A few months ago, I created a flow which adds and removes rows to an Excel list based on a Power BI report. When this flow adds rows to this Excel file, it also generates and adds a unique identifies with the format Day/Month/Year_City_Sum (For Example, 1/26/2023_Timbuktu_21 ). When it deletes the row, it first retrieves the current Excel sheet, and filters it so that it only deletes rows which are no longer in the Power BI report. While this flow has worked well, I started to get errors on the "Delete a Row" Excel action a couple weeks ago.
This error was: BadRequest - "The argument is invalid or missing or has an incorrect format."
In my experience, this error occurs when Power Automate tries to delete a row that isn't on the Excel list, but I checked the Excel list an the row that it's trying to delete is there. What makes this even stranger is that this error doesn't happen consistently. I can have one day where that row is successfully deleted, while on other days, I'll get the BadRequest error.
Does anyone know what might cause this error? It is caused by Power Automate not finding the row in Excel, or could something else cause this BadRequest error?
Any help with this issue would be greatly appreciated.
2
ErrorMessage.png
Share
Report
All responses (
Answers (
