Let me start off my saying that I am brand new to this platform. I need to build a flow which will ultimately set 3 values on the Opportunity form based off of the sum of Opportunity Product line items - by Product Type.
So, for example, lets say that an Opportunity has 5 product line items, each product lookup has a Type set:
Oppty Line Item | Product Type (product table) | Amount |
Network Security | SERVICE | $100 |
Web App Design | SERVICE | $150 |
Office E3 | LICENSE | $10 |
Dynamics 365 | LICENSE | $75 |
External SATA SSD | HARDWARE | $50 |
There are 3 custom fields on the Oppty:
- Service Amount
- License Amount
- Hardware Amount
The system should ultimately update (on create or update of the Opportunity Product entries), as follows:
- Service Amount: $250
- License Amount: $85
- Hardware Amount: $50
I constructed the flow below, and it is erroring at the list step: "The $filter expression must evaluate to a single boolean value."
{
"status": 400,
"message": "The $filter expression must evaluate to a single boolean value.",
"error": {
"message": "The $filter expression must evaluate to a single boolean value."
},
"source": {org},
"errors": [],
"debugInfo": "clientRequestId: 375e6d60-6150-46eb-a651-96f10093e756"
}
It is retrieving the correct Opportunity GUID.
Using PA, I cannot seem to understand how to have the system perform this calc by looking at the OLI's product type value. Here is what I started with (attached)
