Unanswered

Create a table column in dataverse that holds the sum of other fields?

(1) Share

Report

Posted on by DevOs

118

Hello, I am trying to create a table in dataverse to later use in Powerapps, that will hold the value "install time" for products in the CRM. When a work order is created, there are a list of items used for it and I'd like to have a sum of all the "install time".

Does anyone know how to go about this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (0)

365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!

You could create a Table that relates to the table with individual Install Times (i.e. Header to Lines). In the header table add a number column with Rollup Behaviour.

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365

Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
DevOs 118 on at

Like (0)

Report
Copy link

Link copied!

Hi 365-Assist,

I'm a little confused, I don't want a sum of number of items, I want to pull field "install time" from each product attached to a work order and then have a sum of that. Items have their own install times already in the CRM, I just want a sum of those times on the work order sheets is all. Not the order header.

So if I have "Work Order 123" and it has
Sprinkler 60
Camera 0.30
Cupcakes 0.16

I just want a field then on the work orders that gives me total time of those things that were used in the work order. In this case 60.46 would be the total time it takes to do all those things. I'm a noob so maybe I don't follow you exactly .

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!

I guess Header was just an example. So long as you have a Dataverse relationship (One to Many) from one table to another you can still use the Rollup.

So in your example you could create a one-to-many relationship between Orders and Products and put the Rollup column (on Install Times) in the Order table.

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365

Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
DevOs 118 on at

Like (0)

Report
Copy link

Link copied!

And I do this in the dataverse? Not the CRM? Will that cause problems anywhere else?

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yeah you can do this in Dataverse. You are just adding columns so shouldn't cause any issues to existing work.

Was this reply helpful? Yes No
DevOs 118 on at

Like (0)

Report
Copy link

Link copied!

Just wanted to update and say I could never figure this out, seems I'm missing something or just don't know enough to do it.

Was this reply helpful? Yes No
DevOs 118 on at

Like (0)

Report
Copy link

Link copied!

Just wanted to update and say I could never figure this out, seems I'm missing something or just don't know enough to do it.

Was this reply helpful? Yes No