Element 2: In the second lookup, we use the Pricebook Entry from the Id stored in the variable collected at the start and grab the Pricebook Id and store it in a variable.

Element 3: Using the Id stored in a variable from the start, Fast Lookup the Group Line Items from the Product Group record to create a collection variable. This step stores the Product ID, the Quantity and Price from each Group Line Item record related to the Product Group.

Element 4: This is the loop that cycles through the Group Line Item collection variable and assigns Opportunity Line Item records to a SObject variable.

Element 5: This record lookup grabs the specific Pricebook Entry Id for each Line Item comparing the Product ID from the Group Line Item in the collection and the Pricebook ID stored from Step One.

Element 6: Now we build the Opportunity Line Items by assigning the fields identified in the Variable Collection for the Opportunity Line Item with Variables collected in the prior steps. This sets the Pricebook Entry ID from Element 5, Quantity and Price from Element 3 and the Opportunity ID from the beginning of the Flow.

Element 7: This step assigns the records created in the prior step to a new SObject Collection Variable.

Element 8: This step creates the Opportunity Line Item records using the SObject Collection Variable from Step Seven.

The second custom object is named Group Line Items. These records contain the information necessary to create the Opportunity Line Items from the Flow: Quantity, Price, and a lookup to the Product.

Here we can see the Group Line Items related to the Product Group Record.

The last part of the set up is creating a Product record that has a lookup to the Product Group record. This is how we provide the user with a way to add the Product Group to the Opportunity and set the Pricebook information that is used in the Flow.

The user selects the Product that represents the desired group.

The user edits the products

Note: We’re leaving the price at $0 because the Product Group Line Items dictate the Price and Quantity for each individual item in the Group. You can configure it the opposite way where the Group Line Item records have no price and the Product that represents the group has the Price. Also the Quantity here will affect the quantity of the line items added. If you put two of this product, each line item quantity will double. Since this is a 2 Diesel product group there are two Diesel Generators in the group. If a user selects this Product and changes the Quantity to 2, then 4 Diesel Generators will be added to the Opportunity.

After the user clicks Save on the Edit Products Screen – BAM! The magic happens. Each item from the Product Group was added to the Opportunity by the Flow as detailed in the Group Line Items.