Wiresk

Wiresk

Excel – Table Column & Table Row

Estimated reading time: 21 min

What your automation will do…

excel logo Background Removed Excel - Table Column & Table Row

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* List Column Within Table
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
[
  {
    "values": [
      {
        "Header0": 1
      },
      {
        "Header0": 2
      }
    ],
    "id": "6",
    "index": 0,
    "name": "Header0"
  },
  {
    "values": [
      {
        "Header1": 3
      },
      {
        "Header1": 4
      }
    ],
    "id": "1",
    "index": 1,
    "name": "Header1"
  },
  {
    "values": [
      {
        "Header2": 5
      },
      {
        "Header2": 6
      }
    ],
    "id": "2",
    "index": 2,
    "name": "Header2"
  },
  {
    "values": [
      {
        "Header3": 7
      },
      {
        "Header3": 8
      }
    ],
    "id": "3",
    "index": 3,
    "name": "Header3"
  },
  {
    "values": [
      {
        "Header4": 9
      },
      {
        "Header4": 10
      }
    ],
    "id": "7",
    "index": 4,
    "name": "Header4"
  }
]

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Insert New Column
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

Column Position

This determines where the new column will be inserted.

Each option represents the zero-based index of existing columns in the target Excel table.

If you choose:

  • 0 (Col 1) → the new column will be inserted before the first column.
  • 1 (Col 2) → inserted between Col 1 and Col 2.
  • 2 (Col 3) → inserted between Col 2 and Col 3.
  • 3 (Col 4) → inserted between Col 3 and Col 4.

If you omit this field, the new column will be added at the end of the table.

MAP FIELDS

Column Name

The display name for the new column.
Example: NewField

The name must be unique within the table.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookTableColumn",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/columns(%279%27)",
  "values": [
    [
      "last column4"
    ],
    [
      ""
    ],
    [
      ""
    ],
    [
      ""
    ]
  ],
  "id": "9",
  "index": 8,
  "name": "last column4"
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Update Column
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

Column ID*

Specify the column ID or Map it from Method step responses like “List Column Within Table“.

Column Name*

The new display name for the column. It must be unique within the table.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('idcrmltd.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables('%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D')/columns/$entity",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/columns(%275%27)",
  "values": [
    [
      "Update test"
    ],
    [
      ""
    ],
    [
      ""
    ],
    [
      ""
    ]
  ],
  "id": "5",
  "index": 0,
  "name": "Update test"
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Delete Column
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

Column ID*

Specify the ID of the column to delete or Map it from Method step responses like “List Column Within Table“.

Sample response 
{
  "message": "Column deleted successfully."
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Column Metadata
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

Column ID*

Specify the ID of the column or Map it from Method step responses like “List Column Within Table“.

MAP FIELDS

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('idcrmltd.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables('%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D')/columns/$entity",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/columns(%272%27)",
  "values": [
    {
      "Header2": 5
    },
    {
      "Header2": 6
    },
    {
      "Header2": 11
    }
  ],
  "id": "2",
  "index": 2,
  "name": "Header2"
}
Expand

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Item at
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

Column Position

The zero-based index of the column to retrieve.
Example:

  • 0 → first column
  • 1 → second column
  • 2 → third column
  • 3 → fourth column

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookTableColumn",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/columns(%271%27)",
  "values": [
    {
      "Header1": 3
    },
    {
      "Header1": 4
    },
    {
      "Header1": 7
    }
  ],
  "id": "1",
  "index": 1,
  "name": "Header1"
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Column Values
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

Column ID*

Specify the ID of the column or Map it from Method step responses like “List Column Within Table“.

MAP FIELDS

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/columns(%272%27)/range()",
  "address": "'Sheet test'!C15:C18",
  "addressLocal": "'Sheet test'!C15:C18",
  "columnCount": 1,
  "cellCount": 4,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "Header2": "General"
    },
    {
      "Header2": "General"
    },
    {
      "Header2": "General"
    }
  ],
  "columnIndex": 2,
  "text": [
    {
      "Header2": "5"
    },
    {
      "Header2": "6"
    },
    {
      "Header2": "11"
    }
  ],
  "formulas": [
    {
      "Header2": 5
    },
    {
      "Header2": 6
    },
    {
      "Header2": "=SUBTOTAL(109,C16:C17)"
    }
  ],
  "formulasLocal": [
    {
      "Header2": 5
    },
    {
      "Header2": 6
    },
    {
      "Header2": "=SUBTOTAL(109,C16:C17)"
    }
  ],
  "formulasR1C1": [
    {
      "Header2": 5
    },
    {
      "Header2": 6
    },
    {
      "Header2": "=SUBTOTAL(109,R[-2]C:R[-1]C)"
    }
  ],
  "hidden": false,
  "rowCount": 4,
  "rowIndex": 14,
  "valueTypes": [
    {
      "Header2": "Double"
    },
    {
      "Header2": "Double"
    },
    {
      "Header2": "Double"
    }
  ],
  "values": [
    {
      "Header2": 5
    },
    {
      "Header2": 6
    },
    {
      "Header2": 11
    }
  ]
}

