Research: Power Automate comments are stored in Dataverse
Out of curiosity, and because I think listing outstanding comments might be a product feature in Flow Studio, I did some research, experimenting with REST query and general exploring on a late Friday night. This was done on Twitter, a bunch of people chipped in but also we ended up with pictures all over the place. This blog post is to collect everything in one place as a reference.
The record is stored as a top level Container (with an artifactid)
Then top level records (kind=Threads) with Container(commentid = containerid)
Then records (kind=Reply)
We can query Dataverse to get the rows back. Here’s how to do it in one request.
We can query Dataverse comments from WITHIN the flow about the current flow (via workflow().name expression)
I think this fulfills some sort of inception criteria
This also qualifies this research to be #FlowNinja hack 125
Here is a Reply record.
Comments are tied to an Anchor - which is an action within the Flow.
The corresponding Flow has metadata.operationMetadataId created as a reference when this happens.
Comments can be resolved (state =1, Resolved) or deleted (statuscode = 2, Inactive).
I expect the same data structure design will be suitable for other Power Platform products, so I’m keen to see it.