Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

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

(1) ShareShare
ReportReport
Posted on by 118

DVOP_0-1680132362505.png

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?

 

  • DevOs Profile Picture
    DevOs 118 on at
    Re: Create a table column in dataverse that holds the sum of other fields?

    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.

  • DevOs Profile Picture
    DevOs 118 on at
    Re: Create a table column in dataverse that holds the sum of other fields?

    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.

  • 365-Assist Profile Picture
    365-Assist 2,305 on at
    Re: Create a table column in dataverse that holds the sum of other fields?

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

  • DevOs Profile Picture
    DevOs 118 on at
    Re: Create a table column in dataverse that holds the sum of other fields?

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

  • 365-Assist Profile Picture
    365-Assist 2,305 on at
    Re: Create a table column in dataverse that holds the sum of other fields?

    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

  • DevOs Profile Picture
    DevOs 118 on at
    Re: Create a table column in dataverse that holds the sum of other fields?

    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 .

  • 365-Assist Profile Picture
    365-Assist 2,305 on at
    Re: Create a table column in dataverse that holds the sum of other fields?

    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. 

     

    365Assist_1-1680142809005.png

    365Assist_2-1680142978807.png

    ---------------------------------------------------
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics