Build Flow with dynamic data

[tusharmehta]

Hello Everyone, 

Greetings, 

I am working with inventory applications and came across to few doubts.

If any suggestions please post as a reply I will be grateful for the same.   

Process: 

• When new products are submitted data must be stored into SharePoint lists. 
• First list is Product Master
• Second list is Product Details 
• Product Master will store (Table 1 data) 
• And the Second list is Product details (Table 2), Table 2 values generated from table 1 value Qty, Price dynamic values.
• Each product will be generated with a Unique SKU.  

Table 1

Inputs
Product Code	Product Category	Product Description	Product Qty	Pcs Wise Price	Total Amount
PROOD0001	Stationery & Papers	A4 Size Paper Box	5	100	500

Table 2:

Details (Created Automatically)
Product Code	SKU Create Automatically	Product Qty	Pcs Wise Price	Total Amount
PROOD0001	PRD001	1	100	100
PROOD0001	PRD002	1	100	100
PROOD0001	PRD003	1	100	100
PROOD0001	PRD004	1	100	100
PROOD0001	PRD005	1	100	100

[tusharmehta]

Any Suggestions ?

[v-bofeng-msft · Accepted solution]

Hi @tusharmehta :
I've made a test for your reference:

1\My Lists:

2\My Flow:

The Result:

Best Regards,

Bof

[tusharmehta]

Apricate the time spent building flow and perform testing.  

I will create flow at my end let you know if any queries. 

[v-bofeng-msft]

Hi @tusharmehta :

Is the problem solved?What can I do for you?

Best Regards,

Bof