Skip to content
pwbitPublic

About

Open-source project management for Microsoft Dataverse: projects, WBS, Gantt, time & expense tracking, purchasing and a supplier portal, built as a Power Apps model-driven app with PCF controls and Power Pages.

Topics

Resources

Contributing

Security policy

Stars

2 stars

Watchers

0 watching

Forks

Repository files navigation

ProjectIQ

Formerly Open Project 365.

License: Apache 2.0

ProjectIQ is a project and job management solution for companies that work on orders, built as a Power Apps model-driven app on Microsoft Dataverse. It follows every job from the offer to the closing: work breakdown structure and budget, Gantt planning with critical path and baselines, team and resource load, weekly timesheets with approval, materials, purchasing (requests, RFQs, orders, goods receipts, supplier invoices) and a supplier portal on Power Pages. Every figure — budget, actual cost, committed cost, progress, estimate at completion and margin — is updated in real time on the project.

  • Single-tenant: one Dataverse environment per customer company; data is never shared between companies.
  • Licences: Power Apps Premium for internal users; suppliers use the Power Pages portal.
  • Publisher prefix op365; base language English (1033), translations Italian (1040), French (1036), German (1031).
  • PCF controls: React virtual controls with Fluent UI v9.

ProjectIQ: Copilot bot at the centre, the Power Platform technologies around it and the ProjectIQ features on the outer ring

The problem

Construction and installation companies, engineering firms, workshops and service companies live on jobs. For each job they must know, at any moment, what was planned, what has been spent and what is still committed — and they usually find out too late:

  • the budget lives in a spreadsheet, the plan in another tool, the hours on paper or in a separate time app, the purchases in e-mails and in the accounting system;
  • hours arrive at the end of the month, valued at today's rate instead of the rate of the day they were worked;
  • purchases are approved without seeing the remaining budget, and what has been ordered but not yet delivered is invisible until the invoice arrives;
  • suppliers answer requests for quotation by e-mail in different formats, so comparing them is manual and error-prone;
  • the project manager discovers the loss of margin only when the job is closed.

ProjectIQ puts the whole life cycle of the job in one place, on the Microsoft 365 / Power Platform stack the company already uses, with security by project team, standard auditing and in-app notifications.

flowchart LR
    A[Customer and offer] --> B[Project]
    B --> C[WBS, budget<br/>Gantt, baselines]
    C --> D[Team and<br/>resource load]
    D --> E[Timesheet<br/>and approval]
    D --> F[Materials]
    C --> G[Purchasing:<br/>requests, RFQs, orders]
    G --> H[Goods receipts<br/>and invoices]
    S[Supplier portal] -. quotes and confirmations .-> G
    E & F & H --> K[Actual cost, committed cost,<br/>estimate at completion, margin]
Loading

User manuals

The user manuals describe every functional area in depth, with diagrams, step-by-step procedures, field tables and the messages users may see. They are available in four languages, also as a website at https://projectiq.powerbuilders.org/, and are kept aligned with the application (see Keeping the documentation aligned).

Manual English Italiano Français Deutsch
Getting started EN IT FR DE
Master data (customers, suppliers, items, resources) EN IT FR DE
Projects and team EN IT FR DE
WBS, budget, Gantt and baselines EN IT FR DE
Resource allocation and resource load EN IT FR DE
Time tracking: timesheet, approval, reminders EN IT FR DE
Materials, actual costs and cost summary EN IT FR DE
Purchasing: requests, RFQs, orders, receipts, invoices EN IT FR DE
Documents in SharePoint (projects, orders, supplier documents) EN IT FR DE
Supplier portal EN IT FR DE
Administration: users, security, settings, automations EN IT FR DE
Copilot and Cowork: questions in natural language (read-only) EN IT FR DE
Portfolio Agent: ProjectIQ cards in Microsoft 365 Copilot, hours logged and approved, draft projects from documents EN IT FR DE
Sourcing agent: proposals prepared by the agent and decided by a person, Teams card, Approve / Reject / Retry, roles and setup EN IT FR DE

Technical documentation (English): Development environment setup · Environments and deployment · Data model · Publishing on Microsoft AppSource.

Legal: Privacy statement · Terms of use.

Repository layout

Folder Content
solutions/OpenProject365 Unpacked Dataverse solution (pac solution unpack)
src/plugins C# plugins and Custom API implementations
src/pcf PCF controls (GanttChart, WbsTreeGrid, WeeklyTimesheet, TimeApproval, ResourceLoad, CostSummary, QuoteComparison, ProgressField)
src/webresources Form scripts and dialogs
copilot Business skills and glossary for Copilot (skills, glossary.md); sourcing-agent: Copilot Studio build guide of the sourcing agent; portfolio-agent: SPFx Copilot components and declarative agent (guide)
portal Power Pages supplier portal
appsource AppSource package: Package Deployer project and listing assets (guide)
docs User manuals (docs/<language>/), dev environment setup, data model, ADRs
tools/dataverse Scripts that create schema in the dev environment via the Web API
tools/pcf Push of the PCF controls to an environment
tools/docs Documentation consistency check and documentation website build

Keeping the documentation aligned

The manuals are part of the product. Every pull request that changes a functional behaviour (fields, buttons, statuses, rules, messages, roles, automations) must update the affected manual in all four languages and, when a manual is added or renamed, the table above. English is the reference version; the Italian, French and German manuals follow the same structure, keep UI labels in English as they appear on screen, and translate the explanations.

The CI runs python3 tools/docs/check_docs.py, which fails when a manual is missing in a language, when a relative link or anchor is broken, or when a manual is not linked from this README. Rules for contributors are in CONTRIBUTING.md.

Out of scope

Sales opportunities, mobile app, data migration from legacy systems, AI features (planned as a Cowork plugin).

License

Copyright 2026 Power Builders Italia. Licensed under the Apache License, Version 2.0; see also NOTICE.

About

Open-source project management for Microsoft Dataverse: projects, WBS, Gantt, time & expense tracking, purchasing and a supplier portal, built as a Power Apps model-driven app with PCF controls and Power Pages.

Topics

Resources

Contributing

Security policy

Stars

2 stars

Watchers

0 watching

Forks

Releases

Used by

Contributors

Languages