Power Apps · Infrastructure and real estate
Power Apps procurement portal that controls purchase orders against project budgets
A Power Apps purchase order system for a construction company. Supplier and client masters feed the form, and live budget, credit and PO history panels guard every order.
- Client
- A construction company running several projects with site teams, suppliers and a head office purchase team
- Industry
- Infrastructure and real estate
- Platform
- Power Apps
- Started from
- Procurement Management product
01The challenge
Purchase orders, supplier details and project budgets lived in separate sheets. Buyers retyped item names, codes, rates and addresses for every order. Nobody could see how much of a project budget was already committed, or how much credit a supplier had used, until the money had gone.
02The solution
We built a Power Apps portal around the purchase order. The buyer picks the project and supplier, and panels show the project budget, the orders already raised and the supplier's credit, limit and outstanding. Item lines carry BOQ code, brand, code and HSN code with default and alternate units, and GST is worked out per line and totalled. Business partner and client masters, each with several addresses, keep the details clean.
How a purchase order is raised
- Pick the projectThe buyer chooses the project. The director, manager and budget cost appear under it, with the due date and the commercials panel.
- Pick the supplierThe supplier fills the address, credit days and primary category, and shows credit limit and outstanding. The credit rating and the supplier's earlier purchase orders appear on the right.
- Set terms and deliveryThe buyer sets required by date, terms of payment, destination, dispatch and delivery terms. Optional extra terms can be added with a toggle.
- Check the budgetBudget cost, total PO raised and balance update from the project master, and earlier orders for the project and the supplier are listed beside the form.
- Add item linesEach line takes item, BOQ code, brand, code and HSN code, with default and alternate units, quantity, rate and discount. New brands and codes can be added to the master from the form.
- Review the totalsThe lines table shows GST per line. The totals give basic amount, IGST, CGST, SGST and gross amount.
- Generate the POThe buyer presses Generate PO to issue the order, or Close to leave the form.
- Keep masters cleanBusiness partner and client masters hold company, tax, bank and credit details with several addresses, and validate mobile number and email as the user types.
Screens from the system
Sample data only. These screens show the layout and flow, not real records.
Screen 1 of 4Built for this client
Purchase order form
Project, supplier, terms and delivery on the left, with project, budget, order history and supplier credit panels on the right.
What we built
- Purchase order formProject, supplier, terms and delivery in one form.
- Budget panelBudget cost, total raised and balance for the project.
- Supplier credit panelCredit rating, limit, outstanding and earlier orders.
- Item linesBOQ code, brand, code and HSN code with default and alternate units.
- GST totalsIGST, CGST and SGST per line and in total.
- Business partner masterVendor details, bank and credit with several addresses.
- Client masterClient details, status and several addresses with validation.
- Add to masterNew brands, codes and HSN codes added from the form.
Built with Power Apps · Microsoft 365 sign in · Master lists
The result
- Budget, orders raised and balance shown on the purchase order form
- Supplier credit, limit and outstanding visible before the order is raised
- GST worked out per line and totalled on the purchase order
- Business partner and client masters with several addresses each
Related services
Procurement Management product
The ready-made product this work is based on.
Learn more →Power Apps services
Business apps built on the Microsoft Power Platform.
Learn more →Power Apps development
Custom apps for approvals, field work and operations.
Learn more →Infrastructure and real estate work
How we help companies in this sector.
Learn more →More case studies
Azure OCR that makes scanned lease documents searchable in SharePoint
A document conversion module on Microsoft Azure, connected to SharePoint Online. Each published scan becomes a searchable PDF, so users can find the words inside long lease agreements.
Read the case study →SharePoint · Infrastructure and real estateConfigurable document management system where admins build their own libraries
A SharePoint document management system where admins create tiles, fields, folder templates and approval rules without a developer. Each new project gets its folders, approvers and permissions from a template.
Read the case study →Planning something similar?
Tell us what you need. The first call is free.