Get Column Data Body (No header) Copy Link

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Column Data Body (No header)
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

Column ID*

Specify the ID of the column or Map it from Method step responses like “List Column Within Table“.

MAP FIELDS

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/columns(%272%27)/dataBodyRange()",
  "address": "'Sheet test'!C16:C17",
  "addressLocal": "'Sheet test'!C16:C17",
  "columnCount": 1,
  "cellCount": 2,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "Column2": "General"
    },
    {
      "Column2": "General"
    }
  ],
  "columnIndex": 2,
  "text": [
    {
      "Column2": "test2"
    },
    {
      "Column2": "test2-2"
    }
  ],
  "formulas": [
    {
      "Column2": "test2"
    },
    {
      "Column2": "test2-2"
    }
  ],
  "formulasLocal": [
    {
      "Column2": "test2"
    },
    {
      "Column2": "test2-2"
    }
  ],
  "formulasR1C1": [
    {
      "Column2": "test2"
    },
    {
      "Column2": "test2-2"
    }
  ],
  "hidden": false,
  "rowCount": 2,
  "rowIndex": 15,
  "valueTypes": [
    {
      "Column2": "String"
    },
    {
      "Column2": "String"
    }
  ],
  "values": [
    {
      "Column2": "test2"
    },
    {
      "Column2": "test2-2"
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Column Header
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

Column ID*

Specify the ID of the column or Map it from Method step responses like “List Column Within Table“.

MAP FIELDS

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/columns(%272%27)/headerRowRange()",
  "address": "'Sheet test'!C15",
  "addressLocal": "'Sheet test'!C15",
  "columnCount": 1,
  "cellCount": 1,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    [
      "General"
    ]
  ],
  "columnIndex": 2,
  "text": [
    [
      "Header2"
    ]
  ],
  "formulas": [
    [
      "Header2"
    ]
  ],
  "formulasLocal": [
    [
      "Header2"
    ]
  ],
  "formulasR1C1": [
    [
      "Header2"
    ]
  ],
  "hidden": false,
  "rowCount": 1,
  "rowIndex": 14,
  "valueTypes": [
    [
      "String"
    ]
  ],
  "values": [
    [
      "Header2"
    ]
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Column Header
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

Column ID*

Specify the ID of the column or Map it from Method step responses like “List Column Within Table“.

MAP FIELDS

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookRange",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/columns(%274%27)/totalRowRange()",
  "address": "'Sheet test'!F19",
  "addressLocal": "'Sheet test'!F19",
  "columnCount": 1,
  "cellCount": 1,
  "columnHidden": false,
  "rowHidden": false,
  "numberFormat": [
    {
      "Header5": "General"
    }
  ],
  "columnIndex": 5,
  "text": [
    {
      "Header5": "3"
    }
  ],
  "formulas": [
    {
      "Header5": "=SUM([Header1])"
    }
  ],
  "formulasLocal": [
    {
      "Header5": "=SUM([Header1])"
    }
  ],
  "formulasR1C1": [
    {
      "Header5": "=SUM([Header1])"
    }
  ],
  "hidden": false,
  "rowCount": 1,
  "rowIndex": 18,
  "valueTypes": [
    {
      "Header5": "Double"
    }
  ],
  "values": [
    {
      "Header5": 3
    }
  ]
}
excel logo Background Removed Excel - Table Column & Table Row

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* List Row Within Table
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
[
  {
    "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/rows/itemAt(index=0)",
    "index": 0,
    "values": [
      {
        "Header0": 1,
        "Header1": 3,
        "Header2": 5,
        "Header3": 7,
        "Header4": 9,
        "last column": ""
      }
    ]
  },
  {
    "@odata.id": "/sites('idcrmltd.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/rows/itemAt(index=1)",
    "index": 1,
    "values": [
      {
        "Header0": 2,
        "Header1": 4,
        "Header2": 6,
        "Header3": 8,
        "Header4": 10,
        "last column": ""
      }
    ]
  }
]

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Insert New Row
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

Row Position

Defines where to insert the new row inside the table.
Example: Row 1:1

  • If the position is 1, the new row is inserted at the top of the table.
  • If omitted, the row is added at the bottom by default.

Data*

The actual cell values that will fill each column in the new row.
Each field corresponds to one column header in the table.

Example setup:

HeaderValue
Header0value1
Header1value2
Header2value3
Header3value4

These mapped fields define the cell values for the new row being inserted.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookTableRow",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/rows/add()",
  "index": 3,
  "values": [
    {
      "Header0": 1,
      "Header1": 2,
      "Header2": 3,
      "Header3": 4,
      "Header4": 5,
      "last column": 6
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Insert New Row
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

Row Position

Defines where to insert the new rows inside the table.
Example: Row 1:1

  • If the position is 1, the new rows are inserted at the top of the table.
  • If omitted, the rows are added at the bottom by default.

Data*

The actual cell values that will fill each column in the new row.
Each field corresponds to one column header in the table.

+Element +Map ↓
(Add a repeating group of fields or Map it from an array. See Field Mapping).

Element 1: Represents the first row to be added.

Example setup:

HeaderValue
Header0value1
Header1value2
Header2value3
Header3value4

These mapped fields define the cell values for the new row being inserted.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('idcrmltd.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables('%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D')/rows/$entity",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/rows(null)",
  "index": 2,
  "values": [
    {
      "Header0": "value1",
      "Header1": "value2",
      "Header2": "value3",
      "Header3": "value4",
      "Header4": "value5",
      "last column": "value6"
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Update Row
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

Row Position*

Defines which row to update.

Example:

  • Row 1 updates the first data row.
  • Row 3 updates the third data row.

Data*

The new cell values that will fill each column.
Each field corresponds to one column header in the table.

If a column value is left blank, the corresponding cell remains unchanged.

Example setup:

HeaderValue
Header0value1
Header1value2
Header2value3
Header3value4

You can use static text, mapped data from another app, or dynamic values retrieved from a Trigger or previous Method.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookTableRow",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/rows/itemAt(index=0)",
  "index": 0,
  "values": [
    {
      "Header0": "updated1",
      "Header1": "updated2",
      "Header2": "updated3",
      "Header3": "updated4",
      "Header4": "updated5",
      "last column": "updated6"
    }
  ]
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Delete Row
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

Row Position*

Defines the exact position of the row to be deleted.

Example:

  • Row 1 removes the first data row.
  • Row 3 removes the third data row.
Sample response 
{
  "message": "Row deleted successfully."
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Row
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

Row Position*

The target row to retrieve.
Example: Row 1: sample1

  • The position is based on the order of data rows in the table (not the header).
  • Wiresk displays positions as 1-based (Row 1, Row 2, etc.), while the API uses 0-based indexing.
  • This can also be dynamically mapped from a previous step (e.g., from a search result).

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookTableRow",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/rows/itemAt(index=0)",
  "index": 0,
  "values": {
    "Header0": "sample1",
    "Header1": "sample 2",
    "Header2": "sample 3",
    "Header3": "sample 4",
    "Header4": "sample 5",
    "last column": "sample 5"
  }
}

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature (⚡ icon).

(*) required field

Name* Get Row Range
Connection* Select your connection or create one.

MATCHING CRITERIA

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file).

Wiresk lists available workbooks once a valid Site ID is provided.

Or Map it ID from Method step responses like “Search Workbook“.

Table ID*

Choose the table you want to inspect.

Wiresk lists available tables once a valid Workbook ID is provided.

Or Map it ID from Method step responses like “List Tables“.

MAP FIELDS

Row Position*

The target row to retrieve.
Example: Row 1: sample1

  • The position is based on the order of data rows in the table (not the header).
  • Wiresk displays positions as 1-based (Row 1, Row 2, etc.), while the API uses 0-based indexing.
  • This can also be dynamically mapped from a previous step (e.g., from a search result).

If not Found consider as

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the Flow.

Failed – Wiresk treats this as an error or failure. The Flow stops or takes a predefined failure action.

Sample response 
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.workbookTableRow",
  "@odata.id": "/sites('example.sharepoint.com%2Cfa09d5a1-3e00-412e-a0ad-a27483af1032%2C0157a23a-b2ff-459c-8115-fc34faf27787')/drive/items('01NMYE6H3IJOTHDMW5K5BIPO6WGO5PNYHD')/workbook/tables(%27%7B3105AE85-B2DC-4946-8E1E-DEAF0CC0F7A6%7D%27)/rows/itemAt(index=0)",
  "index": 0,
  "values": {
    "Header0": "sample1",
    "Header1": "sample 2",
    "Header2": "sample 3",
    "Header3": "sample 4",
    "Header4": "sample 5",
    "last column": "sample 5"
  }
}

Once your Flow is configured, you can test or automate it using the Run panel or by managing Triggers from the Flow Management screen.

  • Run Flow: Manually runs the Flow once using sample data. Ideal for testing logic and field mapping. See How to Run a Flow.
  • Run Scheduler: Force-runs the Trigger immediately using live input. This bypasses the recurrence rule and is useful for verifying real data mapping. Learn more in Wiresk Scheduler – The Fundamentals.

From the Trigger management panel (clock icon), you can:

  • Activate or deactivate Triggers
  • Force-run the scheduler
  • Copy Routing Keys (for HTTP Triggers)

If your Flow uses a Webhook Trigger, it runs automatically on each incoming webhook—no scheduler required. It remains active until you manually deactivate it.

Important 01 Excel - Table Column & Table Row

Going further Copy Link

See related Microsoft apps.

Explore the full Wiresk User Guide to learn more.

Looking for an integration that’s not yet available? Submit a request to our team, we’ll do our best to support your needs.