title: Power Automate to group fields by value
body: <p>I have the list as below:</p>
  <p>List 1:</p>
  <p>CustomerCode | CustomerName | ProductName | ProductCode | ManufactureDate | ExpiryDate | ProductPrice</p>
  <p>*CustomerCode and CustomerName can have duplicate values</p>
  <p>List 2:
  CustomerCode | AmountPurchased</p>
  <p>What I want to achieve:
  I want to automatically populate Sharepoint List 2 with Power automate.
  Condition:
  CustomerCode cannot be duplicated.
  I want to group List 1 by CustomerCode and add the AmountPurchased by the customer and fill in List 2.</p>
  <p>I am new to Power Automate. Your help and assistance is highly appreciated. Thanks !!</p>