PREVIEW

Get Cell Color

Uses the Microsoft Graph Get range format API to retrieve the color properties of specified cells (CellAddress) in a workbook (Workbook) worksheet (SheetName). After retrieving the color properties, the activity returns the cell color (Color) as a hex value (e.g., # FFFFFF).

Scopes

• Files.Read

• Files.ReadWrite

• Files.Read.All

• Files.ReadWrite.All

• Sites.Read.All

• Sites.ReadWrite.All

• Microsoft OneDrive & SharePoint - The connection for the Microsoft 365 account to use in the activity.
• Workbook - The Drive Item of the Excel document from which data is read.
• Workbook sample - Select a file with the same ranges as the variable file. This field becomes visible when you select Use workbook template.
• Sheet Name - The name of the sheet from which data is read. This property supports String variables and string formatted values.
• Cell address - The address of the cell. Enter the address of a single cell in A1-style notation. This property does not support a range of cells (e.g., "A1:A5"). This property supports String variables and string formatted values.
• Color - The color of the given cell, in HEX format. Required if you plan to use the output data in subsequent activities.

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 the Get Cell Color activity inside the Microsoft Office 365 Scope activity.
5. Enter values for the Input properties.
6. Create and enter a String variable for the Output property.
7. Run the activity.
   • Your input property values are sent to the GetRangeFormat API.
   • The API returns the String value to your output property variable.