Row Added to the Bottom of a Table

UiPath.MicrosoftOffice365.Activities.Excel.Trigger.RowAddedToTableBottom

Description

Starts an automation when a row at the bottom of a table is filled in with appropriate columns as an optional data filter.

Note: It can take up to several minutes for the Microsoft API to register changes performed in an Excel file. This may lead to longer debug times for Excel activities and triggers, or to triggers not capturing events.

You must also be aware of when Excel files are updated. With Excel for Desktop, the database is updated when you click the Save button. With Excel Online, the database is updated when you close the Excel window.

Scopes

This activity requires the following scopes:

• Sites.Read.All

OR

• Sites.ReadWrite.All

Project compatibility

Windows | Cross-platform

Configuration

• Microsoft OneDrive & SharePoint connection - The connection for the Microsoft 365 account to use in the activity.
• Workbook - The workbook to use. This field supports IResource variables.
  • Reload browser - Select this option if you've updated your workbook and need to retrieve the latest data.
• Table - The name of the monitored table.

  • Select the Update Tables option if you've modified your workbook and need to retrieve the latest data.

Output

• Row - The row that was added to the table, saved as a DataRow variable. Automatically generated output variable. You can use it as it is or save it with a different name. You can use this in other activities.
• Table row number - The position of the added row. Automatically generated output variable. You can use it as it is or save it with a different name. You can use this in other activities.
• Workbook - Workbook name. Automatically generated output variable. You can use it as it is or save it with a different name. You can use this in other activities.

• Job Data - Contains job info, such as Process name, Process version, Workflow name, Robot name, and mode of execution.

Example

See also:

• Excel Online activities
• For Each Row in Workbook
• Read Range