Use Dataverse Elastic Tables in Power Automate Cloud Flows
In this blog post, I will guide you through overcoming common challenges encountered during CRUD operations on elastic tables in Dataverse using Power Automate cloud flow. While I was working with cloud flow run history in Dataverse , I experienced an unusual issue. In my cloud flow, I use a "List Rows" action to retrieve the data from Flow Run table (which is using Dataverse’s nonrelational database, elastic tables). The query returned the columns as specified in the documentation . flowruns(«GUID») However, when I used the GUID of the flow run to populate the lookup column in the custom table, I encountered the following error. The HTTP status code of the response was not expected (404). "error": { "message": "Could not find item '25b17f77-3abb-9596-5cd3-9275652c7f01'.", "details": [ { "message": "\r\nErrors : [\r\n &
