Engineering
Retail · Purchasing
Supplier Questionnaire App
Survey and evaluation app for purchasing managers, replacing a set of Excel files sent around by mail.
- Duration
- < 5 months
- Budget
- < 20.000 €
- Project team
- MQC 2 · Client 3
End-of-project survey
This client did not answer our end-of-project survey — so there are no scores to show.
The brief
- Give the purchasing team one place to build, manage and distribute supplier questionnaires
- Let regional store managers answer the parts that concern them and redirect the parts that do not
- Replace the Excel-and-email distribution with something that reports in real time
The build
- A canvas Power App for the store managers, with Dataverse behind it and dataflows importing and cleansing the existing data out of Excel
- Distribution through workflows and email, with administrative options for redistribution and changes
- Customisable survey controls managed through a model-driven app
The good
- The existing questionnaires and a precise specification from the purchasing team made the start unusually easy
- A short feedback loop kept development pointed at the result, and the app ended up in use across several countries
- Purchasing managers can redirect and distribute individual parts of a survey themselves
The bad
- Uploading new questionnaires is still unstable: the route is a fixed Excel format, and an import can fail on it
- Managing dataflows across several environments with a refresh triggered from Power Automate remains fragile
- Longer explanatory text next to a question caused layout problems, and the dynamic survey structure was hard to build