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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,753)