Excel New Row Node

The Excel New Row node allows automation of inserting a new row of data into a specific worksheet of an Excel file stored in SharePoint Online. This task is executed using Microsoft Graph API via a registered Microsoft 365 service account.

---

🧠 Purpose

Use this node when you need to programmatically add new rows of data to an existing Excel workbook located on SharePoint. It is useful for scenarios such as appending form data, logging task output, or updating tracking sheets.

---

⚙️ Required Inputs

Label	Type	Description
Sharepoint Path to File	Text	Full SharePoint-relative path to the target Excel file (e.g. /sites/mySite/Documents/myFile.xlsx).
Worksheet Name	Text	The exact name of the worksheet (tab) within the Excel file.
Row Values to insert	JSON	A JSON array of string values representing the row to insert. Example: ["Value1", "Value2", "Value3"]

---

🔐 Service Account Requirements

This task requires a Microsoft 365 service account with appropriate permissions to access the SharePoint document library and modify Excel files using Microsoft Graph.

The service account must be linked via the ThirdParty-Microsoft configuration.

---

✅ Output

• On success, the specified worksheet will have a new row appended with the provided values.
• On failure, the task will return an appropriate error message detailing what went wrong (e.g., file not found, worksheet not accessible, or input validation failure).

---

🧪 Validation

The task performs the following validations before execution:

• Verifies presence and correctness of all required inputs.
• Confirms that the SharePoint path is valid and can be parsed into site/document library/folder path.
• Validates that the Excel file and worksheet exist.
• Ensures that Row Values to insert is a non-empty array of strings.

---

🗂 Data Cleanup

After execution, the following inputs are removed from the taskParameters.data object to avoid unintended downstream use:

• Sharepoint Path to File
• Worksheet Name

---

📝 Notes

• The row is appended to the bottom of the worksheet.
• Column alignment is based on the order of values in the provided array — ensure consistency with the structure of your worksheet.
• This task does not create the Excel file or worksheet if they do not already exist.

---

🚫 Common Errors

Error Message	Cause
Sharepoint Folder not found	The provided SharePoint path was invalid or improperly formatted.
File name not found	The file portion of the path was not identified.
Row Values to insert not found	The input key was missing or contained an empty list.
Failed to get Sharepoint locations	SharePoint parsing failed due to an invalid path or token issues.
Failed to Execute: -	An unexpected runtime exception occurred.

---