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 Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,949)