Automatically Assign Microsoft Forms Tickets Using Power Automate and Excel
Question details
Set up automatic ticket assignment using form responses and an employee shift roster.
- Product
- Microsoft Power Automate, Microsoft Forms, and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A team collects escalation requests through Microsoft Forms and wants to assign each ticket to an employee who is available during the ticket period.
- Observed behavior
- New form responses should be recorded in Excel and assigned according to the current employee roster.
Create an Excel workbook in OneDrive for Business or SharePoint with a tickets table and a roster table containing employee names, availability status, and shift start and end times. Ensure the form captures the ticket period and that the flow account can access the form and workbook.
Build a Power Automate flow that assigns tickets by shift
Use this approach to evaluate the current roster whenever a new ticket is submitted and record the result in Excel.
Use consistent date and time formats and a common time zone for both ticket periods and roster shifts. The example below selects the first matching employee; it does not balance workload or prevent overlapping assignments.
In Power Automate, select Create > Automated cloud flow. Choose the Microsoft Forms trigger When a new response is submitted, then select your form.
Add the Microsoft Forms action Get response details. Select the same form and use the trigger's Response Id to retrieve the request and ticket period.
Add Excel Online (Business) > List rows present in a table. Select the workbook location, file, and roster table containing employee availability and shift times.
Add a Filter array action using the roster rows as its input. Set conditions for the availability status and require the shift start to be no later than the ticket start and the shift end to be no earlier than the ticket end.
Add a Condition that checks whether the filtered array contains any rows. In the matching branch, select the first employee and use Excel Online (Business) > Add a row into a table to save the ticket and assignee. In the other branch, add the ticket with a Pending status and optionally send a notification for manual assignment.
Select Save and Test, then submit sample responses in Microsoft Forms. Check the flow run history and the Excel tickets table for both a matching shift and a period with no available employee.
Review Ticket and Roster Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative for viewing and editing ticket and roster spreadsheets. Its familiar interface and Excel format compatibility make it easier to move between office suites, although the Microsoft Forms and Power Automate workflow still requires Microsoft services.

Frequently Asked Questions
Where should I store the Excel workbook for the flow?
Store it in OneDrive for Business or SharePoint, and select its location in the Excel Online (Business) actions. Format the roster and ticket ranges as Excel tables so the flow can select them.
What happens if no employee is available?
In the Condition branch for an empty filtered array, use Add a row into a table to record the ticket with a Pending status. You can also add a notification action so someone can assign it manually.
Will this flow distribute tickets evenly?
No. Selecting the first matching roster row may repeatedly assign tickets to the same employee. Round-robin or workload-based assignment requires additional tracking and flow logic.
How do I account for shifts that cross midnight?
Store full shift start and end dates and times rather than times alone. Compare the full ticket period against those values in Filter array, using a consistent time zone.
Can WPS Office run the Microsoft Forms and Power Automate flow?
No. WPS Office can open and edit compatible Excel spreadsheets, but the form trigger and automated assignment flow run through Microsoft Forms and Power Automate.




