Skip to content
DAN Analytics

05 · Power Apps · Dataverse

Field service app

Hours and materials hit the project days later.

Complete a work order. Hours and materials land on the same project.

Demo on fictional data — never customer data.

This is an interface, not a photo of a phone. Completing it writes hours and materials back to the project.

Daan Bakker

  1. 1. Not started
  2. 2. Hours
  3. 3. YMvK cable 5×2.5
  4. 4. Signature

    No signature yet

Complete the order to update the project. The signature is a text mark, not a photo.

SQL
UPDATE project
SET actual_cost = actual_cost + :hours * :rate + :qty * :price,
    actual_hours = actual_hours + :hours
WHERE project_id = :project_id;

Curious what this could do for your business?