Hi everyone,
I’m working on an IT Ticketing Tool using Microsoft Forms and Power Automate.
I have created a Microsoft Form with sections for:
- Employee Code
- Asset Information
- Issue Details
- Attachments
I also have a User Master Excel file (stored in SharePoint/OneDrive) formatted as a table.
The table contains columns such as:
EmployeeCode, EmployeeName, Department, Email, AssetTag, AssetType, SerialNumber.
Requirement:
When a user submits the Form, they will enter only the Employee Code & Asset Type.
Using Power Automate, I want to:
- Look up the Employee Code & Asset Type in the Master Excel table
- Fetch the corresponding user and asset details
- Auto-populate those details into the IT ticket record (Excel or SharePoint List)
Current issue:
My flow fails at the “Apply to each / For each” step with the error:
“The result of the evaluation of ‘foreach’ expression must be a valid array.”
I suspect I may be referencing the wrong output from the “List rows present in a table” action.
Could someone please guide me on:
- The correct way to use Filter array and Apply to each
- Which output should be used as the array
- Best practices to avoid this error
Any help or sample expressions would be greatly appreciated.
Thank you!
