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):
Find and select the Find one record V3 action:
There are a few parameters for this action which need to be populated:
- Environment which is set to use the variable populated by the trigger.
- Company which is set to use the variable populated by the trigger.
- API category will default to
v2.0
which is the main API available, but there are others to select from, such as a workflow one, which have different tables available. - Table name of the table from which you want to read the record; in this example, I have used countriesRegions.
- Type of order ascending or descending, so you can change the manner in which the record is selected.
- Order results by which field.
- Continue with empty results when no record found allows a break in the flow if no record matches.
The bottom of the action, allows you to enter the filter criteria, which are in three matched fields:
- Filter on this field where you choose which field to filter on.
- Filter operator which contains all of the usual, like equals, not equals, contains, tless than and so on.
- Filter value where you can provide the value to filter the selected field with.
Clicking the Add new item button allows additional fields to be added for filtering.
In Microsoft Dynamics 365 Business Central, how do I…
In Microsoft Dynamics 365 Business Central (Power Automate), how do I…
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.