cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RavChop
Frequent Visitor

Calculate data from Dataverse when two records match

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 1Col 2Col 3Col 4Col 5Col 6
Type ASupplier ASupplier BDATE 1000500
Type ASupplier ASupplier BDATE 500100
Type ASupplier CSupplier DDATE400200
Type ASupplier CSupplier DDATE300

100

Type BSupplier ASupplier BDATE800

500

Type BSupplier ASupplier BDATE200

500

 

Table C should then look something like this 

Col 1Col 2Col 3Col 4 Col 5 Col 6Col 7
Type ASupplier ASupplier Btoday1500600col 6 * number from table A
Type ASupplier CSupplier Dtoday700300col 6 * number from table A
Type BSupplier ASupplier Btoday10001000col 6 * number from table A

 

Thanks in advance! 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ManishJain
Solution Sage
Solution Sage

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

View solution in original post

1 REPLY 1
ManishJain
Solution Sage
Solution Sage

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

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,685)