Dynamic Absence Data Logging System The Challenge (Problem): Tracking staff or student absences w...Dynamic Absence Data Logging System The Challenge (Problem): Tracking staff or student absences w...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Craig's avatar
Craig Yeates
• 20h
Dynamic Absence Data Logging System
The Challenge (Problem): Tracking staff or student absences was manual, siloed, and often prone to errors. Reports would come in via form, but the data was not dynamically appended to a central master dataset. Managing multiple overlapping datasets created data integrity risks and delayed consolidated reporting.
The Automation (Solution): I designed an advanced automated logic flow.
Trigger: It launches upon a digital absence form submission.
Data Processing: Instead of just saving the raw data, the flow uses advanced actions: it accesses the centralized group document library, lists the current folder contents, and uses a Filter Array function to isolate and validate relevant records before proceeding.
Integration: It then dynamically loops through the validated results using a 'For Each' control block, and appends the structured absence details (e.g., Student Number, Dates of Absence, Reason) directly into a master Absence Table in Excel.
The Result (Outcome): This modernized the entire reporting workflow. It ensures absence records are dynamically validated against a master database before being logged, guaranteeing data integrity. The centralized, up-to-date dataset now allows for immediate, accurate absence analytics and cross-department reporting.
Tools Used: Microsoft Forms, Power Automate (Advanced Logic, Filter Array, For Each Loops), Excel Online (Structured Table Logging).
Data AnalysisMicrosoft Power AutomatePower AppsMicrosoft Excel
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started