Productivity activities

Description​

Project compatibility​

Configuration​

• Microsoft OneDrive & SharePoint connection - The connection for the Microsoft 365 account to use in the activity.
• Workbook - The workbook where the cell is update. The method to specify the folder to be retrieved: Folder picker, Enter Id, Enter Url, Relative path.

  • Workbook sample - The workbook template to use. The field is visible after clicking Use workbook template. Browse the OneDrive folders and select a workbook. In Studio Desktop, the option is available from the See more button menu next to Range type. To learn more, see Working with templates.

  • File/Folder picker option: Click the Folder icon to browse the OneDrive or SharePoint files/folders and select a spreadsheet. This option accepts input as IResource.

    • Use the See more button menu to use a variable or select the Reload Folder Data option if you've modified your folders and need to retrieve the latest data.

  • Enter Id option:

    • Workbook Id - The ID of the workbook of interest. This field supports String type input.
    • SharePoint site address - The URL of the SharePoint site that contains the file or folder. This field supports String type input.Open your SharePoint site in a browser and copy its URL, e.g., https://yourcompany.sharepoint.com/sites/ProductOfficial.
    • SharePoint document library - The document library within the indicated SharePoint site that contains the file or folder. This field supports String type input. Open the Documents tab in your SharePoint site and copy the URL, e.g., https://yourcompany.sharepoint.com/sites/ProductOfficial/Shared%20Documents/Forms/AllItems.aspx.

  • Enter Url option:

    • Workbook Url - The URL of the workbook of interest. This field supports String type input. Retrieve the URL by opening the file in a browser.

  • Relative path option:

    • Relative folder path - Specify what is the relative path to the parent folder. This field supports String type input.
• Sheet - The monitored sheet name. This field supports String type input.
• Cell address - The monitored cell address. This field supports String type input.
• Additional filters - Configure additional criteria to check on the updated cell.

• Workbook - The workbook where the cell is updated.
• Cell - Information about the updated cell.
• Job Data - Contains job info, such as Process name, Process version, Workflow name, Robot name, and mode of execution.