Power Platform Community Forum Thread Details

Hi all,

we are trying to create a table where we can combine all flow runs from multiple environments and use them in a PowerBi Dashboard or further evaluation.

Our approach is to use dataflows to get the needed data and transform it, unfortunately the FlowRun Table does not show in the query editor of dataverse.

This should be the case because it's an elastic table. I tried different approaches but did not manage to fetch the data of said table.

Anybody who has done that and has a power query for my dataflow or another approach which could lead to success?

Categories:

Building flows

The solution was to use the XRMToolbox Power Query (M) Builder Tool.

With that you will get the following code. The workflow column sometimes does not work as expected.

After deleting it from the query, you will be good to go.

let

    ServiceRootURL = "https://YOURENVR-HERE.crm4.dynamics.com" & "/api/data/v9.2",

    Source = OData.Feed(ServiceRootURL, null, [Implementation="2.0"]),

    entity_table = Source{[Name = "flowruns", Signature = "table"]}[Data],

    #"Removed Other Columns" = Table.SelectColumns(entity_table,{"conversationid","createdby","createdonbehalfby","createdon","duration","endtime","errorcode","errormessage","flowrunid","importsequencenumber","isprimary","modifiedby","modifiedonbehalfby","modifiedon","name","ownerid","owningbusinessunit","parentrunid","partitionid","modernflowtype","overriddencreatedon","resourceid","starttime","status","ttlinseconds","triggertype","workflowid"}),

    #"Renamed Columns" = Table.RenameColumns( #"Removed Other Columns",{{"conversationid","Conversation id"},{"createdby","Created By"},{"createdonbehalfby","Created By (Delegate)"},{"createdon","Created On"},{"duration","Duration"},{"endtime","End time"},{"errorcode","Error code"},{"errormessage","Error message"},{"flowrunid","flowrunid"},{"importsequencenumber","Import Sequence Number"},{"isprimary","IsPrimary"},{"modifiedby","Modified By"},{"modifiedonbehalfby","Modified By (Delegate)"},{"modifiedon","Modified On"},{"name","Name"},{"ownerid","Owner"},{"owningbusinessunit","Owning Business Unit"},{"parentrunid","Parent Run Id"},{"partitionid","Partition Id"},{"modernflowtype","Power Automate Cloud Flow Type"},{"overriddencreatedon","Record Created On"},{"resourceid","Resource Id"},{"starttime","Start time"},{"status","Status"},{"ttlinseconds","Time to live"},{"triggertype","TriggerType"},{"workflow","Workflow"},{"workflowid","Workflow Id"}})

in #"Renamed Columns"