Handling complex expressions can be challenging, especially since there is no out-of-the-box (OOB) UI available to manage them effectively. For scenarios where complex expressions need to be implemented and might require frequent changes, I recommend using the Roll-up Query UI.

Why use Roll-up Query?

• Configuration Made Simple: The Roll-up Query UI allows you to configure complex expressions without custom coding or Power Automate.
• Fetch XML Saved in Dataverse: Microsoft stores the Fetch XML for each expression directly in Dataverse. This means you don’t have to create your own Fetch XML manually.
• Dynamic Data Validation: You can use the saved Fetch XML, pass IDs dynamically, and validate your data efficiently.

This is a highly effective solution compared to hardcoding conditions in your code or Power Automate. It simplifies the process and improves maintainability.

Let me know if you need further details or assistance with implementation.

Thanks!