Append Range

Scopes

• Files.ReadWrite

• Files.ReadWrite.All

• Sites.ReadWrite.All

Common

• DisplayName - The display name of the activity. This property supports String variables and string formatted values.

Input

• DataTable - The table to insert. To get the DataTable variable, create a table using the Build Data Table or Generate Data Table) activity and use its output property variable. If the sheet specified in the Sheet Name exists, the DataTable is added to the last row/column of cells that contain data.
• Sheet Name - The name of the sheet to which the data is appended. If the name you enter in this property does not match a sheet name in the specified Workbook, a new sheet is created.
• Workbook - The DriveItem of the document to modify. This object can be retrieved using the Find Files And Folders activity. Use the output property variable from either the Find Files and Folders (First or Results) or Create Workbook (Workbook) activities. When using the Results output property from the Find Files and Folders activity, be sure to specify which item in the array that you want to use (e.g., myWorkbooks(0)).

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.

1. Complete the steps.
2. Add the Microsoft Office 365 Scope activity to your project.
3. Add an activity or run an external process that outputs a DriveItem object (e.g., Find Files and Folders, Create Workbook, Copy Item).
4. Add an activity that outputs a DataTable object (e.g., Build Data Table, Generate Data Table).
5. Add the Append Range activity inside the Microsoft Office 365 Scope activity.
6. Enter values for the Input properties.

7. Run the activity.

   • Your input property values are sent to the UpdateRange API.