Power Platform Community Forum Thread Details

Hello,

I’m encountering an issue when working with Power Automate to add rows to an Excel table stored in OneDrive for Business.
Here is the scenario:

Trigger: "When a file is modified (properties only)".
Action: "Get file content".
Action: "Add a row into a table" (the table in Excel is named DataTable).

Upon saving the flow, I receive the following error: Received an internal server error from Azure Resource Manager.
Tracking Code: "2a8c0b29-4704-47d5-9231-78ce7ab2beb9".

Steps to Reproduce:

Create a flow in Power Automate.
Use a file stored in OneDrive for Business.
Add a table DataTable with predefined columns (e.g., Product Description, CPU, Brand, etc.).
Use the action "Add a row into a table" and provide all required parameters.
Upon saving the flow, the error occurs.

Expected Behavior:

The flow should save successfully and add rows to the specified table in the Excel file.

What I Have Already Tried:

Reconnected the Excel Online (Business) connector.
Restarted Power Automate and refreshed the flow.
Verified the Excel file for errors and ensured the table DataTable is correctly formatted.
Created a new Excel file with an identical table structure, but the issue persists.

Additional Information:

File Location: OneDrive for Business > File Path: /Agent1/Pivot 23 (dt aio barebone ws)_17112024.xlsx
Table Name: DataTable
Error Tracking Code: "2a8c0b29-4704-47d5-9231-78ce7ab2beb9"

Request:

Kindly assist in resolving this issue or provide guidance on its possible cause. Could this be related to an issue on the Azure Resource Manager side?

Categories:

Building flows