This article is part of the In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… series, a sub-series of the In Microsoft Dynamics 365 Business Central (Power Automate), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.
There are a number of actions available in Power Automate for Business Central which allow specific actions against the data of Business Central to be performed from within Power Automate.
The 4th action which is available is the Find one record (V3) one which will allow you to search for and return a single record. Previously, if you didn’t have the row Id you needed to use Find recods V3 to search for the records, although you could add a top 1 to limit the return, you still had to manage the return as if there were multiple records; as of the 2024 Wave 1 release, this Find one record V3 action has been made available; the returned data is much simpler to handle, being more along the lines of that returned by the Get record V3 action.
Within a flow, click the add action button; search for Business Central and select the Business Central icon (make sure you select the SaaS one, which is a dark colour instead of the on-premises one which is mainly white):
