Flow Log (flowlog) table/entity reference

Article
08/31/2024

Messages

The following table lists the messages for the Flow Log (flowlog) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
`Create` Event: True	`POST` /flowlogs See Create	Create records
`CreateMultiple` Event: True	CreateMultiple	CreateMultipleRequest
`Delete` Event: True	`DELETE` /flowlogs(flowlogid) See Delete	Delete records
`DeleteMultiple` Event: True	DeleteMultiple	Learn to use messages with the SDK for .NET
`Retrieve` Event: True	`GET` /flowlogs(flowlogid) See Retrieve	Retrieve records
`RetrieveEntityChanges` Event: True		RetrieveEntityChangesRequest
`RetrieveMultiple` Event: True	`GET` /flowlogs See Query data	Query data
`Update` Event: True	`PATCH` /flowlogs(flowlogid) See Update	Update records
`UpdateMultiple` Event: True	UpdateMultiple	UpdateMultipleRequest
`Upsert` Event: True	`PATCH` /flowlogs(flowlogid) See Upsert a table row	UpsertRequest
`UpsertMultiple` Event: True	UpsertMultiple	UpsertMultipleRequest

Properties

The following table lists selected properties for the Flow Log (flowlog) table.

Property	Value
DisplayName	Flow Log
DisplayCollectionName	Flow Logs
SchemaName	`flowlog`
CollectionSchemaName	`flowlogs`
EntitySetName	`flowlogs`
LogicalName	`flowlog`
LogicalCollectionName	`flowlogs`
PrimaryIdAttribute	`flowlogid`
PrimaryNameAttribute	`name`
TableType	`Elastic`
OwnershipType	`None`

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

cloudflowid
cloudflowrunid
cloudflowrunidPId
data
desktopflowid
flowlogId
flowmachinegroupid
flowmachineid
flowsessionid
ImportSequenceNumber
level
Name
OverriddenCreatedOn
parentobjectid
parentobjectidIdType
PartitionId
TTLInSeconds
type
workqueueid
workqueueitemid

cloudflowid

Property	Value
Description	The Power Automate Cloud Flow Id this log is linked to.
DisplayName	Cloud Flow Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`cloudflowid`
RequiredLevel	None
Type	Lookup
Targets	workflow

cloudflowrunid

Property	Value
Description	The Power Automate Cloud Flow run this log is linked to.
DisplayName	Cloud Flow Run Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`cloudflowrunid`
RequiredLevel	None
Type	Lookup
Targets	flowrun

cloudflowrunidPId

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`cloudflowrunidpid`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

data

Property	Value
Description	The logged data.
DisplayName	Data
IsValidForForm	True
IsValidForRead	True
LogicalName	`data`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Json
ImeMode	Auto
IsLocalizable	False
MaxLength	100000

desktopflowid

Property	Value
Description	The Desktop Flow Id this log is linked to.
DisplayName	Desktop Flow Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`desktopflowid`
RequiredLevel	None
Type	Lookup
Targets	workflow

flowlogId

Property	Value
Description	Unique identifier for entity instances
DisplayName	Flow Log
IsValidForForm	False
IsValidForRead	True
LogicalName	`flowlogid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

flowmachinegroupid

Property	Value
Description
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`flowmachinegroupid`
RequiredLevel	None
Type	Lookup
Targets	flowmachinegroup

flowmachineid

Property	Value
Description
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	`flowmachineid`
RequiredLevel	None
Type	Lookup
Targets	flowmachine

flowsessionid

Property	Value
Description	The Power Automate Desktop Flow Session this log belongs to.
DisplayName	Flow Session Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`flowsessionid`
RequiredLevel	None
Type	Lookup
Targets	flowsession

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`importsequencenumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

level

Property	Value
Description	The level of the log.
DisplayName	Level
IsValidForForm	True
IsValidForRead	True
LogicalName	`level`
RequiredLevel	ApplicationRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`flowlog_level`

level Choices/Options

Value	Label
100000000	Verbose
100000001	Debug
100000002	Info
100000003	Warning
100000004	Error

Name

Property	Value
Description	The name of the log.
DisplayName	Log Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OverriddenCreatedOn

