Hello Community,
I am facing a persistent issue concerning the "Create Table" action in my Power Automate flow when working with an Excel file stored on OneDrive. My situation echoes a previous discussion from a few years back, albeit with a different storage location and a unique trigger.
Here's an outline of my flow:
- Trigger: When a file is created in a specified OneDrive path.
- Action: Create Table in Excel Online (Business)
- Location: OneDrive
- File: The newly created Excel file
- Table Name: Table1
- Worksheet Name: Sheet1
Despite ensuring that no table exists in the Excel file when it's moved to the OneDrive path, the flow encounters an "A table can't overlap another table Error 400" during the "Create Table" action. Oddly, a table does get created by the flow, which then errors out, indicating an overlapping table issue. It almost seems like the "Create Table" action might be triggering twice, although I only have a single "Create Table" action in my flow.
The previous case involved SharePoint and carried a minor variance where some random data appeared in the first column heading, which isn't the case in my scenario.
Is there a known issue, or has anyone encountered a similar issue and found a workaround? Alternatively, are there any additional steps or checks I could perform to troubleshoot this further?
Thank you in advance!
