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.
Login now to access my digest by 365.Training