Property	Value
Description	Date and time that the record was migrated.
DisplayName	Record Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	`overriddencreatedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

parentobjectid

Property	Value
Description	The id of the parent object.
DisplayName	Parent Object Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`parentobjectid`
RequiredLevel	SystemRequired
Type	Lookup
Targets	flowsession, workqueue

parentobjectidIdType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`parentobjectididtype`
RequiredLevel	None
Type	EntityName

PartitionId

Property	Value
Description	Logical partition id. A logical partition consists of a set of records with same partition id.
DisplayName	Partition Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`partitionid`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

TTLInSeconds

Property	Value
Description	Time to live in seconds.
DisplayName	Time to live
IsValidForForm	True
IsValidForRead	True
LogicalName	`ttlinseconds`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	1

type

Property	Value
Description	The type of the log.
DisplayName	Type
IsValidForForm	True
IsValidForRead	True
LogicalName	`type`
RequiredLevel	ApplicationRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`flowlog_type`

type Choices/Options

Value	Label
100000000	CustomLog
100000001	DesktopFlowRunAction
100000002	DesktopFlowRunQueuePriorityChanged
100000003	DesktopFlowRunQueued
100000004	DesktopFlowRunQueueAssigned
100000005	DesktopFlowRunQueueAssignFailed
100000006	DesktopFlowRunQueueRunConfirmed
100000007	DesktopFlowRunQueueRunCompleted
100000100	DesktopFlowRunUnattendedRepairUISelectorRequest
100000101	DesktopFlowRunUnattendedRepairUISelectorResponse
100000200	WorkqueueFlowSession
100000201	WorkqueueProcessorLog
100000300	DesktopFlowOrchestrationRepairSessionMismatchRequest
100000301	DesktopFlowOrchestrationRepairSessionMismatchResponse

workqueueid

Property	Value
Description	The Work Queue this log is linked to.
DisplayName	Work Queue Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`workqueueid`
RequiredLevel	None
Type	Lookup
Targets	workqueue

workqueueitemid

Property	Value
Description	The Work Queue Item this log is linked to.
DisplayName	Work Queue Item Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`workqueueitemid`
RequiredLevel	None
Type	Lookup
Targets	workqueueitem

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

CreatedBy
CreatedOn
CreatedOnBehalfBy
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OwnerId
OwnerIdType
OwningBusinessUnit
OwningTeam
OwningUser
VersionNumber

CreatedBy

Property	Value
Description	Unique identifier of the user who created the record.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the record was created.
DisplayName	Created On
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the record.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedBy

Property	Value
Description	Unique identifier of the user who modified the record.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the record was modified.
DisplayName	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who modified the record.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

OwnerId

Property	Value
Description	Owner Id
DisplayName	Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	`ownerid`
RequiredLevel	SystemRequired
Type	Owner
Targets	systemuser, team

OwnerIdType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridtype`
RequiredLevel	SystemRequired
Type	EntityName

OwningBusinessUnit

Property	Value
Description	Unique identifier for the business unit that owns the record
DisplayName	Owning Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	`owningbusinessunit`
RequiredLevel	None
Type	Lookup
Targets

OwningTeam

Property	Value
Description	Unique identifier for the team that owns the record.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	`owningteam`
RequiredLevel	None
Type	Lookup
Targets

OwningUser

Property	Value
Description	Unique identifier for the user that owns the record.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	`owninguser`
RequiredLevel	None
Type	Lookup
Targets

VersionNumber

Property	Value
Description	Version Number
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`versionnumber`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

flowmachine_flowlog_flowmachineid
flowmachinegroup_flowlog_flowmachinegroupid
flowrun_flowlog_cloudflowrunid
flowsession_flowlog_flowsessionid
flowsession_flowlog_parentobjectid
lk_flowlog_createdby
lk_flowlog_createdonbehalfby
lk_flowlog_modifiedby
lk_flowlog_modifiedonbehalfby
workflow_flowlog_cloudflowid
workflow_flowlog_desktopflowid
workqueue_flowlog_parentobjectid
workqueue_flowlog_workqueueid
workqueueitem_flowlog_workqueueitemid

flowmachine_flowlog_flowmachineid

One-To-Many Relationship: flowmachine flowmachine_flowlog_flowmachineid

