Identify all the cloudflows and on particular entity along with its messages

The easiest way to identify the flows that trigger on a particular entity with its messages is to run a SQL query using the sql4cds tool in the xrmtoolbox.

The table that has the information is callback registration, querying the call back registration table provides information about the modern flow/ cloud flow guid.
We can then join it with workflow table to retrieve all the valid information.

SELECT 
    CR.entityname,
    CR.messagename,
    WF.name AS workflow_name
FROM 
    workflow AS WF
INNER JOIN 
    callbackregistration AS CR ON WF.workflowid = CR.name
GROUP BY 
     CR.entityname,CR.messagename,WF.name
ORDER BY 
    CR.entityname,CR.messagename;

CR.entityname: Represents the name of the entity from the callbackregistration table.

  • CR.messagename: Represents the name of the message from the callbackregistration table.

  • WF.name AS workflow_name: Represents the name of the workflow from the workflow

    It joins the workflow table (aliased as WF) with the callbackregistration table (aliased as CR) using the condition WF.workflowid = CR.name. This condition ensures that records are matched based on the equality of the workflowid column in the workflow table and the name column in the callbackregistration table.

    Then Groups the results based on the columns we need/specify and orders the results.