Hi @jeremy_brown,
Could you please share a screenshot of your flow's configuration?
Could you please show a bit more about your scenario?
Further, do you want to get a single row without using the "Apply to each" action?
The output of the "Get items" action is an array, so when you reference the Dynamic contents of the "Get items" action within following steps, the flow would add a "Apply to each" action automatically, even though the output of the "Get items" action only contains one row.
If you want to get the single row from the "Get items" action without using a "Apply to each" action, please take a try with the following workaround:
- Add a proper trigger, here I use Flow Button trigger.
- Add a "Get rows" action, specify Table name. Within Filter Query field, type the following formula:
Email eq 'Test1@xxxxxx.onmicrosoft.com'
Note: The Email is a column in my SQL table and each row have a unique Email value.
- Add a "Compose" action, Inputs set to following formula:
first(body('Get_rows')?['value'])
Image reference:
The flow works successfully as below:
In addition, if you want to reference the column values within that single row (as above screenshot), you could consider take a try with the following formula:
outputs('Compose')?['ContactName']
On your side, you should type the following formula:
outputs('Compose')?['ColumnNameOfYourSQLTable']
The flow works successfully as below:
More details about using expression in flow actions, please check the following article:
Use expression in flow actions
Best regards,
Kris