Property	Value
ReferencedEntity	`flowmachine`
ReferencedAttribute	`flowmachineid`
ReferencingAttribute	`flowmachineid`
ReferencingEntityNavigationPropertyName	`flowmachineid`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

flowmachinegroup_flowlog_flowmachinegroupid

One-To-Many Relationship: flowmachinegroup flowmachinegroup_flowlog_flowmachinegroupid

Property	Value
ReferencedEntity	`flowmachinegroup`
ReferencedAttribute	`flowmachinegroupid`
ReferencingAttribute	`flowmachinegroupid`
ReferencingEntityNavigationPropertyName	`flowmachinegroupid`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

flowrun_flowlog_cloudflowrunid

One-To-Many Relationship: flowrun flowrun_flowlog_cloudflowrunid

Property	Value
ReferencedEntity	`flowrun`
ReferencedAttribute	`flowrunid`
ReferencingAttribute	`cloudflowrunid`
ReferencingEntityNavigationPropertyName	`cloudflowrunid`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

flowsession_flowlog_flowsessionid

One-To-Many Relationship: flowsession flowsession_flowlog_flowsessionid

Property	Value
ReferencedEntity	`flowsession`
ReferencedAttribute	`flowsessionid`
ReferencingAttribute	`flowsessionid`
ReferencingEntityNavigationPropertyName	`flowsessionid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

flowsession_flowlog_parentobjectid

One-To-Many Relationship: flowsession flowsession_flowlog_parentobjectid

Property	Value
ReferencedEntity	`flowsession`
ReferencedAttribute	`flowsessionid`
ReferencingAttribute	`parentobjectid`
ReferencingEntityNavigationPropertyName	`parentobjectid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_flowlog_createdby

One-To-Many Relationship: systemuser lk_flowlog_createdby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdby`
ReferencingEntityNavigationPropertyName	`createdby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_flowlog_createdonbehalfby

One-To-Many Relationship: systemuser lk_flowlog_createdonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdonbehalfby`
ReferencingEntityNavigationPropertyName	`createdonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_flowlog_modifiedby

One-To-Many Relationship: systemuser lk_flowlog_modifiedby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedby`
ReferencingEntityNavigationPropertyName	`modifiedby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_flowlog_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_flowlog_modifiedonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedonbehalfby`
ReferencingEntityNavigationPropertyName	`modifiedonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

workflow_flowlog_cloudflowid

One-To-Many Relationship: workflow workflow_flowlog_cloudflowid

Property	Value
ReferencedEntity	`workflow`
ReferencedAttribute	`workflowid`
ReferencingAttribute	`cloudflowid`
ReferencingEntityNavigationPropertyName	`cloudflowid`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

workflow_flowlog_desktopflowid

One-To-Many Relationship: workflow workflow_flowlog_desktopflowid

Property	Value
ReferencedEntity	`workflow`
ReferencedAttribute	`workflowid`
ReferencingAttribute	`desktopflowid`
ReferencingEntityNavigationPropertyName	`desktopflowid`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

workqueue_flowlog_parentobjectid

One-To-Many Relationship: workqueue workqueue_flowlog_parentobjectid

Property	Value
ReferencedEntity	`workqueue`
ReferencedAttribute	`workqueueid`
ReferencingAttribute	`parentobjectid`
ReferencingEntityNavigationPropertyName	`parentobjectid_workqueue`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

workqueue_flowlog_workqueueid

One-To-Many Relationship: workqueue workqueue_flowlog_workqueueid

Property	Value
ReferencedEntity	`workqueue`
ReferencedAttribute	`workqueueid`
ReferencingAttribute	`workqueueid`
ReferencingEntityNavigationPropertyName	`workqueueid`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

workqueueitem_flowlog_workqueueitemid

One-To-Many Relationship: workqueueitem workqueueitem_flowlog_workqueueitemid

Property	Value
ReferencedEntity	`workqueueitem`
ReferencedAttribute	`workqueueitemid`
ReferencingAttribute	`workqueueitemid`
ReferencingEntityNavigationPropertyName	`workqueueitemid`
IsHierarchical
CascadeConfiguration	Archive: `RemoveLink` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

Share via