Mighty QuinnConsultingMighty Quinn Consulting — home
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
Tech stack
  • Power Apps
  • Dataverse
  • Power Automate
  • Dataflows
  • Outlook
Our part
  • Conception
  • Development
  • Project Management

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