In Dynamics 365 Business Central it’s quite common to do operations in AL code for filtering a set of records and then retrieving a value of the first record of the filtered recordset. Something like in the following code, where we filter the Item table for retrieving the first item with Unit Price greater than 1000:
Let’s imagine now to use Power Automate to do the same thing. We can…
Continue Reading demiliani’s Article on their blog
Power Automate: retrieving the first item of a recordset avoiding a loop.
In Dynamics 365 Business Central it’s quite common to do operations in AL code for filtering a set of records and then retrieving a value of the first record of the filtered recordset. Something like in the following code, where we filter the Item table for retrieving the first item with Unit Price greater than…
Blog Syndicated with demiliani’s Permission
More About This Author
Array
Business Central2 May 2024AI in fully locked Dynamics 365 Business Central environment? Yes, you can!
Business Central24 April 2024Dynamics 365 Business Central: Edit in Excel and Long Running SQL queries
Business Central15 April 2024Dynamics 365 Business Central 2024 Wave 2 release plans: “as is” and “to be”
Business Central10 April 2024Dynamics 365 Business Central and Shopify connection: access key rotation.
