Find a matching record in a Power Automate flow

Important

This content is archived and is not being updated. For the latest documentation, go to What's new or changed in Business Central. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.

Enabled for	Public preview	General availability
Users, automatically	Apr 2, 2024	May 6, 2024

Business value

Using Power Automate to build flows is already relatively easy, but from time to time, makers are stumbling into this common element of a given process: querying Business Central for a single record that matches certain criteria.

Feature details

Currently, the Find records action always returns a collection or list of records, even if there's only one record that matches specific criteria, such as the unique record ID. The current action also requires that Power Automate makers understand the syntax of the OData query.

The new Find one record action not only lets makers find a single record that matches their criteria, but also gives them a more friendly user interface to provide parameters and define conditions.

Makers can select several conditions for various fields in the requested API, add sorting conditions so that the proper record is found, and the Power Automate connector transforms these settings into an OData query.

Finding a single record also ensures that all subsequent actions in the flow can operate on it, without requiring the Apply to each loop.

Note

This feature is only available in Business Central online, but it's in the Power Platform connector so it's backward compatible with all supported versions of Business Central.

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.

See also

Business Central connector (docs)