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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,934)