Power Automate: retrieving the first item of a recordset avoiding a loop.


In Dynamics 365 Business Central, it's common to use AL code to filter records and retrieve the value of the first record in the filtered set. However, you can achieve the same result using Power Automate without the need for a loop block. Instead, you can use an expression like "first(body(('YourFindRecordActionName')?['value'])?['YourFieldName']" to retrieve the first item of a recordset. This allows you to avoid unnecessary loops in your flow.


Article 15m

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