Create Session - BlinkOps Documentation

Create a new session to maintain context across multiple Excel operations, improving performance and allowing better control over when changes are saved. Least privileged Microsoft Graph permissions to access the action via application: Files.ReadWrite. Note: Using the delegated (OAuth) connection type will only allow to insert the connected user’s ID.

External DocumentationTo learn more, visit the Microsoft Excel documentation.

Parameters

Parameter	Description
Drive ID	The unique identifier of the drive (OneDrive or SharePoint document library) that contains your Excel file.
Item ID	The ID of the Excel file to interact with.
Persist Changes	When checked, all changes made during the session will be permanently saved to the Excel file. When disabled, changes are temporary and lost when the session ends.
Site ID	The ID of the SharePoint site containing your Excel file.
Source	Choose whether to pull your Excel file from SharePoint or OneDrive.
User ID	The User ID of the user whose OneDrive contains the Excel file. Note: Using the delegated (OAuth) connection type will only allow to insert the connected user’s ID.

Example Output

{
	"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.sessionInfo",
	"id": "{session-id}",
	"persistChanges": true
}

Workflow Library Example

Create Session with Microsoft Excel and Send Results Via Email

Preview this Workflow on desktop

​Parameters

​Example Output

​Workflow Library Example

Parameters

Example Output

Workflow Library Example