Get first row or single record column values from a List Row action without Loop in Power Automate using Dataverse


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.


Article 18m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time