Calculate data from Dataverse when two records match

[RavChop]

Hi, 

I'm trying to create a cloud flow that triggers once a day and performs a calculation when a date is reached in Table A 

Once the date is reached in Table A, then it should pull all records from Table B. From this table I then want to take all records where Column 1 and Column 2  Column 3 are the same and perform a few calculations, and create a record in Table C. 

Table B looks something like this 

Col 1	Col 2	Col 3	Col 4	Col 5	Col 6
Type A	Supplier A	Supplier B	DATE	1000	500
Type A	Supplier A	Supplier B	DATE	500	100
Type A	Supplier C	Supplier D	DATE	400	200
Type A	Supplier C	Supplier D	DATE	300	100
Type B	Supplier A	Supplier B	DATE	800	500
Type B	Supplier A	Supplier B	DATE	200	500

Table C should then look something like this 

Col 1	Col 2	Col 3	Col 4	Col 5	Col 6	Col 7
Type A	Supplier A	Supplier B	today	1500	600	col 6 * number from table A
Type A	Supplier C	Supplier D	today	700	300	col 6 * number from table A
Type B	Supplier A	Supplier B	today	1000	1000	col 6 * number from table A

Thanks in advance! 

[ManishJain · Accepted solution]

If you are doing complex calculation and dealing with thousands of records I suggest use Custom Action in CRM and invoke it from flow that way heavy lifting is taken care of and you get the output as well without flow being stuck.

Thanks