Hi all,
I need some assistance with creating a flow. I have 2 Lists. When a new item is created in List A , I want to create a new record in List B for each of the customers ( Unique ) using the information from List A .. but then add the customer Name retrieved from List B.
See below example.
List A
Job1 £10
Job2 £20
Job3 £30
List B
Customer A - Job1 - £10
Customer A - Job2 - £20
Customer A - Job3 - £30
Customer B - Job1 - £10
Customer B - Job2 - £20
Customer B - Job3 - £30
New item created in List A
Job1 £10
Job2 £20
Job3 £30
Job4 £40 - NEW ITEM CREATED
List B
Get all list of all unique customers and create new record for each of them using details from List A and Customer Name from List B
List B
Customer A - Job1 - £10
Customer A - Job2 - £20
Customer A - Job3 - £30
Customer A - Job4 - £40 - Create new Item
Customer B - Job1 - £10
Customer B - Job2 - £20
Customer B - Job3 - £30
Customer B - Job4 - £40 - Create new Item
The reason for the two lists is that the jobs are standard and available to all customers but they sometimes have their own agreed rates so I want the flexibility that if we have a new service ( job ) we can create in the master , which then goes ahead and creates in the second list for each of the customers. We can then adjust rates per customer as required.. just want to avoid having to create the job manually for each customer in list B.
I have had varied success, its the creation where I keep failing.
501
