The article explains how to get the first row or single record column values from a List Row action without a loop in Power Automate using Dataverse. When retrieving a record from Dataverse or any data source using filter conditions with List Rows, it returns matching records from the table that can be used in a loop for further action steps in Power Automate. However, when you have no primary key value and want to read a record using other filters, you use List Rows, which only contains one record. To avoid a loop, use the expression "first(outputs('List_rows')?['body/value'])?['emailaddress1']" inside compose.
Login now to access my digest by 365.Training