We can use invoke an HTTP request to get the Dataverse Id of a record via an OData query, e.g. for the cm_outdooractivities table find the record where cm_sqlid eq 1 cm_sqlid is actually defined as an alternate key so we can also use: Retrieve the id via the below in the compose action:

Here are some useful applications of Power Automate’s Azure Devops Work Item actions. For ones where you use the find example HTTP body requests for other tasks here: https://learn.microsoft.com/en-us/rest/api/azure/devops/wit/work-items/update?view=azure-devops-rest-7.1&tabs=HTTP#examples 1 Create a work item and set custom fields A Work item can be created as below, to set custom fields you can add the Other…

This post builds on this blog which talks about using the SQL CDS tool to search for Power Automate Flows that modify a specific Dataverse column In this post we look at interrogating the Power Automate Flow definitions to investigate bugs/changes, and also accessing the Flow’s cliendata property in scenarios were organizations don’t allow you…

To locate a flow run when investigating a failed process you need to navigate to this page and keep clicking the button at the bottom of the page to show more records until you find the time that you want. In the situation that you know what day/time that the process failed roughly this can…

📚 Common Resources & URLs Tool/Resource URL Power Platform Admin Center https://admin.powerplatform.microsoft.com Microsoft Learn – Power Platform https://learn.microsoft.com/power-platform Dynamics 365 Docs https://learn.microsoft.com/dynamics365 Dataverse Table Reference https://learn.microsoft.com/power-apps/maker/data-platform/reference Power Automate Docs https://learn.microsoft.com/power-automate Power FX Reference https://learn.microsoft.com/power-platform/power-fx/reference Power CAT Samples https://github.com/microsoft/PowerCATCodeSamples ⚙️ Power Automate – Key Actions Action Type Common Use Example Expression Get label as text from…