Fix the trigger – Microsoft.OData.ODataException in Power Automate / Dataverse

If you encountered the error "Microsoft.OData.ODataException: A binary operator with incompatible types was detected. Found operand types 'Edm.Guid' and 'Edm.String' for operator kind 'Equal'," while creating a Power Automate trigger using Dataverse, don't worry. This article by Nishant Rana explains how to fix the trigger using a simple solution.

The error occurs when there's an incompatibility between the types of the operands being used in the binary operator. In this case, the comparison operator being used is the "Equal" operator between a GUID and a string. To fix the issue, the author suggests converting the string into a GUID format using the "api.guid" function in Power Automate. The article provides a step-by-step guide to help you replace the string value in the trigger with the GUID format using the "api.guid" function and resolve the error.

If you're facing this error while creating a Power Automate trigger, this article is a must-read. The solution provided by the author is straightforward, and following the steps will ensure that your trigger functions properly.

Link to the article: https://nishantrana.me/2024/04/30/fix-the-trigger-microsoft-odata-odataexception-a-binary-operator-with-incompatible-types-was-detected-found-operand-types-edm-guid-and-edm-string-for-operator-kind-equal-power-automat/