Dynamics Community Forum Thread Details

Power Automate doesn't recognize Dataverse Modified Row Status change

I have several custom tables in Dynamics 365 Sales, and I want to set the value of a custom field called Inactive Date (cr239_inactivedate) to:

UTC(now) when the Status (statecode) of a Deal (new_deal) record is changed to Inactive (1)
NULL when the Status (statecode) of a Deal (new_deal) record is changed to Active (0)

The problem I run into is that Power Automate doesn't seem to recognize the modification to the record when that modification is made in the Editable Grid control by selecting the record row and clicking the Deactivate or Activate button—no trigger is recognized at all and there are no recorded runs of any type in Power Automate. I can get it to work when Status (statecode) is changed from the main form using the same buttons, but not from the Active or Inactive Deals Editable Grid.

I have switched to a Dynamics 365 Workflow, and it runs like a champ, no matter which interface I use, but I don't know how long internal Workflows will continue to be supported, so I need to figure this out using Power Automate.

Anyone have suggestions on why the same function (Deactivate or Activate) manifests differently in the different interfaces, and what I can do about it?

Categories:

Power Platform integration

Dynamics 365 general

Here's the code views of my Flow since the forum can't seem to successfully scan my screenshots for security. It all seems to be in order to me, and it is triggered on the change of the Status (statecode). No error messages, no record of anything ever happening including Tests that time out waiting for the trigger to be seen the first time.

It just seems like the Activate and Deactivate buttons in the View are not triggering a Save event the same way they do in the Form.

When a row is added, modified, or deleted (Trigger):

{
  "type": "OpenApiConnectionWebhook",
  "inputs": {
    "parameters": {
      "subscriptionRequest/message": 3,
      "subscriptionRequest/entityname": "new_deal",
      "subscriptionRequest/scope": 4,
      "subscriptionRequest/filteringattributes": "statecode"
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
      "connection": "shared_commondataserviceforapps",
      "operationId": "SubscribeWebhookTrigger"
    }
  },
  "conditions": [
    {
      "expression": "@greater(addSeconds(utcNow(), -10), triggerOutputs()?['body/cr239_inactivedate'])"
    }
  ],
  "runtimeConfiguration": {
    "concurrency": {
      "runs": 3
    }
  }
}
 
List Rows:
{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "entityName": "new_deals",
      "$filter": "new_dealid eq '@{triggerOutputs()?['body/new_dealid']}'"
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
      "connection": "shared_commondataserviceforapps",
      "operationId": "ListRecords"
    }
  },
  "runAfter": {}
} 
For Each:
{
  "type": "Foreach",
  "foreach": "@outputs('List_rows')?['body/value']",
  "actions": {
    "Condition": {
      "type": "If",
      "expression": {
        "and": [
          {
            "equals": [
              "@items('For_each')?['statecode']",
              1
            ]
          }
        ]
      },
      "actions": {
        "Current_time": {
          "type": "Expression",
          "kind": "CurrentTime",
          "inputs": {}
        },
        "Upsert_a_row": {
          "type": "OpenApiConnection",
          "inputs": {
            "parameters": {
              "entityName": "new_deals",
              "recordId": "@items('For_each')?['new_dealid']",
              "item/cr239_inactivedate": "@body('Current_time')"
            },
            "host": {
              "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
              "connection": "shared_commondataserviceforapps",
              "operationId": "UpdateRecord"
            }
          },
          "runAfter": {
            "Current_time": [
              "Succeeded"
            ]
          }
        }
      },
      "else": {
        "actions": {
          "Upsert_a_row_1": {
            "type": "OpenApiConnection",
            "inputs": {
              "parameters": {
                "entityName": "new_deals",
                "recordId": "@items('For_each')?['new_dealid']",
                "item/cr239_inactivedate": "@null"
              },
              "host": {
                "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
                "connection": "shared_commondataserviceforapps",
                "operationId": "UpdateRecord"
              }
            }
          }
        }
      }
    }
  },
  "runAfter": {
    "List_rows": [
      "Succeeded"
    ]
  },
  "runtimeConfiguration": {
    "concurrency": {
      "repetitions": 1
    }
  }
} 
Condition:
{
  "type": "If",
  "expression": {
    "and": [
      {
        "equals": [
          "@items('For_each')?['statecode']",
          1
        ]
      }
    ]
  },
  "actions": {
    "Current_time": {
      "type": "Expression",
      "kind": "CurrentTime",
      "inputs": {}
    },
    "Upsert_a_row": {
      "type": "OpenApiConnection",
      "inputs": {
        "parameters": {
          "entityName": "new_deals",
          "recordId": "@items('For_each')?['new_dealid']",
          "item/cr239_inactivedate": "@body('Current_time')"
        },
        "host": {
          "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
          "connection": "shared_commondataserviceforapps",
          "operationId": "UpdateRecord"
        }
      },
      "runAfter": {
        "Current_time": [
          "Succeeded"
        ]
      }
    }
  },
  "else": {
    "actions": {
      "Upsert_a_row_1": {
        "type": "OpenApiConnection",
        "inputs": {
          "parameters": {
            "entityName": "new_deals",
            "recordId": "@items('For_each')?['new_dealid']",
            "item/cr239_inactivedate": "@null"
          },
          "host": {
            "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
            "connection": "shared_commondataserviceforapps",
            "operationId": "UpdateRecord"
          }
        }
      }
    }
  }
} 
[IF TRUE]
Current time:
{
  "type": "Expression",
  "kind": "CurrentTime",
  "inputs": {}
} 
Upsert a row:
{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "entityName": "new_deals",
      "recordId": "@items('For_each')?['new_dealid']",
      "item/cr239_inactivedate": "@body('Current_time')"
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
      "connection": "shared_commondataserviceforapps",
      "operationId": "UpdateRecord"
    }
  },
  "runAfter": {
    "Current_time": [
      "Succeeded"
    ]
  }
} 
[IF FALSE]
Upsert a row 1:
{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "entityName": "new_deals",
      "recordId": "@items('For_each')?['new_dealid']",
      "item/cr239_inactivedate": "@null"
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
      "connection": "shared_commondataserviceforapps",
      "operationId": "UpdateRecord"
    }
  }
} 

Quick Links