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!
Solved! Go to 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
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
69 | |
22 | |
16 | |
16 | |
11 |
User | Count |
---|---|
125 | |
37 | |
32 | |
30 | |
27 |