Hi everyone,
I'm working on a Power Automate flow for a leave request process, and I’m running into an issue with the Select action. I’d appreciate any guidance on this.
Flow Overview:
- Trigger: When an item is created in a Microsoft List (contains fields like EmployeeCode, EmployeeName, DepartmentName, DateStarted, DateEnded)
- Action - Get rows (V2) "Get rows Employee":
Connects to on-prem SQL Server, table: Dim_Employees
Filter Query:
- EmployeeCode eq '@{triggerOutputs()?['body/EmployeeCode']}'
- Action - Get rows (V2) "Get rows Managers":
Reuses the same Dim_Employees table
Filter Query:
- DepartmentID eq @{body('Get_rows_Employee')?['value'][0]?['DepartmentID']} and RoleLevel eq 2
- Action - Compose:
- body('Get_rows_Managers')?['value']
- Action - Select:
From: @{outputs('Compose')}
Map:
- {
- "Email": "@{item()?['Email']}"
- }
- Action - Join:
From: @{body('Select')}
Join with delimiter: ;
Problem:
The flow fails at the Select action with this error:
“Action ‘Select’ failed: The ‘from’ property value in the ‘select’ action inputs is of type ‘String’. The value must be an array.”
However, when I check the output of the Compose step (body('Get_rows_Managers')?['value']), it clearly looks like an array of objects:
{
"0.Email": "Yasuo@test.com",
"1.Email": "Test@Test.com",
...
}
Here’s a simplified version of the output (some fields omitted for brevity):
0.EmployeeCode: 123
0.Email: Yasuo@test.com
1.EmployeeCode: 456
1.Email: Test@Test.com
SQL Table Structure: I have included a screenshot of the Employees table structure
Any help or advice is greatly appreciated!
Thanks
