Share
ReportI have created a Microsoft Form for an IT Ticketing Tool with 4 sections:
1. Employee Code
2. Asset Information
3. Issue Details
4. Attachments
1. Employee Code
2. Asset Information
3. Issue Details
4. Attachments
I have a User Master Excel sheet stored in OneDrive.
The Excel file is formatted as a Table and contains columns like:
EmployeeCode, EmployeeName, Department, Email, AssetTag, AssetType, SerialNumber.
The Excel file is formatted as a Table and contains columns like:
EmployeeCode, EmployeeName, Department, Email, AssetTag, AssetType, SerialNumber.
My requirement:
When a user submits the Microsoft Form, they should enter ONLY the Employee Code.
Using Power Automate, based on the Employee Code:
- Fetch the matching user and asset details from the Master Excel sheet
- Auto-populate those details into the ticket record
- Create a new IT ticket entry (SharePoint List / Excel / Email notification)
When a user submits the Microsoft Form, they should enter ONLY the Employee Code.
Using Power Automate, based on the Employee Code:
- Fetch the matching user and asset details from the Master Excel sheet
- Auto-populate those details into the ticket record
- Create a new IT ticket entry (SharePoint List / Excel / Email notification)
Please give me a step-by-step Power Automate flow:
- Trigger
- Actions
- Filter array condition
- Expressions if required
- Error handling if Employee Code is not found
- Trigger
- Actions
- Filter array condition
- Expressions if required
- Error handling if Employee Code is not found
Categories:
I have the same question (0)
All responses (
Answers (
96
