Goods Delivery Form Automation
Power Automate flow created to collect delivery data from Microsoft Forms and store it in Excel on SharePoint.
7/1/20251 min read
Goods Delivery Form Automation
Designed a Power Automate flow that captures responses from a Microsoft Form, processes the data, and stores it in a centralized Excel file on SharePoint for easy access and reporting.
Solution Approach
Problem Statement
Manual collection of delivery data from 12 locations was time-consuming and error-prone, leading to inconsistent records and delays in consolidating delivery information.
Impact
Streamlined data collection across all 12 delivery locations.
Eliminated manual entry, reducing errors and saving time.
Centralised data storage enabled real-time access and reporting.
Improved data consistency and traceability for delivery operations.
Key Features & Technologies used
Trigger: Automatically starts when a new Microsoft Form response is submitted.
Data Handling: Parses JSON and retrieves user profile information.
Looping Logic: Uses “Apply to each” to handle multiple entries.
Storage: Creates a new item in an Excel file stored on SharePoint.
Scalability: Supports data collection from 12 delivery locations, all feeding into a single SharePoint repository.
Power Automate, Microsoft Forms, SharePoint, Excel.
