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.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

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.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,856)