Power Automate Flight Data Workflow
Budget: ₹12,500 – ₹37,500 INR
I want a single Power Automate flow that pulls new Microsoft Forms submissions containing our pilot checklist items, combines those answers with the corresponding sensor data readings we export from rosbag, writes the merged result into one new row per flight in a master Excel file, and then pings the team as soon as that row appears.
The aim is to streamline data entry. After the flow is in place we should be able to:
• Detect every new Form response automatically
• Match it to the correct rosbag output (CSV or JSON; I can supply a sample)
• Concatenate the two data sets in the order I specify
• Append the full record to “Flight_Data.xlsx” on SharePoint
• Trigger an email or Teams message confirming a new line was created
I will provide the Form, the Excel template with column headers, sample rosbag files. I cannot provide access/credentials to our O365 environment but am willing to collaborate via screensharing. I need the working flow, brief documentation on how to adjust field mapping, and a quick hand-off call so my technicians can maintain it afterward.
The aim is to streamline data entry. After the flow is in place we should be able to:
• Detect every new Form response automatically
• Match it to the correct rosbag output (CSV or JSON; I can supply a sample)
• Concatenate the two data sets in the order I specify
• Append the full record to “Flight_Data.xlsx” on SharePoint
• Trigger an email or Teams message confirming a new line was created
I will provide the Form, the Excel template with column headers, sample rosbag files. I cannot provide access/credentials to our O365 environment but am willing to collaborate via screensharing. I need the working flow, brief documentation on how to adjust field mapping, and a quick hand-off call so my technicians can maintain it afterward.
Related categories:
Data Processing
Data Entry
Excel
Microsoft Access
Sharepoint
JSON
Data Integration
Data Management
Power Automate