Plaza 365
Plaza 365

No results found for your search

RegisterLog in

8

Dynamics 365 Business Central: Power Automate Find Records action demistified.

Visit article

#action

#automate

#records

Dynamics 365 Business Central

Category

Nov 17, 2024

Published date

Text

Article Type

AI Summary

  • The Find records action in Power Automate or Azure Logic Apps returns a collection of records matching applied filters, even if there's only one record.
  • Understanding the syntax of the OData query is crucial when using the Find records action.
  • Business Central APIs apply paging to OData responses to optimize performance and prevent overwhelming the server or client program.
  • Business Central online defaults to a maximum of 20,000 entities per page, while on-premises configurations can adjust page size.
  • The Find records (V3) action in Power Automate has a hard limit of returning 1000 records per page.
  • The Find records (V3) action provides an @odata.nextLink URL for retrieving the next page of records.
  • Using the HTTP action in Power Automate allows for retrieving larger amounts of records from Business Central in a more performant manner.
  • Acquiring a token via OAuth 2 and performing a GET operation to the API endpoint can help in efficiently retrieving all records from Dynamics 365 Business Central.

Registered users can view the full text for FREE!

Sign In Now!