Power Platform Community Forum Thread Details

Hello all,

I have a bit of a conundrum and not sure how to go about it.

The situation:

This is a canvas app for calculating pay based off of work orders. Right now as you can see, there are date fields a name field and and hourly rate field. "Tech1" will be paid an hourly wage that is called from the "Hourly rate" field in the CRM and uses the "duration"(Time worked) field on work orders. This is the default setup.

------------------------------------------------------------------------------------------------------------------------------------------------

What I am trying to do:

I wish for to add a second Tech type, "Tech2"(Highlighted in the new red dropdown box I've created) and have it so that when selected, it changes the name field to the immediate right to only include bookable resources of the type "Tech2". Which will in turn not calculate the pay based off an hourly wage, but instead on the "install time" of *all* products used in a work order. Some product swill have install times of 0.15 minutes, others of 60 minutes, etc.

------------------------------------------------------------------------------------------------------------------------------------------------

What I am thinking:

Create a table in dataverse on the work order form and call it "Sum Install Time" and set that table to be a sum of product install times?(I don't even know if this is possible). Then go back to the PowerApp, create a new subheader called "Product Install Time" and set it to get data from that table in the dataverse/new section on the work orders.